DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ23

Plan and implement data platform resources

You plan to migrate two 100-GB databases to Azure.

You need to dynamically scale resource consumption according to workloads. The solution must minimize downtime during scaling operations.

What should you use?

Explanation

Azure SQL Database elastic pools let multiple databases share a defined set of compute resources, which suits databases with varying workloads. Azure SQL services support dynamically adding resources with minimal downtime, and an elastic pool can be scaled as a shared resource for its databases.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!