Azure Solutions Architect Expert
Domain 2Objective 1
Design Data Storage Solutions for Relational Data AZ-305 Practice Questions (Page 3)
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 11–15
- 11
A company wants to migrate an existing SQL Server instance to Azure with minimal changes, including support for SQL Server Agent jobs and cross-database queries. Which Azure service should they use?
Select an answer first - 12
A company needs to protect their Azure SQL Database from accidental data loss or corruption. They want a solution that allows them to restore the database to a specific point in time. Which feature should they use?
Select an answer first - 13
A company runs an online transaction processing (OLTP) application on Azure SQL Database. The database is currently in the General Purpose tier with 4 vCores. The application experiences high CPU usage during peak hours, and the company wants to improve performance without changing the application code. What should you recommend?
Select an answer first - 14
A global bank runs a customer-account database on Azure SQL Database in the West Europe region. The bank requires that in the event of a regional outage, the database can be failed over to a secondary region with minimal data loss. The bank also needs to be able to restore the database to a specific point in time for auditing purposes. Which solution should you recommend?
Select an answer first - 15
A startup is building a multi-tenant SaaS application. Each tenant has its own database, and the number of tenants is growing rapidly. The databases have varying usage patterns, with some tenants using more resources than others. The company wants to optimize cost while ensuring each tenant gets adequate performance. What 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.