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

Planning for database backups

In the previous section, we looked at using Azure Backup to create backup and restore policies for VMs, including SQL on VMs.

One of the core offerings of Azure is Azure SQL, a managed database offering with complete flexibility and scalability. However, the Azure Backup solution we looked at for VMs and SQL on VMs is not the same backup solution we use for Azure SQL Database or Azure SQL Managed Instance.

Understanding Azure SQL backups

As managed services, backups are part of the platform, and by default, databases have full backups taken every week, differential backups every 12-24 hours, and transaction log backups every 5-10 minutes. Backups are also retained for 7 days – this means that as soon as you create an Azure SQL database or Azure SQL managed instance, your data is protected so that you can restore data from any point up to 7 days with recovery points every 5-10 minutes.

Backups, by default, are also geo-redundant. This allows...