Azure Solutions Architect Expert
Domain 2Objective 1
Design Data Storage Solutions for Relational Data AZ-305 Practice Questions (Page 8)
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 36–39
- 36
A company runs a large reporting workload on Azure SQL Database. The database is 2 TB and the reporting queries are complex and long-running. The company wants to improve query performance and scalability. The solution must support databases larger than 4 TB and provide fast backup/restore. What should you recommend?
Select an answer first - 37
A database is reaching its size limit, and the customer wants to distribute data across multiple databases to scale out. Which technique should they use?
Select an answer first - 38
A database has intermittent usage with periods of inactivity. The customer wants to minimize cost during idle periods and is willing to accept a pause in compute. Which Azure SQL Database service tier is designed for this scenario?
Select an answer first - 39
A database workload is highly variable, with periods of low activity and occasional bursts. The customer wants to pay only for the compute they use and is willing to accept a brief pause during idle times. Which compute tier should they choose?
Select an answer first
Finished these 4 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.