Azure Data Storage Architecture Flashcards

Which Azure Cache for Redis tier supports data persistence and zone redundancy for production workloads?

Answer: Premium

The Premium tier of Azure Cache for Redis supports RDB and AOF persistence, Virtual Network integration, and zone redundancy, making it suitable for production use cases.

An application needs to store semi-structured JSON documents and query them using a flexible schema without predefined table structures. Which Azure service is best suited?

Answer: Azure Cosmos DB for NoSQL

Azure Cosmos DB for NoSQL (formerly Core SQL API) is designed for semi-structured JSON documents and supports flexible schemas with rich SQL-like querying capabilities.

Which Azure SQL Database feature allows you to restore a database to any point in time within the configured retention period?

Answer: Point-in-Time Restore (PITR)

Point-in-Time Restore (PITR) uses continuous transaction log backups to allow restoration of an Azure SQL Database to any second within the 1–35 day retention window.

What Azure Storage feature prevents accidental or malicious deletion of blobs by requiring a delete lock to be held for a defined retention period?

Answer: Immutable Storage with WORM policy

Immutable Blob Storage with WORM (Write Once, Read Many) policies prevents deletion or modification of data for a configured interval, satisfying regulatory retention requirements.

Which Azure data service is best suited for ingesting millions of events per second from IoT devices for real-time stream processing?

Answer: Azure Event Hubs

Azure Event Hubs is a highly scalable event streaming platform capable of ingesting millions of events per second, designed for big data telemetry and IoT scenarios.

A design requires that an Azure SQL Database secondary replica be readable for reporting queries without impacting the primary workload. Which feature enables this?

Answer: Geo-Replication readable secondary

Active Geo-Replication creates up to four readable secondary replicas in different regions, allowing reporting workloads to be offloaded without affecting the primary replica.