AZ-305 · Question #270
AZ-305 Question #270: Real Exam Question with Answer & Explanation
The correct answer is C: Azure SQL Database Business Critical. To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the
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 Managed Instance Business Critical
- BAzure SQL Managed Instance General Purpose
- CAzure SQL Database Business Critical
- DAzure SQL Database Serverless
Explanation
To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the primary node crashes for any reason, there is always a fully synchronized node to fail over to.
Community Discussion
No community discussion yet for this question.