Book Image

Implementing Microsoft Azure Architect Technologies: AZ-303 Exam Prep and Beyond - Second Edition

By : Brett Hargreaves, Sjoukje Zaal
Book Image

Implementing Microsoft Azure Architect Technologies: AZ-303 Exam Prep and Beyond - Second Edition

By: Brett Hargreaves, Sjoukje Zaal

Overview of this book

From designing solutions on Azure to configuring and managing virtual networks, the AZ-303 certification validates your knowledge and skills for all this and much more. Whether you want to take the certification exam or gain hands-on experience in administering, developing, and architecting Azure solutions, this study guide will help you get started. Divided into four modules, this book systematically takes you through the wide range of concepts and features covered in the AZ-303 exam. The first module demonstrates how to implement and monitor infrastructure. You'll develop the skills required to deploy and manage core Azure components such as virtual machines, networking, storage, and Active Directory (AD). As you progress, you'll build on that knowledge and learn how to create resilient and secure applications before moving on to working with web apps, functions, and containers. The final module will get you up to speed with data platforms such as SQL and Cosmos DB, including how to configure the different high availability options. Finally, you'll solve mock tests and assess yourself with the answers provided to get ready to take the exam with confidence. By the end of this book, you'll have learned the concepts and techniques you need to know to prepare for the AZ-303 exam and design effective solutions on Microsoft Azure.
Table of Contents (25 chapters)
1
Section 1: Implement and Monitor Azure Infrastructure
10
Section 2: Implement Management and Security Solutions
14
Section 3: Implement Solutions for Apps
18
Section 4: Implement and Manage Data Platforms
21
Chapter 17: Mock Exam Questions
22
Chapter 18: Mock Exam Answers

Publishing a SQL database

One of the requirements for the AZ-303 exam is knowing how to migrate a database from an existing on-premises database into Azure.

There are actually a number of different ways we can achieve this, the most obvious being to perform a backup and restore operation.

However, SQL Server Management Studio contains a built-in wizard that makes the process of moving databases easy.

In this example, we are going to publish a database that resides on an on-premises database server to Azure:

Important note

For the following example, I have set up a Windows server running SQL Server Express and SQL Server Management Studio. I have also opened my Azure SQL Server firewall to allow my Windows server to connect. A T-SQL script to create and populate a simple database can be found at the GitHub link in the Technical requirements section.

  1. On a computer, run SQL Server Management Studio.
  2. Connect to the local server.
  3. Right-click Databases and...