AZ-304 Azure Data Storage Architecture

Question 1

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

Accepted Answer

Zone-Redundant Storage (ZRS)

Answer

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

Question 2

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

Accepted Answer

Azure SQL Database Hyperscale

Answer

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

Question 3

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?

Accepted Answer

Cold

Answer

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.

Question 4

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

Accepted Answer

Azure Cosmos DB with multi-region writes

Answer

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

Question 5

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

Accepted Answer

Automatic Tuning

Answer

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

AZ-304 - Microsoft Azure Architect Design Practice Test

AZ-304 - Microsoft Azure Architect Design Practice Test

AZ-304 Azure Data Storage Architecture