DP-300 Certification Practice Question #210

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?

Accepted Answer

To manage two databases and dynamically scale resource consumption based on fluctuating workloads with minimal downtime, an Azure SQL Database elastic pool is the best solution. Databases in an elastic pool share a common pool of resources (eDTUs or vCores) on a single logical server. The pool automatically allocates these resources to individual databases dynamically as their workloads demand, without requiring explicit manual scaling operations or database restarts, which keeps downtime to a minimum.

More DP-300 practice questions