Administering Relational Databases on Microsoft Azure — Question 10

You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
What should you use?

Answer options

• A. two Azure SQL Databases in an elastic pool
• B. two databases hosted in SQL Server on an Azure virtual machine
• C. two databases in an Azure SQL Managed instance
• D. two single Azure SQL databases

Correct answer: A

Explanation

The correct answer is A, as using two Azure SQL Databases in an elastic pool allows for dynamic scaling of resources based on workload needs, reducing downtime during scaling operations. Options B and C involve more management overhead and do not offer the same level of dynamic resource allocation. Option D is not suitable for handling varying workloads effectively.