Examkin

Question

Difficulty: EasyBlob, File, and Disk Storage Solutions

A company is setting up a development environment on an Azure virtual machine that runs a database. The database transaction logs require high-speed performance, and the database backups must be stored in a storage account that remains available if a single datacenter in the region fails.

Which disk type and storage replication option should be selected?

  1. Premium SSD for the transaction logs, and Zone-Redundant Storage for the backupsAnswer
  2. B
    Standard HDD for the transaction logs, and Zone-Redundant Storage for the backups
  3. C
    Premium SSD for the transaction logs, and Locally Redundant Storage for the backups
  4. D
    Standard HDD for the transaction logs, and Locally Redundant Storage for the backups

Answer

Premium SSD for the transaction logs, and Zone-Redundant Storage for the backups
The correct selection is Premium SSD for transaction logs combined with Zone-Redundant Storage for backups. Premium SSD satisfies the high-speed and low-latency performance demands of transactional logging, while Zone-Redundant Storage replicates backup data across multiple availability zones within the region, ensuring survival during a single datacenter failure.

Step-by-Step Solution

1
Evaluate the disk performance requirements for database transaction logs.
Database transaction logs are write-intensive and require low-latency performance. Premium SSD or Ultra Disk is appropriate, whereas Standard HDD is insufficient.
Standard HDD lacks the IOPS and throughput capabilities required to prevent performance bottlenecks on transaction logs.
2
Evaluate the resilience requirements for database backups.
To survive a physical failure of a single datacenter within a region, the data must be replicated across separate zones (Zone-Redundant Storage). Locally Redundant Storage (LRS) is insufficient.
LRS restricts replication to a single physical datacenter facility.
3
Identify the storage configuration that satisfies both requirements.
The correct combination is Premium SSD for the database transaction logs and Zone-Redundant Storage for the backups.
This configuration meets both performance and availability targets.

Key Concept

Selecting appropriate Azure storage tiers and redundancy options to balance performance workloads and disaster resilience requirements.
Rate this question

Topics

Blob, File, and Disk Storage Solutions

More questions from this topic