An e-commerce company uses Azure SQL Database for its product catalog. The database receives a high volume of read-only queries from a reporting application, while the main application performs writes. The reporting queries are causing performance degradation for the main application. You need to offload the reporting traffic without changing the application code. What should you recommend?

Use Azure SQL Database elastic pools to share resources between the two applications.

Enable read scale-out on the database and point the reporting application to the read-only endpoint.

Increase the database to a higher service tier to handle the additional read load.

Create a second database and replicate data using transactional replication.

A database is experiencing performance issues due to insufficient CPU. The customer wants to increase the compute capacity of the existing database without changing its architecture. Which approach is a vertical scaling technique?

Increasing the service tier or DTU/vCore allocation

A company requires a disaster recovery solution for their Azure SQL Database with a recovery time objective (RTO) of minutes and a recovery point objective (RPO) of seconds. They want automatic failover to a secondary database in another region. Which solution should they use?

Geo-restore of geo-redundant backups

A company is migrating a legacy on-premises SQL Server database to Azure. The database uses linked servers, SQL Server Integration Services (SSIS), and common language runtime (CLR) stored procedures. The company wants to minimize migration effort and avoid rewriting code. Which Azure service should you recommend?

SQL Server on Azure Virtual Machines

Azure Solutions Architect Expert

Domain 2Objective 1

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

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 21–25

21application · medium
An e-commerce company uses Azure SQL Database for its product catalog. The database receives a high volume of read-only queries from a reporting application, while the main application performs writes. The reporting queries are causing performance degradation for the main application. You need to offload the reporting traffic without changing the application code. What should you recommend?
Select an answer first
22foundation · easy
A database is experiencing performance issues due to insufficient CPU. The customer wants to increase the compute capacity of the existing database without changing its architecture. Which approach is a vertical scaling technique?
Select an answer first
23foundation · easy
A company requires a disaster recovery solution for their Azure SQL Database with a recovery time objective (RTO) of minutes and a recovery point objective (RPO) of seconds. They want automatic failover to a secondary database in another region. Which solution should they use?
Select an answer first
24application · medium
A company is migrating a legacy on-premises SQL Server database to Azure. The database uses linked servers, SQL Server Integration Services (SSIS), and common language runtime (CLR) stored procedures. The company wants to minimize migration effort and avoid rewriting code. Which Azure service should you recommend?
Select an answer first
25foundation · easy
A workload requires predictable performance with a reserved amount of compute and storage, and the customer wants to pay a fixed price per month. Which Azure SQL Database service tier should be recommended?
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 5)

Questions 21–25

A database is experiencing performance issues due to insufficient CPU. The customer wants to increase the compute capacity of the existing database without changing its architecture. Which approach is a vertical scaling technique?

A company requires a disaster recovery solution for their Azure SQL Database with a recovery time objective (RTO) of minutes and a recovery point objective (RPO) of seconds. They want automatic failover to a secondary database in another region. Which solution should they use?

A workload requires predictable performance with a reserved amount of compute and storage, and the customer wants to pay a fixed price per month. Which Azure SQL Database service tier should be recommended?

Keep studying — Design data storage solutions