DP-300 Certification Practice Question #20

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?

Accepted Answer

To meet the peak requirement of 24 vCores, 124 GB of RAM, and more than 50,000 IOPS, the database must be on a high-performance tier. Business Critical (Option A) uses local SSD storage that natively provides the required low-latency and high IOPS (>50,000). While Hyperscale (Option C) also supports these metrics, it is a one-way migration, which would prevent scaling back to the Standard (DTU) tier during off-peak periods. Since switching between non-Hyperscale vCore (Business Critical) and DTU (Standard) tiers is fully supported, Business Critical is the correct choice.

More DP-300 practice questions