AZ-305 Azure Storage and Data Architecture 2

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?

Accepted Answer

Azure SQL Database Serverless

Answer

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?

Accepted Answer

Azure Cosmos DB

Answer

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?

Accepted Answer

Azure Event Hubs + Azure Stream Analytics + Azure Data Lake Storage Gen2

Answer

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?

Accepted Answer

Azure SQL Managed Instance

Answer

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?

Accepted Answer

Azure Cache for Redis

Answer

Azure Cache for Redis provides an in-memory key-value store that dramatically reduces database read latency by caching frequently queried data.

AZ-305 - Designing Microsoft Azure Infrastructure Solutions Practice Test

AZ-305 - Designing Microsoft Azure Infrastructure Solutions Practice Test

AZ-305 Azure Storage and Data Architecture 2