AZ-305 · Question #155
AZ-305 Question #155: Real Exam Question with Answer & Explanation
The correct answer is D: Azure SQL Database Premium. Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99% availa
Question
You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must remain available in the event of a zone outage. - Costs must be minimized Which deployment option should you use?
Options
- AAzure SQL Database Standard
- BAzure SQL Database Serverless
- CAzure SQL Managed Instance General Purpose
- DAzure SQL Database Premium
Explanation
Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99% availability SLA and RPO=0. With the introduction of Azure Availability Zones, we are happy to announce that SQL Database now offers built-in support of Availability Zones in its Premium service tier. https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium- databases-and-elastic-pools/
Community Discussion
No community discussion yet for this question.