Practice Test GeeksAZ-305 - Designing Microsoft Azure Infrastructure Solutions Practice Test
← All AZ-305 Flashcard Decks

Azure Storage and Data Architecture Flashcards

6 cards from real AZ-305 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Azure Storage and Data Architecture flashcards as text

  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?

    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.

  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?

    Answer: Azure Cosmos DB

    Azure Cosmos DB is Microsoft's globally distributed, multi-model database with multi-region write capability and tunable consistency levels.

  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?

    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.

  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?

    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.

  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?

    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.

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

    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.