A company wants to ensure that their Azure SQL Database can be restored in the event of a regional outage. They need a backup that is stored in a different region. Which backup option should they use?

Read-access geo-redundant storage

Locally redundant backup storage

A company runs a production database on Azure SQL Database in the General Purpose tier with 4 vCores. The database experiences high I/O latency during peak hours. The company wants to improve I/O performance without changing the application code. What should you recommend?

Use an elastic pool to add more I/O resources.

Move to the Business Critical tier with 4 vCores.

Increase the vCores to 8 in the General Purpose tier.

Enable read scale-out to offload read queries.

A healthcare company runs a critical patient-records database on Azure SQL Database in the East US region. The compliance team requires that the database can be restored to a point in time within the last 72 hours, and that a copy of the database is available in a secondary region for disaster recovery. The company wants to minimize management overhead. What should you configure?

Enable active geo-replication and configure automatic failover with a 72-hour grace period

Configure point-in-time restore with a 72-hour retention and enable geo-replication

Configure long-term backup retention for 72 hours and use a backup to restore in the secondary region

Use Azure Backup for SQL Database and replicate the backup vault to a secondary region

A retail company is migrating its on-premises order-processing database to Azure SQL Database. The workload is a mission-critical OLTP system that must remain available during a regional outage. The database is 500 GB and the application requires low-latency reads and writes. The company wants to minimize administrative overhead while ensuring automatic failover to a secondary region. Which service tier and configuration should you recommend?

Hyperscale tier with a geo-replicated secondary in another region

Serverless tier with a read replica in the same region

General Purpose tier with active geo-replication to a secondary region

Business Critical tier with a zone-redundant configuration

Azure Solutions Architect Expert

Domain 2Objective 1

Design Data Storage Solutions for Relational Data AZ-305 Practice Questions (Page 4)

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

39questions here

8free pages

10concepts

Questions 16–20

16foundation · easy
A company wants to ensure that their Azure SQL Database can be restored in the event of a regional outage. They need a backup that is stored in a different region. Which backup option should they use?
Select an answer first
17application · medium
A company runs a production database on Azure SQL Database in the General Purpose tier with 4 vCores. The database experiences high I/O latency during peak hours. The company wants to improve I/O performance without changing the application code. What should you recommend?
Select an answer first
18foundation · easy
A company wants to ensure that their Azure SQL Database remains available during a datacenter failure within a region. They need a solution that provides automatic failover to a secondary replica in a different availability zone. Which feature should they use?
Select an answer first
19application · medium
A healthcare company runs a critical patient-records database on Azure SQL Database in the East US region. The compliance team requires that the database can be restored to a point in time within the last 72 hours, and that a copy of the database is available in a secondary region for disaster recovery. The company wants to minimize management overhead. What should you configure?
Select an answer first
20application · medium
A retail company is migrating its on-premises order-processing database to Azure SQL Database. The workload is a mission-critical OLTP system that must remain available during a regional outage. The database is 500 GB and the application requires low-latency reads and writes. The company wants to minimize administrative overhead while ensuring automatic failover to a secondary region. Which service tier and configuration should you recommend?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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 Data Storage Solutions for Relational Data AZ-305 Practice Questions (Page 4)

Questions 16–20

A company wants to ensure that their Azure SQL Database can be restored in the event of a regional outage. They need a backup that is stored in a different region. Which backup option should they use?

A company runs a production database on Azure SQL Database in the General Purpose tier with 4 vCores. The database experiences high I/O latency during peak hours. The company wants to improve I/O performance without changing the application code. What should you recommend?

A company wants to ensure that their Azure SQL Database remains available during a datacenter failure within a region. They need a solution that provides automatic failover to a secondary replica in a different availability zone. Which feature should they use?

Keep studying — Design data storage solutions