Microsoft Azure Architect Design (AZ-301) Practice Exam

For optimal management of database backups that need to remain compliant for several years, which Azure service is most appropriate?

1. Azure Blob Storage with archive tier

2. Azure SQL Database

3. Azure Table Storage

4. Azure Backup Service

The correct answer is: Azure Blob Storage with archive tier

The best option for managing database backups that must remain compliant for several years is Azure Blob Storage with the archive tier. This service is specifically designed for long-term storage of data that is not frequently accessed but needs to be retained for compliance and regulatory purposes. The archive tier provides a cost-effective solution for storing large amounts of data that are rarely retrieved but must be kept available for future access when needed. Using Azure Blob Storage allows for flexibility in managing backup data. You can set lifecycle management policies to automatically move data between different access tiers based on your retrieval needs, further optimizing costs and ensuring compliance management as requirements change over time. In contrast, Azure SQL Database is a relational database service that provides built-in backup capabilities, but it is more suited for operational databases rather than long-term storage of backups. Azure Table Storage is a service designed for storing large amounts of structured, non-relational data but does not offer the tiered storage options suitable for compliance needs. Azure Backup Service is focused on providing backup solutions for various Azure workloads and on-premises environments but may not provide the same level of long-term, cost-effective storage optimization as Azure Blob Storage with the archive tier. Therefore, selecting Azure Blob Storage with the archive tier is the optimal choice for managing long-term