A database needs more storage capacity. The customer wants to increase the maximum storage size of the database without moving to a different architecture. Which action is a vertical scaling technique?

Using a different database engine

Increasing the storage size of the database

A company runs a customer-facing order-entry application on Azure SQL Database. The workload is steady during business hours but has predictable spikes at month-end. The database currently uses the General Purpose tier with 8 vCores. The team wants to reduce cost without sacrificing performance during the spikes. What should you recommend?

Move to the Business Critical tier with 8 vCores and enable read scale-out.

Switch to the serverless compute tier with auto-scale and a minimum vCore setting that covers the baseline.

Keep General Purpose and use auto-pause for the database during non-business hours.

Use elastic pools to share resources among multiple databases in the same logical server.

A company uses Azure SQL Database for its production application. The compliance team requires that the database be restorable to any point within the last 35 days. The company also wants to minimize storage costs for backups. What should you configure?

Set the backup retention period to 35 days using the default backup policy.

Configure a manual backup every day and store it in Azure Blob Storage.

Use long-term retention (LTR) to store backups for 35 days.

Enable geo-redundant backup storage for the database.

A company runs a mission-critical application on Azure SQL Database in the Business Critical tier. The application requires high availability with automatic failover in case of a regional outage. The company wants to ensure that the database remains available even if an entire Azure region fails. What should you recommend?

Configure active geo-replication to a secondary region.

Increase the service tier to Hyperscale for better availability.

Use auto-failover groups with a secondary in the same region.

Enable zone redundancy for the database within the same region.

A media company is building a new content-management system that requires a relational database with the ability to run complex queries and stored procedures. The company expects the workload to be unpredictable, with periods of low activity followed by sudden spikes. They want to minimize cost during idle periods and avoid managing virtual machines. Which Azure service should you recommend?

SQL Server on Azure Virtual Machines

Azure SQL Database in the serverless compute tier

Azure Solutions Architect Expert

Domain 2Objective 1

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

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 26–30

26foundation · easy
A database needs more storage capacity. The customer wants to increase the maximum storage size of the database without moving to a different architecture. Which action is a vertical scaling technique?
Select an answer first
27application · medium
A company runs a customer-facing order-entry application on Azure SQL Database. The workload is steady during business hours but has predictable spikes at month-end. The database currently uses the General Purpose tier with 8 vCores. The team wants to reduce cost without sacrificing performance during the spikes. What should you recommend?
Select an answer first
28application · medium
A company uses Azure SQL Database for its production application. The compliance team requires that the database be restorable to any point within the last 35 days. The company also wants to minimize storage costs for backups. What should you configure?
Select an answer first
29application · medium
A company runs a mission-critical application on Azure SQL Database in the Business Critical tier. The application requires high availability with automatic failover in case of a regional outage. The company wants to ensure that the database remains available even if an entire Azure region fails. What should you recommend?
Select an answer first
30application · medium
A media company is building a new content-management system that requires a relational database with the ability to run complex queries and stored procedures. The company expects the workload to be unpredictable, with periods of low activity followed by sudden spikes. They want to minimize cost during idle periods and avoid managing virtual machines. Which Azure service 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 6)

Questions 26–30

A database needs more storage capacity. The customer wants to increase the maximum storage size of the database without moving to a different architecture. Which action is a vertical scaling technique?

A company uses Azure SQL Database for its production application. The compliance team requires that the database be restorable to any point within the last 35 days. The company also wants to minimize storage costs for backups. What should you configure?

Keep studying — Design data storage solutions