ExpertHard1 markMultiple Choice
AZ-305 · Question 18 · Domain 2.1: Relational Data Storage
You are designing a high-availability architecture for an Azure SQL Database. The application requires read-scale out to offload reporting queries, and it must automatically failover to a secondary region if the primary region goes offline. The application connection string cannot be changed during a failover. Which THREE features should you implement? (Select THREE)
You are designing a high-availability architecture for an Azure SQL Database. The application requires read-scale out to offload reporting queries, and it must automatically failover to a secondary region if the primary region goes offline. The application connection string cannot be changed during a failover. Which THREE features should you implement? (Select THREE)
Answer options:
A.
Auto-failover groups.
B.
Active geo-replication.
C.
Read-only listener endpoint.
D.
Azure Traffic Manager.
E.
Read-write listener endpoint.
F.
Always Encrypted.
How to approach this question
Identify the SQL feature that provides automatic regional failover and static connection endpoints.
Full Answer
A,C,E
Auto-failover groups provide automatic regional failover. They utilize read-write and read-only listener endpoints, allowing applications to maintain the same connection string during a failover and offload read queries.
Common mistakes
Selecting Active geo-replication, which requires application logic to handle failover and connection string changes.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees. They operate a mix of on-pre...MediumQ02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...HardQ03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...HardQ04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...EasyQ05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium