Skip to main content
  1. Public practice questions
  2. AZ-104 Practice Exams | Azure Administrator Associate
  3. AZ-104 Practice Exam 1

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)

  1. Purchase a Reserved Instance VM and attach a Premium SSD disk

  2. Use pay-as-you-go VMs with Standard HDD disks

  3. Use GPU VMs with temporary disks

  4. Select Memory Optimized VMs with Standard SSDs

Correct answers

  1. 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.