Examkin

Question

Difficulty: EasyBlob, File, and Disk Storage Solutions

You are designing the storage configuration for a SQL Server database hosted on an Azure Virtual Machine. The database transaction logs require consistent, sub-millisecond write latencies and high IOPS performance. Which Azure managed disk type should you select for the drive that hosts these transaction logs?

  1. A
    Standard HDD
  2. B
    Standard SSD
  3. Premium SSDAnswer
  4. D
    Standard SSD with Read/Write host caching enabled

Answer

Premium SSD
The correct answer is Premium SSD. Database transaction logs are latency-sensitive and require high IOPS. Premium SSD managed disks offer the consistent sub-millisecond latencies and high performance characteristics necessary to support transaction logging workloads without introducing performance bottlenecks.

Step-by-Step Solution

1
Analyze the workload requirements for the database transaction logs.
The requirements specify consistent, sub-millisecond write latencies and high IOPS performance.
Database transaction logs are write-heavy and highly sensitive to latency; poor performance here degrades overall database throughput.
2
Evaluate the capabilities of the available Azure managed disk types against the performance requirements.
Standard HDD offers low IOPS and high latency. Standard SSD offers moderate IOPS but does not guarantee sub-millisecond latency. Premium SSD provides the necessary performance characteristics.
Matching workload needs with Azure disk performance tiers is critical for cost-effective architecture design.
3
Select the optimal disk type that meets the criteria.
Premium SSD is the standard choice that meets both the low latency and high IOPS requirements.
It offers the required sub-millisecond latency and high IOPS at a lower cost complexity than Ultra Disk.

Key Concept

Selecting the correct Azure managed disk tier based on performance requirements (IOPS and latency) of database workloads.
Rate this question

Topics

Blob, File, and Disk Storage Solutions

More questions from this topic