Book Image

Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond

By : Brett Hargreaves
Book Image

Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond

By: Brett Hargreaves

Overview of this book

The AZ-304 exam tests an architect's ability to design scalable, reliable, and secure solutions in Azure based on customer requirements. Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond offers complete, up-to-date coverage of the AZ-304 exam content to help you prepare for it confidently, pass the exam first time, and get ready for real-world challenges. This book will help you to investigate the need for good architectural practices and discover how they address common concerns for cloud-based solutions. You will work through the CloudStack, from identity and access through to infrastructure (IaaS), data, applications, and serverless (PaaS). As you make progress, you will delve into operations including monitoring, resilience, scalability, and disaster recovery. Finally, you'll gain a clear understanding of how these operations fit into the real world with the help of full scenario-based examples throughout the book. By the end of this Azure book, you'll have covered everything you need to pass the AZ-304 certification exam and have a handy desktop reference guide.
Table of Contents (30 chapters)
1
Section 1: Exploring Modern Architecture
4
Section 2: Identity and Security
9
Section 3: Infrastructure and Storage Components
14
Section 4: Applications and Databases
19
Section 5: Operations and Monitoring
23
Section 6: Beyond the Exam
26
Mock Exam
27
Mock Answers

Chapter 12

The first question to answer when designing a database solution is: What type of database do we need—SQL or NoSQL? The requirements state that the data will be highly relational, meaning it will be built from multiple tables that are linked, and that the integrity of that data is essential. This scenario makes Azure SQL Database and Azure SQL Managed Instance the best choice.

The next requirement is to keep costs low initially but be able to scale up as the platform grows. Azure SQL Database, using the Hyperscale tier, is the best option here as data and processing are separate and individually scalable. As growth will be controlled and managed by the team, dynamic scaling, such as that provided by the Serverless tier, is not required.

Finally, the Hyperscale tier supports creating multiple read-only replicas. A read-only replica can therefore be used for the reporting side of the solution, which will remove any potential performance impact on the primary read...