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 General Purpose

Answer

Azure SQL Database Hyperscale

Answer

Azure SQL Managed Instance Business Critical

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 Table Storage

Answer

Azure SQL Database with geo-replication

Answer

Azure Cache for Redis

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

Azure Blob Storage + Azure Synapse Analytics

Answer

Azure Queue Storage + Azure Functions + Azure SQL Database

Answer

Azure Service Bus + Azure Databricks + Azure Cosmos DB

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 Database

Answer

Azure Database for PostgreSQL – Flexible Server

Answer

Azure Database for Oracle (fully managed)

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 Content Delivery Network (CDN)

Answer

Azure SQL Database read replicas

Answer

Azure Cosmos DB as a cache

Question 6

Your data warehouse needs to query petabytes of data with massively parallel processing (MPP). Which Azure service is designed for this workload?

Accepted Answer

Azure Synapse Analytics dedicated SQL pool

Answer

Azure SQL Database Hyperscale

Answer

Azure SQL Managed Instance

Answer

Azure Cosmos DB analytical store