AZ-304 Azure Data Storage Architecture 2

Question 1

Which Azure Cosmos DB consistency level provides the strongest consistency guarantee at the cost of higher read latency?

Accepted Answer

Strong

Answer

Strong consistency ensures that reads always return the most recent committed write, but it requires synchronous replication across all regions, increasing read latency.

Question 2

What is the purpose of Azure SQL Elastic Pools?

Accepted Answer

To share compute resources across multiple databases with variable workloads

Answer

Elastic Pools allow multiple databases to share a common pool of eDTUs or vCores, optimizing cost when individual databases have unpredictable or varying usage patterns.

Question 3

Which Azure Storage feature allows you to define rules that automatically transition blobs to cooler tiers or delete them based on last-modified or last-accessed time?

Accepted Answer

Lifecycle Management Policies

Answer

Lifecycle Management Policies in Azure Blob Storage automate tiering and deletion of blobs based on age or last access time, reducing storage costs without manual intervention.

Question 4

An architect needs a fully managed, serverless SQL data warehouse service for analytical workloads. Which Azure service is most appropriate?

Accepted Answer

Azure Synapse Analytics (serverless SQL pool)

Answer

Azure Synapse Analytics serverless SQL pool allows querying data in Azure Data Lake using T-SQL without provisioning infrastructure, paying only per TB processed.

Question 5

Which Azure Cosmos DB partition key selection principle is most important for achieving optimal throughput distribution?

Accepted Answer

Use a partition key with high cardinality that evenly distributes data

Answer

A high-cardinality partition key that distributes requests and data evenly across logical partitions prevents hot partitions and maximizes provisioned throughput utilization.

AZ-304 - Microsoft Azure Architect Design Practice Test

AZ-304 - Microsoft Azure Architect Design Practice Test

AZ-304 Azure Data Storage Architecture 2