Azure Solutions Architect Expert
Domain 2Objective 1
Design Data Storage Solutions for Relational Data AZ-305 Practice Questions (Page 1)
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 1–5
- 1
A database workload requires a consistent amount of CPU and memory at all times, and the customer wants to avoid any performance variability. Which compute tier should they select for Azure SQL Database?
Select an answer first - 2
A company has a production Azure SQL Database in the East US region. The disaster recovery plan requires a recovery time objective (RTO) of 1 hour and a recovery point objective (RPO) of 5 minutes. The company wants to minimize cost while meeting these requirements. Which solution should you recommend?
Select an answer first - 3
A company needs to store relational data with a schema that may change over time. They require a managed database service that supports T-SQL and provides built-in high availability. Which Azure service should they choose?
Select an answer first - 4
A company requires a high availability solution for their Azure SQL Database that provides automatic failover to a secondary replica in a different Azure region. Which feature should they use?
Select an answer first - 5
A company runs a large data warehouse workload on Azure SQL Database. The database is 10 TB and the workload is primarily read-heavy with occasional large writes. The company wants to minimize cost while ensuring fast query performance. Which service tier 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.