A company runs an e-commerce application that uses Azure SQL Database in a single region. The application must remain available if the primary database becomes unavailable due to a regional outage. The recovery point objective (RPO) is 5 seconds, and the recovery time objective (RTO) is 1 hour. What should you configure?

Configure a long-term backup retention policy

Enable active geo-replication to a secondary database in another region and configure automatic failover

Enable point-in-time restore with a retention period of 35 days

Deploy the database on a SQL Server VM in an availability set

A company runs SQL Server 2019 on two Azure VMs in the same region. They need database-level high availability with automatic failover and no data loss. The VMs are in an availability set. What should you configure?

A SQL Server Failover Cluster Instance using shared storage on an Azure shared disk.

An Always On Availability Group with a synchronous-commit secondary replica and an automatic failover partner.

Database mirroring with a high-safety mode and a witness server.

Log shipping from the primary to the secondary VM with a job that restores the database on failure.

A company runs a line-of-business application that uses Azure SQL Database in the primary region. The application has a strict RPO of 5 seconds and an RTO of 15 minutes. The company also runs a reporting workload that can tolerate 1 hour of data staleness. The reporting workload must not impact the production workload. You need to design a high-availability solution that meets the RPO/RTO and supports reporting. What should you recommend?

Use active geo-replication with a secondary that is not readable and fail over manually

Use a failover group with a readable secondary and route reporting queries to the secondary

Use point-in-time restore and a separate reporting database that is refreshed hourly

Use a SQL Server VM with Always On Availability Groups and a read-only routing list

Azure Solutions Architect Expert

Domain 3Objective 2

Design for High Availability AZ-305 Practice Questions (Page 5)

Part of the Design business continuity solutions domain, which makes up ~13% of our current practice bank. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~7–10 in this domain), expect 4–5 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

11concepts

Questions 21–23

21application · medium
A company runs an e-commerce application that uses Azure SQL Database in a single region. The application must remain available if the primary database becomes unavailable due to a regional outage. The recovery point objective (RPO) is 5 seconds, and the recovery time objective (RTO) is 1 hour. What should you configure?
Select an answer first
22application · medium
A company runs SQL Server 2019 on two Azure VMs in the same region. They need database-level high availability with automatic failover and no data loss. The VMs are in an availability set. What should you configure?
Select an answer first
23expert · hard
A company runs a line-of-business application that uses Azure SQL Database in the primary region. The application has a strict RPO of 5 seconds and an RTO of 15 minutes. The company also runs a reporting workload that can tolerate 1 hour of data staleness. The reporting workload must not impact the production workload. You need to design a high-availability solution that meets the RPO/RTO and supports reporting. What should you recommend?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to AZ-305

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “AZ-305” is a trademark of its owner, used for identification only.

Design for High Availability AZ-305 Practice Questions (Page 5)

Questions 21–23

A company runs SQL Server 2019 on two Azure VMs in the same region. They need database-level high availability with automatic failover and no data loss. The VMs are in an availability set. What should you configure?

Keep studying — Design business continuity solutions