Azure Data Storage Architecture Flashcards

Which Azure Storage redundancy option replicates data synchronously across three availability zones within a single region?

Answer: Zone-Redundant Storage (ZRS)

ZRS synchronously replicates data across three Azure availability zones in the same region, providing high availability even if an entire zone fails.

A workload requires low-latency SQL queries and automatic scaling of both compute and storage independently. Which Azure database service best fits this requirement?

Answer: Azure SQL Database Hyperscale

Azure SQL Database Hyperscale decouples compute and storage scaling, supports databases up to 100 TB, and provides near-instant backups and rapid scale-out.

Which Azure Blob Storage access tier is most cost-effective for data that is accessed less than once per month and requires a 30-day minimum storage duration?

Answer: Cold

The Cold tier offers lower storage costs than Cool with a 90-day minimum retention, but Cool (30-day minimum) is more cost-effective for data accessed less than once a month versus Hot.

You need to store relational data that requires multi-region writes with low latency. Which Azure service should you choose?

Answer: Azure Cosmos DB with multi-region writes

Azure Cosmos DB natively supports multi-region writes, enabling active-active architectures with configurable consistency levels and guaranteed low latency globally.

Which Azure SQL Database feature automatically tunes query performance by identifying and applying index recommendations?

Answer: Automatic Tuning

Automatic Tuning in Azure SQL Database uses AI to monitor query performance, create or drop indexes, and force good query plans without manual intervention.

A solution architect needs to design archival storage for compliance data that will not be accessed for at least one year but must be retrievable within hours. Which storage tier should be used?

Answer: Archive with Standard Priority rehydration

Archive tier with Standard priority rehydration is appropriate for data that is rarely accessed; Standard rehydration can take 1–15 hours, suitable when same-day retrieval is acceptable.