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…

The correct answer is Max vCores: 6; Min vCores: 0.75; Data max size: 800 GB. 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…

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

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:

Exhibits

Answer Area

Max vCores6
12468101214161820243240
Min vCores0.75
0.7511.251.51.7522.252.53456
Data max size800 GB
1 GB800 GB1.5 TB

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

#Azure SQL Database#Serverless tier#vCores#Data size limits

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice