DP-300 Certification Practice Question #221

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

Placing two databases in an Azure SQL Database elastic pool allows them to share a common pool of resources (eDTUs or vCores). The pool dynamically distributes these resources based on the real-time workloads of each database, avoiding the need for manual scaling and avoiding any scaling-related downtime. This meets the requirement of dynamic resource scaling with minimal administrative effort and minimal downtime.

More DP-300 practice questions