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: 117 out of 268 Questions
43.66%
Question 117
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?
Now your new and existing serverless Azure SQL Databases allow for zone redundant configuration. This feature utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region. By selecting zone redundancy, you can make your serverless databases resilient to a much larger set of failures, including catastrophic datacenter outages-without any changes of the application logic. The SQL Database serverless compute tier optimizes price-performance and simplifies performance management for single databases with intermittent, unpredictable usage by auto-scaling compute and billing for compute used per second. Incorrect: Not B: Azure SQL Database Business Critical is a more expensive solution. Not C: Azure SQL Database Basic does not provide zone redundancy. Not D: Azure SQL Database Standard is a more expensive solution. Reference: https://azure.microsoft.com/en-us/updates/public-preview-zone-redundant-configuration-for-azure-sql-database-serverless-compute-tier/