Examkin

Soru

Zorluk: KolayBlob, 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 SSDCevap
  4. D
    Standard SSD with Read/Write host caching enabled

Cevap

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.

Adım Adım Çözüm

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.

Anahtar Kavram

Selecting the correct Azure managed disk tier based on performance requirements (IOPS and latency) of database workloads.
Bu soruyu puanla

Konular

Blob, File, and Disk Storage Solutions

Bu konudan daha fazla soru