az-305 Practice Question 1961
Exam: az-305
Domain: Design data storage solutions
Topic: Design a data storage solution for relational data
Difficulty: medium
A company is planning to migrate its on-premises relational database to Azure. The database has a high volume of read operations and occasional write operations. The company wants to ensure that the solution can scale automatically based on demand without manual intervention. Which Azure SQL Database solution should you recommend for this scenario?
Answer Options
A
Azure SQL Database Hyperscale
B
Azure SQL Managed Instance
C
Azure SQL Elastic Pool
D
Azure SQL Database Basic
Correct Answer
D: Azure SQL Database Basic
Explanation
Azure SQL Database Hyperscale is designed for workloads with a mix of read and write operations, and it automatically scales resources to meet the demands of the workload. Managed Instances are suitable for transactional workloads but do not offer automatic scaling based on demand. Elastic pools are best for multiple databases with varying workloads but are not as scalable as Hyperscale for a single database. Therefore, Hyperscale is the best fit for this scenario.