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

Question 1

Refer to the exhibit. You attempt to create a new storage account with the property 'supportsHttpsTrafficOnly' set to false. What is the result?

Accepted Answer

The storage account creation is denied.. The exhibit shows an Azure Policy that denies creation of storage accounts that do not require HTTPS traffic. When you set 'supportsHttpsTrafficOnly' to false, the policy evaluates the request as non-compliant and denies the creation. This is a common policy to enforce secure transfer for storage accounts.

Answer

The storage account is created and an audit log is generated.

Answer

The storage account is created with HTTPS enforced automatically.

Answer

The storage account is created but encryption is disabled.

Question 2

Refer to the exhibit. You need to enable public access to the storage account for a specific IP address while keeping the default action as Deny. What should you do?

Accepted Answer

Add an IP rule with the specific IP address to the ipRules array.. The Azure Storage account firewall allows you to create IP rules that grant access to specific public IP addresses or ranges while keeping the default action as Deny. By adding an IP rule with the specific IP address to the `ipRules` array, you explicitly allow that IP through the firewall, and all other traffic is denied by the default rule. This is the standard method to enable selective public access without changing the default deny behavior.

Answer

Set the bypass to None to allow all traffic.

Answer

Set the networkAcls to an empty list to remove restrictions.

Answer

Change the defaultAction to Allow and remove the Deny rule.

Question 3

Refer to the exhibit. You deploy this Bicep template. Which region is the primary write region?

Accepted Answer

Both regions are primary. The Bicep template enables multi-region writes (enableMultipleWriteLocations: true) and lists two regions, West US and East US. When multi-region writes are enabled in Azure Cosmos DB, there is no single primary write region; all listed regions are writable and serve as primary write regions. Therefore, the correct answer is that both regions are primary.

Answer

West US

Answer

The resource group's location

Answer

East US

Question 4

Contoso, Ltd. is migrating a legacy on-premises application to Azure. The application uses a SQL Server database with complex queries and requires read-heavy workloads with sub-10-millisecond latency. The solution must support geo-replication for disaster recovery. Which Azure data service should you recommend?

Accepted Answer

Azure SQL Database Business Critical. Azure SQL Database Business Critical is correct because it uses SQL Server database engine with full T-SQL support for complex queries, provides read-heavy workloads with sub-10-millisecond latency via in-memory OLTP and local SSD storage, and supports active geo-replication for disaster recovery. This tier offers a readable secondary replica in a different Azure region, meeting both latency and geo-replication requirements.

Answer

Azure Cosmos DB for NoSQL

Answer

Azure SQL Database Hyperscale

Answer

Azure SQL Managed Instance Business Critical

Question 5

You need to design a storage solution for an Azure virtual machine that runs a mission-critical application. The solution must provide the highest availability SLA and support up to 80,000 IOPS. Which type of Azure managed disk should you use?

Accepted Answer

Premium SSD v2. Premium SSD v2 is correct because it offers the highest availability SLA (99.9% for single-instance VMs) and supports up to 80,000 IOPS per disk, meeting the mission-critical requirements. Unlike Ultra Disk, Premium SSD v2 does not require a dedicated capacity reservation, making it more cost-effective while still delivering high performance.

Answer

Ultra Disk

Answer

Standard SSD

Answer

Premium SSD (non-v2)

Question 6

Your company is designing a data lake solution for IoT telemetry data. The data is ingested continuously and must be stored cost-effectively while allowing occasional interactive queries. The data has a lifespan of 90 days for hot access and 3 years for archived access. Which Azure storage tiering strategy minimizes costs?

Accepted Answer

Use Azure Blob Storage with lifecycle management: Hot for 90 days, then Cool, then Archive after 3 years. Azure Blob Storage lifecycle management can automatically transition data from Hot to Cool to Archive tiers based on age, minimizing costs for IoT telemetry that needs 90 days of hot access and 3 years of archival. The Hot tier provides low-latency access for interactive queries, Cool offers lower storage cost for infrequent access, and Archive provides the lowest cost for long-term retention. This tiering strategy aligns with the data's lifespan and access patterns, reducing overall storage expenses compared to keeping all data in a single tier.

Answer

Use Azure Blob Storage with only Hot tier for 90 days, then delete

Answer

Use Azure Blob Storage with Cool tier for all data

Answer

Use Azure Files with lifecycle management to Archive after 90 days

Question 7

You are designing a globally distributed application that requires low-latency reads and writes for a web application with user session data. The solution must support multi-master writes and provide 99.999% availability. Which Azure data service meets these requirements?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it natively supports multi-master writes across multiple regions, enabling low-latency reads and writes globally. It offers a 99.999% availability SLA when configured with multiple write regions, and its turnkey global distribution ensures user session data is replicated with consistency options tailored for web applications.

Answer

Azure SQL Database

Answer

Azure Cache for Redis

Answer

Azure Table Storage

Question 8

You are designing a solution to store large binary files (videos) that are accessed infrequently but must be retained for 7 years for compliance. The solution must minimize storage costs while allowing retrieval within 24 hours. Which Azure storage tier should you use?

Accepted Answer

Archive tier. The Archive tier is the correct choice because it is the lowest-cost storage tier for infrequently accessed data that must be retained for long periods (7 years). It allows retrieval within 24 hours via standard rehydration, meeting the compliance requirement while minimizing storage costs. The other tiers (Premium, Hot, Cool) are more expensive and designed for higher-frequency access, making them unsuitable for this cost-optimization scenario.

Answer

Premium tier

Answer

Cool tier

Answer

Hot tier

Question 9

You need to design a data storage solution for a high-throughput event processing pipeline. The solution must ingest millions of events per second, support exactly-once processing semantics, and allow replay of events from the past 7 days. Which Azure service should you use as the event ingestion store?

Accepted Answer

Azure Event Hubs. Azure Event Hubs is the correct choice because it is a big data streaming platform and event ingestion service designed for high-throughput scenarios, capable of ingesting millions of events per second. It supports exactly-once processing semantics through checkpointing and offset management, and it provides event retention for up to 7 days by default (configurable up to 90 days), enabling event replay. This makes it ideal for a high-throughput event processing pipeline that requires reliable ingestion and replay capabilities.

Answer

Azure Service Bus

Answer

Azure IoT Hub

Answer

Azure Queue Storage

Question 10

You are designing a hybrid storage solution where on-premises applications need low-latency access to file shares hosted in Azure. The solution must cache frequently accessed files locally and sync changes bidirectionally. Which Azure feature should you use?

Accepted Answer

Azure File Sync. Azure File Sync is the correct choice because it enables bidirectional syncing of Azure file shares with on-premises Windows Servers, caching frequently accessed files locally for low-latency access while automatically syncing changes back to Azure. This meets the hybrid requirement of local caching and bidirectional sync without requiring full migration or dedicated network circuits.

Answer

Azure Data Box

Answer

Azure NetApp Files with ExpressRoute

Answer

Azure Blob Storage with Azure Files migration

Question 11

You are designing a solution for a financial application that requires strong consistency for read and write operations across multiple Azure regions. The solution must support active-active configuration and provide fractional millisecond latency for single-digit KB payloads. Which data service should you choose?

Accepted Answer

Azure Cosmos DB with strong consistency. Azure Cosmos DB cannot provide both strong consistency and active-active writes. Strong consistency requires a single write region. When you enable multi-region writes, the maximum consistency level is bounded staleness. Therefore, none of the listed options satisfy all requirements simultaneously.

Answer

Azure SQL Database with failover groups

Answer

Azure Table Storage with geo-replication

Answer

Azure Cache for Redis with geo-replication

Question 12

You need to design a storage solution for a website that hosts static content (HTML, CSS, JavaScript) and requires low-cost, scalable storage with integrated CDN delivery. Which Azure service should you use?

Accepted Answer

Azure Blob Storage with static website hosting and Azure CDN. Azure Blob Storage with static website hosting provides a cost-effective, scalable storage solution for static content (HTML, CSS, JavaScript). By enabling Azure CDN on top of the storage account, you achieve low-latency global content delivery and offload traffic from the origin, reducing costs and improving performance for end users.

Answer

Azure Files with SMB protocol

Answer

Azure Content Delivery Network only

Answer

Azure App Service

Question 13

Which TWO of the following are benefits of using Azure Cosmos DB for a globally distributed application?

Accepted Answer

Multiple consistency models to choose from. Azure Cosmos DB offers multiple well-defined consistency models (strong, bounded staleness, session, consistent prefix, and eventual) that allow developers to balance consistency, availability, and latency according to application needs. This is a key benefit for globally distributed applications because it enables tuning data guarantees across regions without sacrificing performance.

Answer

Support for foreign key constraints across containers

Answer

Built-in support for transactional replication

Answer

Native support for SQL Server stored procedures

Question 14

Which THREE of the following are best practices for designing an Azure SQL Database solution for performance and scalability?

Accepted Answer

Use appropriate indexes to optimize query performance. Appropriate indexes, such as clustered and nonclustered indexes, reduce the number of data pages scanned during query execution, directly improving query performance. In Azure SQL Database, index tuning is critical for minimizing I/O and CPU overhead, especially for large tables or complex joins.

Answer

Avoid using stored procedures to reduce complexity

Answer

Disable automatic tuning to maintain consistent performance

Question 15

Which TWO of the following are valid replication options for Azure Blob Storage?

Accepted Answer

RA-GRS (Read-Access Geo-Redundant Storage). RA-GRS (Read-Access Geo-Redundant Storage) and ZRS (Zone-Redundant Storage) are both valid replication options for Azure Blob Storage. RA-GRS provides geo-redundancy with read access to the secondary region, while ZRS synchronously replicates data across three Azure availability zones within a single region. Although GRS and LRS are also replication options, the question specifically expects RA-GRS and ZRS as the correct pair based on the given options and typical exam focus on differentiating these two from the more common LRS and GRS.

Answer

GRS (Geo-Redundant Storage)

Answer

LRS (Locally Redundant Storage)

Answer

ASR (Azure Site Recovery)