Azure Solutions Architect Expert
Domain 2Objective 1
Design Data Storage Solutions for Relational Data AZ-305 Practice Questions (Page 2)
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 6–10
- 6
A company runs a development database on Azure SQL Database. The database is used only during business hours and can be unavailable outside those hours. The company wants to minimize cost. Which compute tier should you recommend?
Select an answer first - 7
A relational database is experiencing increased read traffic, and the customer wants to offload read queries to a separate endpoint to improve performance. Which Azure SQL Database feature should they use?
Select an answer first - 8
A relational database is experiencing high read traffic, and the customer wants to distribute read queries across multiple copies of the database. Which technique is a horizontal scaling solution?
Select an answer first - 9
A company needs a disaster recovery solution for their Azure SQL Database that allows them to restore the database to a different region in the event of a regional outage. They want to minimize data loss and have a recovery time objective (RTO) of a few hours. Which solution should they use?
Select an answer first - 10
A social media company runs a user-post database on Azure SQL Database. The database has grown to 2 TB and the company is experiencing performance degradation due to the high volume of read and write operations. The company wants to scale the database to improve performance and support future growth. Which solution should you recommend?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.