DP-300 · Question #172
DP-300 Question #172: Real Exam Question with Answer & Explanation
This hotspot question tests knowledge of Azure SQL Database pricing tiers, DTU/vCore models, and the capabilities available when provisioning a database in the Azure portal. It assesses understanding of compute tiers, storage limits, and backup retention policies associated with
Question
Hotspot Question You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Answer:
Options
- __typehotspot
- variantdropdown
Explanation
This hotspot question tests knowledge of Azure SQL Database pricing tiers, DTU/vCore models, and the capabilities available when provisioning a database in the Azure portal. It assesses understanding of compute tiers, storage limits, and backup retention policies associated with different service tiers.
Approach. When provisioning an Azure SQL Database, the service tier selected determines the maximum storage, compute resources, and features available. The Basic tier supports up to 2 GB storage with 7-day backup retention. The Standard tier supports up to 1 TB storage with 7-35 day retention. The Premium tier offers up to 4 TB storage with In-Memory OLTP and 7-35 day retention. The General Purpose (vCore) tier supports up to 4 TB with zone redundancy options, while Business Critical offers local SSD storage and read replicas. Understanding which features (like geo-replication, In-Memory OLTP, or read scale-out) are available at each tier is critical for selecting the correct answers in each drop-down. For example, In-Memory OLTP is only available in Premium and Business Critical tiers, and serverless compute is only available in the General Purpose vCore tier.
Concept tested. Azure SQL Database service tiers (DTU-based: Basic, Standard, Premium; vCore-based: General Purpose, Business Critical, Hyperscale), their storage limits, backup retention periods, feature availability (In-Memory OLTP, geo-replication, read replicas, serverless), and how these options are configured during provisioning in the Azure portal.
Reference. https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu and https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-vcore
Topics
Community Discussion
No community discussion yet for this question.