Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your company runs an e-commerce application on a single Azure SQL Database in the General Purpose service tier located in the East US region. After several regional outages, leadership asks you to redesign the data layer to achieve these goals:

  • At least 99.99 percent availability even if an Azure region becomes unavailable.
  • Automatic failover with a recovery time objective (RTO) of no more than five minutes and minimal data loss (RPO of a few seconds).
  • Ability to off-load read-only traffic to a secondary replica in another region.
  • No requirement to manage Windows or Linux virtual machines.

Which solution should you recommend?

  • Upgrade the database to the Business Critical service tier and configure an Azure SQL Database auto-failover group with a geo-secondary replica in a paired Azure region.

  • Deploy an Azure SQL Managed Instance in the General Purpose tier with zone redundancy enabled in the current region.

  • Migrate to SQL Server 2022 on Azure Virtual Machines in an availability set across two availability zones and configure an Always On failover cluster instance.

  • Migrate to Azure Database for PostgreSQL Flexible Server with zone-redundant high availability enabled.

Microsoft Azure Solutions Architect Expert AZ-305
Design business continuity 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.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot