You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without a...
Microsoft AZ-305 Exam
Questions Number: 82 out of 268 Questions
30.60%
Question 82
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?
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. Incorrect: Not A: Hyperscale is more expensive than Premium. Not C: Need Premium for Availability Zones. Not D: Zone redundant configuration that is free on Azure SQL Premium is not available on Azure SQL Managed Instance. Reference: https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium-databases-and-elastic-pools/
