nerdexam
MicrosoftMicrosoft

DP-300 · Question #452

DP-300 Question #452: Real Exam Question with Answer & Explanation

The correct answer is A: a vCore based service tier. Dynamically scale database resources with minimal downtime - Azure SQL Database & Azure SQL Managed Instance Azure SQL Managed Instance allows you to scale as well: SQL Managed Instance uses vCores mode and enables you to define maximum CPU cores and maximum of storage allocated

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

Question

You have an Azure subscription. You plan to deploy an Azure SQL managed instance named Server1. You need to recommend a scaling solution for Server1. The solution must ensure that Server1 can dynamically scale reads and writes. What should you include in the recommendation?

Options

  • Aa vCore based service tier
  • Belastic pools
  • CA Hyperscale based service tier
  • Da DTU based service tier

Explanation

Dynamically scale database resources with minimal downtime - Azure SQL Database & Azure SQL Managed Instance Azure SQL Managed Instance allows you to scale as well: SQL Managed Instance uses vCores mode and enables you to define maximum CPU cores and maximum of storage allocated to your instance. All databases within the managed instance will share the resources allocated to the instance. https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources

Community Discussion

No community discussion yet for this question.

Full DP-300 PracticeBrowse All DP-300 Questions