What should you use?

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?
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

View Answer

Answer: A

Explanation:

Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview