Examkin

Question

Difficulty: EasyBlob, File, and Disk Storage Solutions

You are designing the storage configuration for a critical production database hosted on an Azure Virtual Machine. The database transaction logs require high write throughput and consistent sub-millisecond latency. In addition, the storage solution must remain available in the event of a physical outage or power failure at a single datacenter within the Azure region. Which disk storage configuration should you recommend?

  1. A
    Standard SSD configured with Zone-Redundant Storage (ZRS)
  2. B
    Premium SSD configured with Locally Redundant Storage (LRS)
  3. Premium SSD configured with Zone-Redundant Storage (ZRS)Answer
  4. D
    Standard HDD configured with Locally Redundant Storage (LRS)

Answer

Premium SSD configured with Zone-Redundant Storage (ZRS)
Premium SSD provides the sub-millisecond latency and high throughput required for transaction logs, and Zone-Redundant Storage (ZRS) replicates the data across three availability zones to protect against a single datacenter failure.

Step-by-Step Solution

1
Analyze the database performance requirement.
The database transaction logs require sub-millisecond latency and high write throughput, which rules out Standard SSD and Standard HDD options.
Database transaction logs are highly sensitive to write latency, demanding Premium SSD or Ultra Disk performance.
2
Analyze the availability and redundancy requirement.
The storage solution must remain available if a single datacenter within the region fails, which rules out Locally Redundant Storage (LRS) and requires Zone-Redundant Storage (ZRS).
LRS replicates data only within a single facility, while ZRS replicates data synchronously across three availability zones in the region.
3
Combine the performance and redundancy requirements to select the target configuration.
Premium SSD configured with Zone-Redundant Storage (ZRS) is selected.
This configuration satisfies both the latency requirement for database logs and the datacenter-level fault tolerance.

Key Concept

Matching database workload latency and write throughput needs with Premium SSD performance, while ensuring datacenter-level resilience using Zone-Redundant Storage (ZRS).
Estimated Time:1m 0s
Rate this question

Topics

Blob, File, and Disk Storage Solutions

More questions from this topic