az-305 Practice Question 1962
Exam: az-305
Domain: Design data storage solutions
Topic: Design a data storage solution for relational data
Difficulty: medium
A developer needs to design a data storage solution for an application that requires high availability and disaster recovery capabilities. The application also needs to support a large number of concurrent users and handle both read and write operations efficiently. Which Azure SQL Database solution would 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 Standard
Correct Answer
B: Azure SQL Managed Instance
Explanation
Azure SQL Database Hyperscale offers high availability and disaster recovery capabilities, along with automatic scaling to handle a large number of concurrent users and mixed read/write operations. Managed Instances provide high availability and disaster recovery but do not offer automatic scaling based on demand. Elastic pools are good for managing multiple databases but may not provide the same level of performance and scalability as Hyperscale for a single database. Therefore, Hyperscale is the best fit for this scenario.