Question 52 — AZ-104 Practice Exam 1
Your company is migrating workloads to Azure. A production SQL Server database requires guaranteed high throughput and storage performance, with predictable costs for the next three years. Which approach best meets these needs? (Select one answer)
Purchase a Reserved Instance VM and attach a Premium SSD disk
Use pay-as-you-go VMs with Standard HDD disks
Use GPU VMs with temporary disks
Select Memory Optimized VMs with Standard SSDs
Correct answers
Purchase a Reserved Instance VM and attach a Premium SSD disk
Explanations
Correct:
Purchase a Reserved Instance VM and attach a Premium SSD disk – Reserved Instances provide cost predictability and savings over three years, while Premium SSDs deliver the high-performance disk throughput and IOPS required for production databases.
Wrong:
Use pay-as-you-go VMs with Standard HDD disks – HDD disks don’t provide the throughput required for production SQL workloads, and pay-as-you-go won’t deliver cost predictability.
Use GPU VMs with temporary disks – GPU VMs are designed for graphics/AI workloads, not SQL Server; temporary disks are wiped on shutdown.
Select Memory Optimized VMs with Standard SSDs – While memory-optimized helps SQL performance, Standard SSDs may not provide the required throughput for mission-critical production databases.