AZ-305 Azure Storage and Data Architecture 2 — Questions and Answers
Question 1: You need to design a relational database solution in Azure that automatically scales compute independently of storage for unpredictable workloads. Which service tier should you choose?
- Azure SQL Database General Purpose
- Azure SQL Database Hyperscale
- Azure SQL Database Serverless (Correct answer)
- Azure SQL Managed Instance Business Critical
Correct answer: Azure SQL Database Serverless
Azure SQL Database Serverless tier auto-pauses when idle and auto-scales compute vCores based on workload demand, billed per second of compute used.
Question 2: Your application requires a globally distributed NoSQL database with multi-region writes, single-digit millisecond reads, and five consistency levels to choose from. Which Azure service fits?
- Azure Table Storage
- Azure SQL Database with geo-replication
- Azure Cosmos DB (Correct answer)
- Azure Cache for Redis
Correct answer: Azure Cosmos DB
Azure Cosmos DB is Microsoft's globally distributed, multi-model database with multi-region write capability and tunable consistency levels.
Question 3: You are designing storage for an IoT application that ingests millions of small messages per second and needs a hot path for immediate analytics. Which combination is recommended?
- Azure Blob Storage + Azure Synapse Analytics
- Azure Event Hubs + Azure Stream Analytics + Azure Data Lake Storage Gen2 (Correct answer)
- Azure Queue Storage + Azure Functions + Azure SQL Database
- Azure Service Bus + Azure Databricks + Azure Cosmos DB
Correct answer: Azure Event Hubs + Azure Stream Analytics + Azure Data Lake Storage Gen2
Event Hubs captures the high-throughput stream, Stream Analytics processes data in real time, and ADLS Gen2 stores the cold path for batch analytics.
Question 4: A customer needs to migrate an on-premises Oracle database to Azure with minimal re-engineering and maximum compatibility. Which Azure database service should you recommend?
- Azure SQL Database
- Azure SQL Managed Instance (Correct answer)
- Azure Database for PostgreSQL – Flexible Server
- Azure Database for Oracle (fully managed)
Correct answer: Azure SQL Managed Instance
Azure SQL Managed Instance provides near 100% SQL Server engine compatibility and supports features like SQL Agent, CLR, and linked servers needed for lift-and-shift migrations.
Question 5: You need to design a caching layer to reduce read latency for an Azure SQL Database backing a high-traffic web application. Which service should you add?
- Azure Content Delivery Network (CDN)
- Azure Cache for Redis (Correct answer)
- Azure SQL Database read replicas
- Azure Cosmos DB as a cache
Correct answer: Azure Cache for Redis
Azure Cache for Redis provides an in-memory key-value store that dramatically reduces database read latency by caching frequently queried data.
Question 6: Your data warehouse needs to query petabytes of data with massively parallel processing (MPP). Which Azure service is designed for this workload?
- Azure SQL Database Hyperscale
- Azure SQL Managed Instance
- Azure Synapse Analytics dedicated SQL pool (Correct answer)
- Azure Cosmos DB analytical store
Correct answer: Azure Synapse Analytics dedicated SQL pool
Azure Synapse Analytics dedicated SQL pool uses MPP architecture to distribute query processing across compute nodes for petabyte-scale analytical queries.
AZ-305 Azure Storage and Data Architecture 2
You need to design a relational database solution in Azure that automatically scales compute independently of storage for unpredictable workloads.
Which service tier should you choose?