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

Chapter 16: Developing Solutions that Use a Relational Database

In the previous chapter, we covered the first part of the Implement and Manage Data Platforms objective, by covering how to develop solutions that use Cosmos DB storage. We've covered how to create, read, update, and delete data by using appropriate APIs, and more.

In this chapter, we are continuing with this objective. We are going to cover how to develop solutions that use a relational database. We are going to cover how to provision and configure relational databases, how to configure elastic pools for Azure SQL Database, and how to create, read, update, and delete data tables using code.

We will then set up SQL in a highly available failover group with geo-replication, and then finish off with a look at how to publish on-premises databases to Azure.

The following topics will be covered in this chapter:

  • Understanding Azure SQL Database
  • Provisioning and configuring an Azure SQL database
  • ...