DP-300 · Question #391
DP-300 Question #391: Real Exam Question with Answer & Explanation
Azure SQL Database — Hotspot Explanation > Note: The provided data shows Correct: None for both dropdowns, meaning the answer key was not included in the source data. Based on Azure SQL technical requirements, here are the correct answers and reasoning: --- Dropdown 1: ComputeG
Question
Hotspot Question You have an Azure subscription. You need to deploy an Azure SQL database. The solution must meet the following requirements: - Support at least 36 cores. - Minimize costs. How should you complete the PowerShell script? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
Options
- __typehotspot
- variantdropdown
Explanation
Azure SQL Database — Hotspot Explanation
Note: The provided data shows
Correct: Nonefor both dropdowns, meaning the answer key was not included in the source data. Based on Azure SQL technical requirements, here are the correct answers and reasoning:
Dropdown 1: ComputeGeneration → Gen5
Why Gen5 is correct: Gen5 hardware supports up to 80 vCores in the vCore purchasing model, easily satisfying the ≥36 core requirement.
Why the alternatives are wrong:
| Option | Why Wrong |
|---|---|
Gen4 | Supports a maximum of 24 vCores — cannot meet the ≥36 core requirement |
4 / 5 | Invalid syntax for the -ComputeGeneration PowerShell parameter; the correct values are string literals Gen4 / Gen5 |
Underlying concept: Azure SQL vCore model hardware generations define the physical CPU architecture and vCore ceiling. Gen5 (Intel Broadwell/Ice Lake) replaced Gen4 and offers higher core counts and better price-performance.
Dropdown 2: ComputeModel → Serverless
Why Serverless is correct: Serverless automatically pauses compute when the database is idle and resumes on next connection. You only pay for compute seconds actually used — directly minimizing costs.
Why the alternatives are wrong:
| Option | Why Wrong |
|---|---|
Provisioned | Compute is allocated continuously and billed even when idle — higher cost |
Free | Limited to ~2 vCores / 32 GB storage — cannot support 36 cores |
Standard | Not a valid value for -ComputeModel; this belongs to the DTU purchasing model, not vCore |
Underlying concept: The vCore model offers two compute models: Provisioned (reserved, always-on) vs Serverless (auto-scale, auto-pause). Serverless is the cost-minimizing choice for workloads with intermittent usage patterns.
The Complete PowerShell Context
New-AzSqlDatabase `
-ComputeGeneration "Gen5" ` # Supports up to 80 vCores
-ComputeModel "Serverless" # Auto-pause = minimum cost
-VCores 36
Topics
Community Discussion
No community discussion yet for this question.