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

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

A company needs to store backup data from Azure Virtual Machines with a retention policy of 99 years to meet compliance requirements. The backups must be encrypted at rest and in transit. Which Azure storage solution should they use?

Accepted Answer

Azure Blob Storage with immutable storage. Azure Blob Storage with immutable storage (specifically, a WORM policy with a retention period of up to 99 years) is the correct choice because it meets the 99-year retention requirement and provides encryption at rest (via Azure Storage Service Encryption) and in transit (via HTTPS). Immutable storage prevents data from being deleted or modified during the retention period, which is essential for long-term compliance backups.

Answer

Azure Files

Answer

Azure NetApp Files

Answer

Azure Disk Storage

Question 10

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 11

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

Question 12

A company needs to store large amounts of unstructured data such as images and videos for a content management system. The data must be accessible via HTTPS and support tiered storage for cost optimization. Which Azure service should they use?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is the correct choice because it is designed for storing large amounts of unstructured data (such as images and videos) and provides HTTPS access. It also offers tiered storage (hot, cool, cold, and archive tiers) to optimize costs based on data access patterns, making it ideal for a content management system.

Answer

Azure Cosmos DB

Answer

Azure Data Lake Storage

Answer

Azure Files

Question 13

A company is migrating a legacy application that uses Oracle Database to Azure. They want to minimize code changes and maintain compatibility with Oracle PL/SQL. Which TWO Azure data services should they consider?

Accepted Answer

Azure SQL Managed Instance with Oracle compatibility. Azure SQL Managed Instance with Oracle compatibility (option B) provides a high degree of PL/SQL compatibility through its 'Oracle compatibility mode,' which supports stored procedures, triggers, and functions written in PL/SQL with minimal changes. This service also offers a fully managed SQL Server engine that can run Oracle workloads with near-zero code modifications, making it ideal for legacy application migration.

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Answer

Azure Database for MySQL

Question 14

A company needs to design a data storage solution for a global SaaS application that requires multi-region writes with conflict resolution. The data model includes both structured and unstructured data. Which TWO Azure data services should they consider?

Accepted Answer

Azure Blob Storage. Azure Cosmos DB natively supports multi-region writes with automatic conflict resolution, making it suitable for globally distributed structured data. Azure Blob Storage provides object storage for unstructured data with geo-redundant replication, though it does not natively handle multi-region writes; however, it can be used with application-level strategies. Azure SQL Database with active geo-replication is incorrect because it only supports a single writable primary and readable secondaries, lacking multi-region write capability and conflict resolution. Azure Cache for Redis is a caching layer, not a primary storage solution. Azure Table Storage (non-Cosmos) does not support multi-region writes.

Answer

Azure SQL Database with active geo-replication

Answer

Azure Cache for Redis

Answer

Azure Table Storage

Question 15

A company needs to store sensitive customer data that must be encrypted at rest. Which TWO Azure storage services support customer-managed keys (CMK) for encryption?

Accepted Answer

Azure SQL Database. Azure SQL Database and Azure Blob Storage both support customer-managed keys (CMK) via Azure Key Vault, allowing you to bring your own encryption keys (BYOK) for data at rest. This meets the requirement for sensitive customer data where the organization needs full control over encryption keys, including key rotation and revocation.

Answer

Azure Files

Answer

Azure Cache for Redis

Answer

Azure Cosmos DB