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…

The correct answer is A. two Azure SQL Databases in an elastic pool. 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…

Submitted by weili_xi· Mar 6, 2026Plan and implement data platform resources

Question

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?

Options

Atwo Azure SQL Databases in an elastic pool
Btwo databases hosted in SQL Server on an Azure virtual machine
Ctwo databases in an Azure SQL Managed instance
Dtwo single Azure SQL databases

How the community answered

(27 responses)

A
78% (21)
B
4% (1)
C
11% (3)
D
7% (2)

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. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice