nerdexam
Microsoft

DP-300 · Question #154

You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: - 24 co

The correct answer is B. Premium. In the DTU Purchase Model with "Standard". Business Critical is with General Purpose in vCore Migrating a database from the DTU-based purchasing model to the vCore-based purchasing model is similar to scaling between service objectives in the Basic, Standard, and Premium service

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

Question

You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: - 24 cores - 500 GB of storage - 124 GB of memory - More than 50,000 IOPS During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard. Which service tier should you use during peak usage?

Options

  • ABusiness Critical
  • BPremium
  • CHyperscale

How the community answered

(45 responses)
  • A
    20% (9)
  • B
    71% (32)
  • C
    9% (4)

Explanation

In the DTU Purchase Model with "Standard". Business Critical is with General Purpose in vCore Migrating a database from the DTU-based purchasing model to the vCore-based purchasing model is similar to scaling between service objectives in the Basic, Standard, and Premium service tiers, with similar duration and a minimal downtime at the end of the migration process. A database migrated to the vCore-based purchasing model can be migrated back to the DTU- based purchasing model at any time in the same fashion, with the exception of databases migrated to the Hyperscale service tier. https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice