DTU vs vCore pricing models in Azure - Quick Revision & Key Differences

Recall & Review

beginner

What does DTU stand for in Azure SQL Database pricing?

DTU stands for Database Transaction Unit. It is a blended measure of CPU, memory, reads, and writes used to simplify performance capacity.

intermediate

What is the main difference between DTU and vCore pricing models?

DTU pricing bundles compute, memory, and I/O into a single unit, while vCore pricing separates compute and storage resources, allowing more flexibility and transparency.

beginner

Which pricing model offers more control over hardware choices: DTU or vCore?

The vCore pricing model offers more control because it lets you choose the number of virtual cores, memory size, and storage independently.

beginner

Why might a beginner choose DTU pricing over vCore pricing?

DTU pricing is simpler and easier to understand because it combines resources into one unit, making it good for predictable workloads without needing detailed resource management.

intermediate

How does vCore pricing help with cost optimization?

vCore pricing allows you to scale compute and storage separately and choose hardware generation, which helps optimize costs based on actual resource needs.

What does the DTU pricing model combine into one unit?

A Network bandwidth

B Only CPU

C CPU, memory, and I/O

D Only storage

DTU pricing bundles CPU, memory, and I/O resources into a single unit for simplicity.

Which pricing model allows you to pick the number of virtual cores?

A Neither

B DTU

C Both DTU and vCore

D vCore

vCore pricing lets you choose the number of virtual cores, giving more control over compute resources.

Why might vCore pricing be better for large or variable workloads?

A Because it allows independent scaling of compute and storage

B Because it bundles all resources

C Because it is simpler

D Because it has fixed pricing

vCore pricing allows you to scale compute and storage separately, which suits large or changing workloads.

Which pricing model is easier for beginners to understand?

A vCore

B DTU

C Both are equally easy

D Neither

DTU pricing is simpler because it combines resources into one unit, making it easier for beginners.

In vCore pricing, what can you choose besides the number of cores?

A Memory size and storage

B Only storage

C Only network speed

D Nothing else

vCore pricing lets you select memory size and storage independently, offering more flexibility.

Explain the key differences between DTU and vCore pricing models in Azure SQL Database.

Think about how resources are grouped and what control you have over them.

Describe scenarios where you might choose DTU pricing over vCore pricing and vice versa.

Consider workload size and complexity.