AZ-305 · Question #270
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
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
Options
- AAzure SQL Managed Instance Business Critical
- BAzure SQL Managed Instance General Purpose
- CAzure SQL Database Business Critical
- DAzure SQL Database Serverless
How the community answered
(31 responses)- A10% (3)
- B16% (5)
- C71% (22)
- D3% (1)
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.