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

Question 1

Refer to the exhibit. A KQL query is run against Azure Storage logs. The result shows a high number of 404 errors for 'GetBlob' operations. What is the most likely cause?

Accepted Answer

The blobs being requested do not exist. A 404 (Not Found) error for 'GetBlob' operations in Azure Storage logs specifically indicates that the requested blob resource does not exist at the specified URI. This is distinct from authorization failures (which return 403) or throttling (which returns 503). The high number of 404 errors suggests the client is attempting to retrieve blobs that have been deleted, never created, or are referenced with an incorrect path.

Answer

The client does not have permission to access the blobs

Answer

The storage account is throttling requests

Answer

The client is using an incorrect authentication method

Question 2

You are designing a storage solution for a globally distributed application that requires low-latency read access from multiple regions. Which Azure storage solution should you recommend?

Accepted Answer

Azure Cosmos DB with multi-region writes and multiple read regions. Azure Cosmos DB with multi-region writes and multiple read regions is the correct choice because it provides turnkey global distribution with single-digit-millisecond latency for reads and writes from any Azure region. This solution directly addresses the requirement for low-latency read access from multiple regions, as Cosmos DB automatically replicates data to all configured regions and offers multiple consistency models to balance performance and data freshness.

Answer

Azure Blob Storage with read-access geo-redundant storage (RA-GRS)

Answer

Azure SQL Database with active geo-replication

Answer

Azure Files with Azure File Sync

Question 3

Your company uses Azure SQL Database and needs to archive data older than 7 years for compliance. The archived data must be stored in the most cost-effective manner, must be immutable, and must be deleted exactly after 10 years. What should you use?

Accepted Answer

Azure Blob Storage with immutable storage and time-based retention policy. Azure Blob Storage with immutable storage and a time-based retention policy ensures that archived data cannot be modified or deleted until the specified retention period expires. This meets the compliance requirements for immutability and a 10-year deletion timeline, while blob storage tiers (e.g., cool or archive) can be used for cost-effective long-term storage.

Answer

Azure Archive Storage with lifecycle management to delete after 10 years

Answer

Azure SQL Database restore to a point in time with a retention period of 10 years

Answer

Azure SQL Database long-term retention (LTR) backups

Question 4

You need to store billions of small JSON files (average 50 KB) that are accessed infrequently but must be available within seconds when requested. Which Azure storage solution is most cost-effective?

Accepted Answer

Azure Blob Storage Cool tier. Azure Blob Storage Cool tier is the most cost-effective solution for storing billions of small JSON files (average 50 KB) that are infrequently accessed but require low-latency retrieval within seconds. The Cool tier offers low storage costs for data accessed less than once per month, while still providing sub-second access latency for individual blobs via HTTPS REST API, matching the 'available within seconds' requirement without the higher costs of Hot or premium tiers.

Answer

Azure SQL Database with a table storing JSON

Answer

Azure Files with SMB shares

Answer

Azure Cosmos DB with a container for each file

Question 5

You have an Azure SQL Database that stores sales data. You need to ensure that the database can recover to any point in time within the last 35 days. What should you configure?

Accepted Answer

Configure the point-in-time restore (PITR) retention period to 35 days. Point-in-time restore (PITR) for Azure SQL Database allows you to restore a database to any point within the configured retention period. The default retention is 7 days, but you can increase it up to 35 days. By setting the PITR retention period to 35 days, you meet the requirement to recover to any point in time within the last 35 days.

Answer

Configure long-term retention (LTR) backups with a retention of 35 days

Answer

Create a secondary database in the same region

Answer

Enable geo-replication with a readable secondary

Question 6

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

Accepted Answer

Multiple well-defined consistency levels. Azure Cosmos DB offers multiple well-defined consistency levels (Strong, Bounded Staleness, Session, Consistent Prefix, Eventual) that allow developers to balance data consistency, availability, and latency according to application requirements. This flexibility is a key benefit for globally distributed applications because different operations may tolerate different levels of staleness while still meeting SLAs.

Answer

Full support for SQL Server features like stored procedures

Answer

Automatic failover to a secondary region without manual intervention

Answer

Support for only the SQL API

Question 7

Which THREE of the following are considerations when designing a storage solution for a high-availability application on Azure?

Accepted Answer

Recovery Point Objective (RPO) and Recovery Time Objective (RTO). RPO and RTO are fundamental design considerations for any high-availability application. RPO defines the maximum acceptable data loss (measured in time), which directly influences the choice of backup frequency and replication type (e.g., synchronous vs. asynchronous). RTO defines the maximum acceptable downtime, which dictates the failover mechanism and infrastructure redundancy (e.g., active-passive vs. active-active). Both metrics must be explicitly defined before selecting a storage redundancy tier or disaster recovery strategy.

Answer

Data encryption at rest using Azure Storage Service Encryption

Answer

Data striping with RAID 0 for performance

Question 8

Which TWO of the following Azure storage services support hosting static websites?

Accepted Answer

Azure Storage Account (general-purpose v2). Azure Storage Account (general-purpose v2) supports hosting static websites by enabling the 'Static website' feature, which configures a container named '$web' to serve static content (HTML, CSS, JS) directly via a public endpoint. This feature is built into the storage account's blob service and provides automatic routing for index and error documents, making it a cost-effective solution for static site hosting.

Answer

Azure Cosmos DB

Answer

Azure NetApp Files

Answer

Azure Files

Question 9

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 10

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 11

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 12

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 13

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 14

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 15

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