A manufacturing company runs a SQL Server database on Azure Virtual Machines. The database supports a production planning system that has grown over time. The current VM has 8 vCPUs and 32 GB RAM, and the database is experiencing high CPU usage during peak hours. The company wants to increase performance with minimal downtime and without changing the application. What should you do first?

Enable auto-scaling on the VM scale set

Resize the VM to a larger size with more vCPUs and memory

Migrate the database to Azure SQL Database and increase the service tier

Add a read replica to offload reporting queries

A company uses Azure SQL Database for its production application. The compliance team requires that backups be retained for 7 years for auditing purposes. The company wants to minimize storage costs while meeting the compliance requirement. What should you configure?

Set the point-in-time restore retention to 7 years.

Create manual backups and store them in Azure Blob Storage with lifecycle management.

Use long-term retention (LTR) to store backups for 7 years.

Use geo-replication to store backups in another region.

A technology company runs a multi-tenant SaaS application on Azure SQL Database. Each tenant has its own database, and the number of tenants is growing rapidly. The company is experiencing performance issues because some tenants have high resource usage, while others are idle. The company wants to optimize resource utilization and cost while ensuring that no tenant is starved of resources. Which solution should you recommend?

Shard the databases across multiple servers

Use the serverless compute tier for each tenant database

Use elastic pools to share resources among tenant databases

Scale each tenant database to a higher service tier

A company runs a database on Azure SQL Database in the Standard tier (S3, 100 DTUs). The database has grown and now experiences high CPU usage during peak hours. The workload is not predictable, and the company wants to minimize cost while ensuring the database can handle the peaks. What should you recommend?

Keep the Standard tier and manually scale up to S4 during peak hours.

Move to the serverless compute tier with auto-scale and a minimum vCore setting.

Move to the Business Critical tier with 8 vCores.

Use an elastic pool with a higher eDTU setting.

Azure Solutions Architect Expert

Domain 2Objective 1

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

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 31–35

31application · medium
A manufacturing company runs a SQL Server database on Azure Virtual Machines. The database supports a production planning system that has grown over time. The current VM has 8 vCPUs and 32 GB RAM, and the database is experiencing high CPU usage during peak hours. The company wants to increase performance with minimal downtime and without changing the application. What should you do first?
Select an answer first
32application · medium
A company uses Azure SQL Database for its production application. The compliance team requires that backups be retained for 7 years for auditing purposes. The company wants to minimize storage costs while meeting the compliance requirement. What should you configure?
Select an answer first
33foundation · easy
A company has multiple Azure SQL databases with varying and unpredictable usage patterns. They want to share a pool of resources to optimize cost while providing performance isolation. Which Azure feature should they use?
Select an answer first
34expert · hard
A technology company runs a multi-tenant SaaS application on Azure SQL Database. Each tenant has its own database, and the number of tenants is growing rapidly. The company is experiencing performance issues because some tenants have high resource usage, while others are idle. The company wants to optimize resource utilization and cost while ensuring that no tenant is starved of resources. Which solution should you recommend?
Select an answer first
35application · medium
A company runs a database on Azure SQL Database in the Standard tier (S3, 100 DTUs). The database has grown and now experiences high CPU usage during peak hours. The workload is not predictable, and the company wants to minimize cost while ensuring the database can handle the peaks. What should you recommend?
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 7)

Questions 31–35

A company uses Azure SQL Database for its production application. The compliance team requires that backups be retained for 7 years for auditing purposes. The company wants to minimize storage costs while meeting the compliance requirement. What should you configure?

A company has multiple Azure SQL databases with varying and unpredictable usage patterns. They want to share a pool of resources to optimize cost while providing performance isolation. Which Azure feature should they use?

Keep studying — Design data storage solutions