For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAzure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 6Question 18
    Hard1 markMultiple Choice
    Domain 2.1: Relational Data StorageDomain 2.1High AvailabilityAzure SQL

    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)

    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

    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.
    Question 17All questionsQuestion 19

    Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    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
    View all 55 questions →