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

Locally Redundant Storage (LRS)

Answer

Geo-Redundant Storage (GRS)

Answer

Read-Access Geo-Redundant Storage (RA-GRS)

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 Managed Instance

Answer

Azure Database for PostgreSQL Single Server

Answer

Azure Cosmos DB SQL API

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

Hot

Answer

Cool

Answer

Archive

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 SQL Database with geo-replication

Answer

Azure Database for MySQL Flexible Server

Answer

Azure Synapse Analytics

Question 5

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

Accepted Answer

Automatic Tuning

Answer

Query Store

Answer

Elastic Pools

Answer

Active Geo-Replication

Question 6

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?

Accepted Answer

Archive with Standard Priority rehydration

Answer

Cool

Answer

Cold

Answer

Archive with High Priority rehydration