dp-900 Practice Question 1825
Exam: dp-900
Domain: Describe how to work with relational data on Azure
Topic: Describe relational Azure data services
Difficulty: medium
Contoso Ltd is migrating their on-premises SQL Server to Azure SQL Database. They want to ensure that the database performance scales automatically with the workload without manual intervention. Which Azure SQL Database deployment model should they choose, and why?
Answer Options
A
Azure SQL Database DTU
B
Azure SQL Database vCore
C
Azure SQL Managed Instance
D
Azure Database for PostgreSQL
Correct Answer
B: Azure SQL Database vCore
Explanation
The correct answer is B: Azure SQL Database vCore. This model allows for automatic scaling of resources based on the workload, which aligns with Contoso's requirement for automatic scaling without manual intervention.