AZ-305 Design data storage solutions Practice Test 9 — 15 Questions

Question 1

A healthcare analytics platform stores semi-structured JSON documents and requires globally distributed low-latency reads with tunable consistency. Which Azure data platform should be recommended?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it natively supports semi-structured JSON documents, offers globally distributed multi-region writes and reads with low-latency (typically <10 ms at the 99th percentile), and provides tunable consistency levels (from strong to eventual) via its multi-master replication protocol. This directly matches the requirements for a healthcare analytics platform needing global distribution and flexible consistency.

Answer

Azure Files premium shares

Answer

Azure Data Factory

Answer

Azure SQL Managed Instance

Question 2

An enterprise data platform must store petabytes of raw files for analytics and support fine-grained access control through Microsoft Entra ID. Which storage solution should be selected?

Accepted Answer

Azure Data Lake Storage Gen2. Azure Data Lake Storage Gen2 (ADLS Gen2) combines a hierarchical namespace with Azure Blob Storage, enabling petabyte-scale storage for raw files and fine-grained access control via POSIX-like ACLs integrated with Microsoft Entra ID (formerly Azure AD). This makes it the ideal solution for enterprise analytics requiring both massive capacity and granular security.

Answer

Azure Queue Storage

Answer

Azure Disk Storage attached to one VM

Answer

Azure Cache for Redis

Question 3

A globally distributed application requires multi-region writes to a NoSQL database and must tolerate regional write outages. Which Azure service capability should be selected?

Accepted Answer

Azure Cosmos DB multi-region writes. Azure Cosmos DB multi-region writes is the correct choice because it provides active-active replication across multiple Azure regions, enabling writes to be accepted in any configured region and automatically replicated. This design ensures that if one region experiences a write outage, the application can continue writing to other regions without interruption, meeting the requirement for multi-region writes and regional write outage tolerance.

Answer

Azure Table Storage RA-GRS

Answer

Azure SQL Database serverless only

Answer

Azure Files geo-redundant storage

Question 4

Drag and drop the steps to migrate an on-premises SQL Server database to Azure SQL Database using the Data Migration Assistant (DMA) into the correct order.

Accepted Answer

Install DMA, then Assess, then Fix issues, then Migrate and Monitor. The correct sequence for migrating an on-premises SQL Server database to Azure SQL Database using the Data Migration Assistant is: first, install the DMA tool; second, run an assessment to identify compatibility issues; third, fix the identified issues; and finally, perform the migration and monitor the process. This order ensures that all potential problems are resolved before migration, reducing the risk of downtime or data loss.

Answer

Assess, then Install DMA, then Fix issues, then Migrate and Monitor

Answer

Install DMA, then Migrate and Monitor, then Assess, then Fix issues

Answer

Fix issues, then Install DMA, then Assess, then Migrate and Monitor

Question 5

Drag and drop the steps to deploy a web app using Azure App Service with a custom domain and SSL certificate into the correct order.

Accepted Answer

Create the App Service app, then map the custom domain, then upload the SSL certificate, then bind the certificate to the domain, then enforce HTTPS.. The correct order for deploying a web app using Azure App Service with a custom domain and SSL certificate is: create the App Service app, map the custom domain, upload the SSL certificate, bind the certificate to the domain, and finally enforce HTTPS. This sequence ensures that each step has the necessary prerequisites: the app exists before domain mapping, the domain is mapped before certificate upload and binding, and the certificate is bound before enforcing HTTPS.

Answer

Create the App Service app, then upload the SSL certificate, then map the custom domain, then bind the certificate to the domain, then enforce HTTPS.

Answer

Create the App Service app, then map the custom domain, then bind the certificate to the domain, then upload the SSL certificate, then enforce HTTPS.

Answer

Map the custom domain, then create the App Service app, then upload the SSL certificate, then bind the certificate to the domain, then enforce HTTPS.

Question 6

Drag and drop the steps to implement Azure Traffic Manager for geographic routing into the correct order.

Accepted Answer

Create profile, then add endpoints, then configure mapping, then update DNS, then test.. The correct sequence for implementing Azure Traffic Manager for geographic routing is: first create the Traffic Manager profile, then add the endpoints (e.g., Azure regions), then configure the geographic routing mapping to assign regions to endpoints, then update DNS records to point to the Traffic Manager domain name, and finally test the routing. Skipping or reordering these steps can lead to misconfiguration or routing failures.

Answer

Add endpoints, then create profile, then configure mapping, then update DNS, then test.

Answer

Create profile, then configure mapping, then add endpoints, then update DNS, then test.

Answer

Create profile, then add endpoints, then update DNS, then configure mapping, then test.

Question 7

Match each Azure storage redundancy option to its description.

Accepted Answer

LRS: Replicates data three times within a single data center in the primary region.. Azure Storage offers several redundancy options: LRS (local), ZRS (zone), GRS (geo), and RA-GRS (geo with read access). Common confusions include mixing LRS and ZRS, or assuming all geo-replicated options provide read access.

Answer

LRS: Replicates data across multiple availability zones.

Answer

GRS: Provides read access to the secondary region without failover.

Question 8

Match each Azure disaster recovery feature to its description.

Accepted Answer

Azure Site Recovery: Replicates workloads from primary site to secondary site, enabling automated failover and failback.. Azure disaster recovery features include Site Recovery for replication and failover, Backup for retention, Availability Zones for datacenter failure protection, and Paired Regions for region-level disaster recovery. Common confusions involve mixing the roles of Site Recovery and Backup.

Answer

Azure Site Recovery: Provides long-term retention of backups.

Answer

Azure Backup: Replicates VMs for failover.

Question 9

Match each Azure governance tool to its description.

Accepted Answer

Azure Policy: Enforces rules and compliance across resources.. Azure Policy enforces rules; Azure Blueprints provides repeatable templates; Management Groups organize subscriptions; RBAC controls access. Confusions often arise between policy enforcement and access control, or between blueprints and management groups.

Answer

Azure Policy: Controls access to resources by assigning roles.

Answer

Azure Blueprints: Organizes subscriptions into a hierarchy.

Question 10

A company is designing a data storage solution for a global e-commerce platform that requires low-latency access to product catalog data from multiple Azure regions. The data is read-heavy, with occasional updates. Which Azure data store should they recommend?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it provides globally distributed, multi-region writes with tunable consistency levels and single-digit-millisecond latency for read-heavy workloads. Its ability to replicate data across Azure regions and serve reads from the nearest region directly addresses the requirement for low-latency global access to product catalog data with occasional updates.

Answer

Azure Cache for Redis

Answer

Azure Blob Storage

Answer

Azure SQL Database

Question 11

A company needs to store immutable audit logs for regulatory compliance. The logs must be stored in a write-once, read-many (WORM) state for 7 years. Which Azure storage feature should be used?

Accepted Answer

Azure Blob Storage immutable storage with time-based retention. Azure Blob Storage immutable storage with time-based retention enforces a WORM (Write Once, Read Many) state, preventing logs from being modified or deleted for a specified retention period. This directly meets the regulatory requirement to store audit logs immutably for 7 years, as the policy locks the data at the container or blob level and cannot be removed until the retention interval expires.

Answer

Azure SQL Database temporal tables

Answer

Azure Blob Storage change feed

Answer

Azure Blob Storage soft delete

Question 12

An organization is migrating on-premises Oracle databases to Azure. They require minimal code changes and support for Oracle PL/SQL stored procedures. Which Azure data service best meets these requirements?

Accepted Answer

Azure Database for PostgreSQL with Oracle compatibility. Azure Database for PostgreSQL with the Oracle compatibility extension (e.g., orafce) provides support for Oracle PL/SQL stored procedures and syntax, minimizing code changes during migration. This service is designed to handle Oracle workloads with minimal re-engineering, unlike other Azure database options that lack native Oracle compatibility.

Answer

Azure Database for MySQL

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Question 13

A company wants to analyze IoT sensor data from millions of devices in near real-time and store the raw data for batch processing. Which combination of Azure services should they use?

Accepted Answer

Azure Event Hubs and Azure Blob Storage. Azure Event Hubs is a highly scalable data streaming platform and event ingestion service capable of ingesting millions of events per second from IoT devices in near real-time. Azure Blob Storage provides cost-effective, durable object storage for the raw data, which can then be used for batch processing with services like Azure Data Lake Analytics or Azure Synapse. This combination directly meets the requirements for near real-time ingestion and raw data storage for batch processing.

Answer

Azure Event Hubs and Azure Synapse Analytics

Answer

Azure IoT Hub and Azure Cosmos DB

Answer

Azure Data Lake Storage and Azure Stream Analytics

Question 14

A company is designing a data lake for analytics. The data includes personally identifiable information (PII) that must be anonymized before analysts access it. Which Azure service should they use to automate the anonymization process?

Accepted Answer

Microsoft Purview data policies. Microsoft Purview data policies allow you to define and enforce data access policies that can automatically anonymize or mask sensitive data, such as PII, when accessed by analysts. This service integrates with Azure data lake storage and provides a centralized way to manage data governance and compliance, making it the correct choice for automating anonymization in a data lake scenario.

Answer

Azure Policy

Answer

Azure SQL Database dynamic data masking

Answer

Azure Key Vault

Question 15

An application requires a highly available key-value store with sub-millisecond read and write latencies across multiple Azure regions. The data model is simple and does not require complex queries. Which Azure data store should they choose?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it provides a globally distributed, multi-region key-value store with guaranteed sub-10-millisecond read and write latencies at the 99th percentile, and supports multiple consistency models including eventual consistency for even lower latency. Its turnkey global distribution enables active-active replication across Azure regions, meeting the high availability and sub-millisecond performance requirements without complex query support.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Cache for Redis