You're reading from Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond Design secure and reliable solutions for the real world in Microsoft Azure

Product type Paperback

Published in Jul 2021

Publisher Packt

ISBN-13 9781800566934

Length 520 pages

Edition 1st Edition

Languages

SQL

Tools

Azure

Concepts

Cloud Computing

Author (1):

Brett Hargreaves

View More author details

Table of Contents (30) Chapters

Preface

1. Section 1: Exploring Modern Architecture

2. Chapter 1: Architecture for the Cloud FREE CHAPTER

3. Chapter 2: Principles of Modern Architecture

4. Section 2: Identity and Security

5. Chapter 3: Understanding User Authentication

6. Chapter 4: Managing User Authorization

7. Chapter 5: Ensuring Platform Governance

8. Chapter 6: Building Application Security

9. Section 3: Infrastructure and Storage Components

10. Chapter 7: Designing Compute Solutions

11. Chapter 8: Network Connectivity and Security

12. Chapter 9: Exploring Storage Solutions

13. Chapter 10: Migrating Workloads to Azure

14. Section 4: Applications and Databases

15. Chapter 11: Comparing Application Components

16. Chapter 12: Creating Scalable and Secure Databases

17. Chapter 13: Options for Data Integration

18. Chapter 14: High Availability and Redundancy Concepts

19. Section 5: Operations and Monitoring

20. Chapter 15: Designing for Logging and Monitoring

21. Chapter 16: Developing Business Continuity

22. Chapter 17: Scripted Deployments and DevOps Automation

23. Section 6: Beyond the Exam

24. Chapter 18: Engaging with Real-World Customers

25. Chapter 19: Enterprise Design Considerations

26. Mock Exam

27. Mock Answers

28. Assessments

29. Other Books You May Enjoy

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...