Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You manage a business-critical single Azure SQL Database deployed in the East US 2 region. Compliance rules state that the application must remain available with an RPO under 5 seconds and an RTO of about one minute if the entire region becomes unavailable. The solution should require no code changes and keep the same database name after a failover. Which Azure feature should you implement to meet these requirements?

  • Rely on geo-restore from automated backups when a regional outage occurs.

  • Deploy the database with zone-redundant high availability within East US 2.

  • Configure an auto-failover group with a secondary database in another Azure region.

  • Enable active geo-replication and plan a manual failover procedure.

Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot