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. An Azure SQL Database 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 naveen.iyer· 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

AAn Azure SQL Database elastic pool
BSQL Server on Azure virtual machines
Can Azure SQL Database managed instance
DAzure SQL databases

How the community answered

(41 responses)

A
93% (38)
B
5% (2)
D
2% (1)

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