AZ-305 Design data storage solutions — All Questions With Answers

Read the full Design data storage solutions explanation →

A multinational company stores large amounts of unstructured data (documents, images) that must be read with low latency from multiple global regions. Data is written primarily in one region but read globally. Cost optimization is a key requirement. Which Azure storage replication option should they use?

Question 2mediummultiple choice

A startup is building a social media analytics platform that processes streaming data. They need a data store for time-series events with high write throughput and fast timestamp-based range queries. Which Azure data store is most suitable for this workload?

Question 3hardmultiple choice

Read the full Design data storage solutions explanation →

A company ingests millions of IoT events per second from sensors around the world. Each event is a JSON message with timestamp, device ID, and readings. They need to support real-time analytics dashboards and also store all raw data for long-term historical analysis. They want to minimize operational overhead. Which Azure data storage solution should they recommend?

Question 4mediummultiple choice

Read the full Design data storage solutions explanation →

A company runs a legacy application on Azure Virtual Machines. The application uses a SQL Server database that requires 50,000 IOPS consistently. It also uses a shared file system for storing documents. They plan to migrate from on-premises where they used a SAN for block storage and NAS for file shares. Which combination of Azure storage should they use to meet performance requirements?

Question 5mediummultiple choice

A company needs a fully managed NoSQL database for a JSON document-oriented application that requires low latency (single-digit milliseconds) for reads and writes at any scale. The application will run globally and needs multi-region writes with automatic failover. Which Azure data store should they use?

Question 6hardmultiple choice

Read the full Design data storage solutions explanation →

A company needs to store and analyze petabytes of semi-structured data from IoT devices. The data is append-only and written in time order. They need to support fast queries on time ranges and also aggregate data in real-time. Which Azure data service should they use?

Question 7mediummultiple choice

Read the full Design data storage solutions explanation →

A company is building a big data analytics platform that will process structured, semi-structured, and unstructured data using Azure Synapse Analytics and other tools. They need a storage layer that supports hierarchical namespaces and fine-grained access control at the directory level. Which Azure storage solution should they use?

Question 8easymultiple choice

Read the full Design data storage solutions explanation →

A company wants to store raw data from IoT devices, social media feeds, and transactional databases for analytics. They need a storage solution that supports a hierarchical namespace for organizing data into directories and allows fine-grained access control at the directory and file level. They also need to query the data using Azure Synapse Analytics in-place. Which Azure storage solution should they use?

Question 9easymultiple choice

Read the full Design data storage solutions explanation →

A company runs a line-of-business application on Azure VMs that requires a highly available, low-latency SMB file share with support for active-active access from multiple VMs. The application requires high IOPS and throughput, and the file share must be mountable on both Linux and Windows VMs. Which Azure file storage solution should they recommend?

Question 10easymultiple choice

Read the full Design data storage solutions explanation →

A global e-commerce company needs a database solution that can handle high-velocity writes from user transactions across multiple regions. They require multi-region writes with automatic conflict resolution and single-digit millisecond latency for reads and writes. Which Azure data store should they use?

Question 11mediummultiple choice

Read the full Design data storage solutions explanation →

A media company stores large video files that are accessed once a month for audits. When needed, they must be available for download immediately (within seconds). The company wants to minimize storage costs. Which Azure Blob Storage access tier should they use?

Question 12easymultiple choice

Read the full Design data storage solutions explanation →

A startup is building a new mobile app backend. They need a fully managed relational database service with built-in high availability, automatic backups, and built-in intelligence to optimize performance. They want to minimize administrative overhead for tasks like patching and scaling. Which Azure service should they use?

Question 13mediummultiple choice

A company needs a data storage solution for a global application that frequently accesses recent data and less frequently older data. Data is unstructured blobs. They want to automatically move blobs to cool storage after 30 days and to archive storage after 90 days. Additionally, blobs must be retained for 7 years and cannot be deleted or modified during that period. Which Azure Blob Storage features should they combine?

Question 14easymultiple choice

Read the full Design data storage solutions explanation →

A company needs a fully managed NoSQL database for a new application with a key-value and document data model. They require single-digit millisecond latency at any scale, multi-region writes with automatic conflict resolution, and a serverless capacity option to handle unpredictable traffic. Which Azure data service should they use?

Question 15easymultiple choice

Read the full Design data storage solutions explanation →

A financial company must store customer transaction records in Azure Blob Storage. Regulatory requirements mandate that the records must not be modified or deleted for 7 years. Even administrators must be unable to alter or remove the blobs during this period. Which Azure Blob Storage feature should they enable?

Question 16mediummultiple choice

Read the full Design data storage solutions explanation →

A company has 10 branch offices, each with Windows file servers. They want to centralize file storage in Azure and allow each branch office to cache files locally for fast access. The solution must support cloud tiering so that only frequently accessed files are kept locally. Which Azure service should they implement?

Question 17mediummultiple choice

A SaaS company uses Azure SQL Database for a multi-tenant application. They have 80 tenant databases, each with varying and unpredictable usage patterns. The company wants to optimize costs without sacrificing performance and wants the ability to easily add new tenant databases without over-provisioning. Which deployment option should they use?

Question 18hardmultiple choice

Read the full Design data storage solutions explanation →

A company needs to store large amounts of unstructured data (log files) for analytics. The data is accessed frequently for the first 30 days, then occasionally for the next 90 days, and rarely after that but must be retained for 7 years for compliance. The data must not be modified or deleted during the retention period, and administrative access must not be able to bypass this restriction. They want to minimize storage costs. Which combination of Azure Blob Storage features should they configure?

Question 19hardmultiple choice

A global e-commerce platform requires a database that supports multi-region writes with automatic conflict resolution and single-digit millisecond latency for reads and writes from any region. The application uses a flexible schema with JSON documents. They also need to enforce strong consistency for critical operations (e.g., order placement) while allowing eventual consistency for less critical reads. Which Azure data service and configuration should they choose?

Question 20easymultiple choice

Read the full Design data storage solutions explanation →

A company stores website static assets in Azure Blob Storage. The assets are updated weekly and must be available for immediate access for 30 days. After 30 days, older versions can be moved to the Cool tier to save costs but must still be accessible within seconds. They want an automated solution. What should they configure?

Question 21mediummultiple choice

Read the full Design data storage solutions explanation →

A company wants to cache frequently accessed session state and product data for their e-commerce website. They need the cache to be highly available with a 99.9% SLA and provide fast read and write access. The solution must be fully managed. Which Azure Cache tier should they choose?

Question 22hardmultiple choice

Read the full Design data storage solutions explanation →

A company runs large-scale analytics workloads using Apache Hadoop and Spark. They need a cloud storage solution that is fully compatible with the Hadoop Distributed File System (HDFS) and provides unlimited storage with high throughput for parallel processing. They also want to take advantage of tiered storage to reduce costs for older data. Which Azure data service should they use?

Question 23mediummultiple choice

A company is building a new application that requires a fully managed relational database. The application has varying workloads across different databases. The company wants to pool resources to optimize cost and allow each database to scale as needed. They also need automated backups with point-in-time restore and geo-replication for disaster recovery. Which Azure data service should they use?

Question 24hardmultiple choice

Read the full Design data storage solutions explanation →

A company is building a petabyte-scale data lake for analytics. They need a storage solution that supports a hierarchical namespace, POSIX-like permissions (ACLs), and is optimized for big data analytics workloads using Apache Spark and Hive. The data must be accessible over the Azure Blob Storage API. Which Azure data service should they use?

Question 25easymultiple choice

Read the full Design data storage solutions explanation →

A software company runs 50 small Azure SQL databases for different clients. Each database has low average usage but unpredictable spikes. The company wants to minimize cost while providing resources for peak loads and easily adding new databases without manual sizing. Which Azure data service should they use?

Question 26hardmultiple choice

A global IoT platform ingests telemetry data from millions of devices. The application requires multi-region writes to support low-latency ingestion from any location. The schema uses JSON documents and fields often vary. The team needs automatic conflict resolution when the same document is updated concurrently from different regions. Additionally, read operations for device commands must use strong consistency, while user-facing dashboard queries can use eventual consistency. Which Azure Cosmos DB configuration should they choose?

Question 27mediummultiple choice

Read the full Design data storage solutions explanation →

A company runs a custom analytics application that reads data using the NFS 3.0 protocol. The data consists of large files organized in a directory structure. The application also requires POSIX-like access control lists (ACLs) for fine-grained permissions. The solution must be fully managed and support high throughput for parallel reads. Which Azure data service should they use?

Question 28mediummultiple choice

A company uses Azure SQL Database (Premium tier) for their application. They need to offload reporting queries to a read-only copy of the database to reduce load on the primary. The read-only copy must be kept in sync synchronously within the same Azure region. They also need automated failover to the read-only copy if the primary fails. Which Azure SQL Database feature should they enable?

Question 29easymultiple choice

Read the full Design data storage solutions explanation →

A company needs to store massive amounts of unstructured data, such as images and videos, for a media processing application. The data must be accessible via REST APIs and support tiered storage for cost optimization. Which Azure storage solution should they use?

Question 30mediummultiple choice

Read the full Design data storage solutions explanation →

A company deploys a web application on Azure VMs. The application stores session state and frequently accessed product data. They need a low-latency, in-memory cache to reduce database load and improve response times. The cache must be managed and support data persistence with replication across availability zones within the region. Which Azure service and tier should they choose?

Question 31mediummultiple choice

Read the full Design data storage solutions explanation →

A software company hosts multiple small databases for different clients on Azure SQL Database. Each database has low average usage but experiences unpredictable spikes. The company wants to minimize cost by pooling resources across databases while allowing each database to consume resources up to a set limit during spikes. They also need the ability to easily add new databases without manual sizing. Which Azure SQL Database deployment option should they choose?

Question 32hardmultiple choice

Read the full Design data storage solutions explanation →

A company is building a petabyte-scale data lake for analytics. The workload includes Apache Spark and Hive jobs that read and write large files. The storage solution must support a hierarchical namespace for efficient directory operations, POSIX-like access control lists (ACLs) for fine-grained permissions, and must be accessible via the Azure Blob Storage API for compatibility with existing tools. Furthermore, the solution should be optimized for analytics workloads with high throughput. Which Azure data service should they choose?

Question 33mediummultiple choice

A media company needs to store large volumes of video files that are processed by an application. The files are accessed via REST APIs and are rarely accessed after the first few days. The company wants to minimize storage costs by automatically moving older files to a cheaper storage tier without any manual intervention. Which Azure storage solution should they use, and which feature should they configure?

Question 34easymultiple choice

Read the full Design data storage solutions explanation →

A media company stores raw video files and processed output in Azure. These files are accessed via REST APIs by a processing application. After processing, the files are rarely accessed but must be retained. To minimize costs, the company wants to automatically move files to a cheaper storage tier after 30 days and archive them after 90 days. Which Azure storage solution and feature should they use?

Question 35mediummultiple choice

Read the full Design data storage solutions explanation →

A global e-commerce platform uses Azure Cosmos DB for its product catalog. The application requires multi-region writes to provide low-latency updates from any geographic location. Two users may update the same product item concurrently, so the solution must automatically resolve conflicts. For real-time inventory checks, reads must be strongly consistent, while product description reads can be eventually consistent. Which Cosmos DB configuration should they choose?

Question 36mediummultiple choice

Read the full Design data storage solutions explanation →

A software company hosts 100 small Azure SQL databases for different clients. Each database has low average usage but experiences unpredictable spikes. The company wants to minimize costs while allowing each database to burst up to a maximum resource limit during spikes. They also need to easily add new databases without manual sizing. Which Azure SQL Database deployment option should they use?

Question 37easymultiple choice

Read the full Design data storage solutions explanation →

A company wants to migrate its on-premises file server to Azure with minimal application changes. The application accesses files over the SMB protocol and requires identity-based access using the existing on-premises Active Directory Domain Services (AD DS). They need the solution to be fully managed with low latency. Which Azure storage solution should they choose?

Question 38easymultiple choice

Read the full Design data storage solutions explanation →

A company stores log data in Azure Blob Storage. Logs are accessed frequently for the first 30 days, then rarely accessed but must be retained for 7 years for compliance. They want to minimize storage costs. Which storage tier and lifecycle management rule should they use?

Question 39easymultiple choice

Read the full Design data storage solutions explanation →

A company runs a global e-commerce application that needs to store product catalog data. The data is JSON documents with variable schemas. The application requires single-digit millisecond read and write latencies at any scale and must support automatic synchronous replication across multiple Azure regions for high availability and low latency reads from any region. Which Azure data service should they choose?

Question 40mediummultiple choice

Read the full Design data storage solutions explanation →

A company stores large amounts of log data in Azure Blob Storage. Logs are accessed frequently for the first 30 days, then rarely accessed afterward, but must be retained for 7 years for compliance. The company wants to minimize storage costs. They need to configure automatic data movement and retention policies. Which combination of Azure Blob Storage access tiers and lifecycle management policy should they use?

Question 41mediummultiple choice

A company runs a SQL Server database on an Azure virtual machine in a single region. They need to increase storage capacity and improve I/O performance for their transaction-intensive workload. They also want to ensure high availability within the same datacenter (99.99% SLA). What should they do?

Question 42mediummultiple choice

Read the full Design data storage solutions explanation →

A company wants to migrate its on-premises file server to Azure. The application accesses files using the Server Message Block (SMB) protocol and requires identity-based access integrated with on-premises Active Directory Domain Services (AD DS). The solution must be fully managed and provide low latency for users within the same region. Which Azure solution should they choose?

Question 43mediummultiple choice

Read the full Design data storage solutions explanation →

A company ingests IoT sensor data into Azure Blob Storage. Data is written frequently and accessed rarely after the first 24 hours. The company must retain the data for exactly 90 days for compliance. They want to minimize storage costs by automatically moving data to cheaper tiers as soon as possible. Which lifecycle management policy should they implement?

Question 44mediummultiple choice

Read the full Design data storage solutions explanation →

A company is migrating a MongoDB-compatible application to Azure. The application requires low-latency reads and writes globally. It needs to support multi-region writes so that updates can be made from any region with automatic conflict resolution. The data is JSON documents that can vary in schema. The company wants a fully managed database service with native support for MongoDB APIs. Which Azure data service should they choose?

Question 45mediummultiple choice

A company runs a global e-commerce application that stores customer order data. The data must be highly available and durable. The application requires strong consistency for all reads and writes. The company needs to store relational data (orders, customers) and handle complex queries with joins. They want a fully managed database service that supports active geo-replication for disaster recovery across two Azure regions with automatic failover. Which Azure database service should they choose?

Question 46hardmultiple choice

Read the full Design data storage solutions explanation →

A company stores terabytes of archival data that must be retained for 10 years per regulatory requirements. The data is accessed infrequently (once or twice per year) and retrieval latency of up to 5 hours is acceptable. The company wants the lowest storage cost. They also need to ensure data is encrypted at rest and immutability to prevent deletion or modification during the retention period. Which Azure storage solution should they choose?

Question 47mediummultiple choice

Read the full Design data storage solutions explanation →

A company runs a SQL Server database on an Azure virtual machine. They need to increase the storage capacity and improve I/O performance for their transaction log. The current data disk is a standard HDD. They want to achieve higher IOPS and throughput without increasing the size of the VM (the VM size supports up to 8 data disks). The database workload is write-intensive on the transaction log. Which configuration should they implement?

Question 48mediummultiple choice

Read the full Design data storage solutions explanation →

A company ingests IoT sensor data into Azure Blob Storage. Data is written frequently and is accessed rarely after the first 24 hours. The company must retain the data for exactly 90 days for compliance. They want to minimize storage costs by automatically moving data to the cheapest possible storage tier as soon as possible. Which Azure Blob Storage lifecycle management policy should they implement?

Question 49mediummultiple choice

Read the full Design data storage solutions explanation →

A company stores log data in Azure Blob Storage. The logs are accessed frequently for the first 30 days, then only occasionally for up to 1 year, and after that must be retained for 7 years for compliance purposes. The company wants to minimize storage costs by automatically moving data to cheaper tiers. Which Azure Blob Storage lifecycle management policy should they implement?

Question 50mediummultiple choice

Read the full Design data storage solutions explanation →

A company is building a global real-time collaboration platform. The application data is stored as JSON documents and needs to be available for low-latency reads and writes from multiple geographic regions. The application must support multi-region writes so that users can update data from any region with automatic conflict resolution. The company wants a fully managed database service with a guaranteed SLA for availability and throughput. Which Azure data service should they choose?

Question 51mediummultiple choice

Read the full Design data storage solutions explanation →

A company stores JSON documents for a mobile app backend. The data needs to be accessible from multiple global regions with low latency writes from any region. The app uses a client-side library that supports automatic conflict resolution for concurrent updates. Which Azure data service should they choose?

Question 52mediummultiple choice

Read the full Design data storage solutions explanation →

A company is migrating a large on-premises SQL Server database to Azure SQL Managed Instance. They need to minimize downtime during migration. The database is 500 GB and the network link is 1 Gbps. Which migration approach should they recommend?

Question 53hardmultiple choice

Read the full Design data storage solutions explanation →

A company stores petabytes of image files for a content delivery network. The images are accessed frequently for the first week, then rarely afterward. They must be retained for 5 years for compliance. The company wants to minimize storage costs while maintaining performance for frequently accessed data. Which storage solution and tier strategy should they recommend?

Question 54mediummultiple choice

Read the full Design data storage solutions explanation →

A company ingests millions of IoT sensor data points per second. They need a fully managed analytics service optimized for time-series data that can ingest high-velocity data, perform real-time analytics, and store data for historical analysis. The solution must integrate with Azure Stream Analytics for stream processing. Which Azure data service should they choose?

Question 55mediummultiple choice

Read the full Design data storage solutions explanation →

A company needs to store large amounts of unstructured file data (documents, images) that is accessed concurrently from hundreds of Azure VMs. The data must be accessible via the SMB protocol and provide low-latency, high-throughput performance. The solution must be fully managed and support up to 1000 simultaneous connections. Which Azure storage solution should they choose?

Question 56hardmultiple choice

Read the full Design data storage solutions explanation →

A company runs a large-scale write-intensive application that requires a horizontally scalable relational database. They need to distribute data across multiple nodes to handle high write throughput while supporting SQL queries, including joins and transactions. The solution must be fully managed and provide elastic scaling. Which Azure database service should they choose?

Question 57mediummultiple choice

Read the full Design data storage solutions explanation →

A global e-commerce company runs a product catalog application that requires low-latency reads and writes from multiple geographic regions. The data is key-value structured and must be replicated with multi-region write capability. The company needs a fully managed NoSQL database service with guaranteed 99th percentile latency and automatic conflict resolution. Which Azure data service should they choose?

Question 58mediummultiple choice

Read the full Design data storage solutions explanation →

A company stores unstructured data such as documents and images in Azure Blob Storage. The data is accessed frequently for the first month, then only rarely for the next year, and after that must be retained for 10 years for compliance. The company wants to minimize storage costs by automatically moving data to the most cost-effective storage tiers. Which Azure Blob Storage feature should they implement?

Question 59hardmultiple choice

Read the full Design data storage solutions explanation →

A company runs a high-performance computing (HPC) workload that requires low-latency access to large files (hundreds of GB) from thousands of Azure VMs concurrently. The files must be accessible via the NFS protocol and the solution must be a fully managed, POSIX-compliant file system that can scale throughput linearly with capacity. Which Azure storage solution should they choose?

Question 60mediummultiple choice

Read the full Design data storage solutions explanation →

A company needs to store audit logs for 7 years to meet compliance requirements. The logs are generated at a high volume and must be cost-effective. They need to run occasional queries on recent logs (less than 30 days old) but rarely on older ones. Which Azure storage solution should they recommend?

Question 61easymultiple choice

Read the full Design data storage solutions explanation →

A company needs to store and retrieve large binary files (e.g., images and videos) for a web application. The data must be accessible via HTTPS URLs and support both public read access for anonymous users and private access for administrators. The solution must be highly durable and cost-effective for storing terabytes of data. Which Azure storage solution should they recommend?

Question 62mediummultiple choice

Read the full Design data storage solutions explanation →

A global e-commerce company stores product catalog data in a JSON document format. The application requires low-latency reads and writes from multiple geographic regions. The solution must support multi-region writes with automatic conflict resolution and provide a guaranteed 99th percentile latency. Which Azure Cosmos DB API and consistency level should they choose?

Question 63mediummultiple choice

Read the full Design data storage solutions explanation →

A company runs a data analytics application that stores large volumes of structured data in a relational format. The data is write-intensive and the application needs to scale horizontally for high throughput. The solution must support SQL queries, including joins and ACID transactions. Which Azure database service should they choose?

Question 64mediummultiple choice

Read the full Design data storage solutions explanation →

A company runs a data analytics workload that processes large amounts of unstructured data (images and videos). The data is accessed frequently for the first month, then rarely. They need to store the data cost-effectively for 7 years to meet compliance. The solution must support fast retrieval of data within the first month. Which Azure storage solution should they recommend?

Question 65mediummultiple choice

Read the full Design data storage solutions explanation →

A company needs to store sensor data from IoT devices. Each device sends a message every second. The data is time-series and will be queried for real-time dashboards and historical analysis. The solution must support high ingestion rates and low-latency queries on recent data. Which Azure service should they use?

Question 66easymultiple choice

Read the full Design data storage solutions explanation →

A company stores large video files for a media streaming application. The files are accessed infrequently but need to be available instantly when requested. The company wants to minimize storage costs while ensuring high durability. Which Azure Blob Storage access tier should they use?

Question 67hardmultiple choice

Read the full Design data storage solutions explanation →

A company runs a high-throughput time-series workload that stores sensor data from IoT devices. Data is ingested at a rate of millions of events per second. The application requires low-latency queries (under 100 ms) on recent data (less than 30 days old) and the ability to run occasional analytical queries on historical data older than 30 days. The solution must automatically move cold data to a cost-optimized tier and provide built-in analytics. Which Azure service should they use?

Question 68mediummultiple choice

Read the full Design data storage solutions explanation →

A company manages a fleet of millions of IoT devices that send telemetry data every minute. The data must be stored for 10 years to meet compliance requirements. For the first 30 days, data is accessed frequently for real-time dashboards and alerting. After 30 days, data is only accessed occasionally for historical analysis and reporting. The solution must be cost-effective and support high ingestion rates. Which Azure service should the company use to store and query this data?

Question 69hardmultiple choice

A global e-commerce company uses Azure Cosmos DB to store its product catalog. The catalog is read-heavy, with users worldwide expecting consistent reads with a 99th percentile latency under 10 ms. Writes to the catalog are performed by a central admin team in one region. The company needs to minimize write latency and cost while ensuring that users always see the same data within a single session. Which Cosmos DB configuration should the company choose?

Question 70hardmultiple choice

Read the full Design data storage solutions explanation →

A data platform must support analytical queries over petabytes of files in a data lake, while preserving hierarchical namespaces and fine-grained ACLs. Which storage service should you design around?

Question 71mediummultiple choice

A global company stores customer profile data in JSON format. The application requires low-latency writes and reads from multiple regions. The solution must support multi-region writes with automatic conflict resolution and provide high availability. Which Azure Cosmos DB configuration should they choose?

Question 72easymultiple choice

Read the full Design data storage solutions explanation →

A company wants to store application configuration settings and secrets (e.g., database connection strings, API keys) securely with automatic rotation. Access must be controlled and audited. Which Azure service should they use?

Question 73mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 74mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 75hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 76mediumdrag order

Read the full Design data storage solutions explanation →

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.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 77mediumdrag order

Read the full Design data storage solutions explanation →

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.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 78mediumdrag order

Review the full routing breakdown →

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

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 79mediummatching

Read the full Design data storage solutions explanation →

Match each Azure storage redundancy option to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

3 copies within a single datacenter

3 copies across 3 availability zones in a region

LRS in primary region + LRS in paired secondary region

GRS with read access to secondary region

ZRS in primary region + LRS in paired secondary region

Question 80mediummatching

Read the full Design data storage solutions explanation →

Match each Azure disaster recovery feature to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

Orchestrates replication and failover of VMs

Cloud-based backup for Azure and on-premises workloads

Physically separate datacenter within a region

Logical grouping for fault and update domains

Another Azure region for cross-region replication

Question 81mediummatching

Read the full Design data storage solutions explanation →

Match each Azure governance tool to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

Enforce rules and compliance for resources

Define repeatable set of Azure resources and policies

Hierarchical structure for managing access and policies

Query and explore Azure resources across subscriptions

Monitor, allocate, and optimize cloud costs

Question 82mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 83easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 84hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 85mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 86easymultiple choice

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?

Question 87hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 88mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 89hardmultiple choice

Read the full Design data storage solutions explanation →

A company is designing a disaster recovery strategy for a mission-critical Azure SQL Database. They require a recovery point objective (RPO) of 5 seconds and a recovery time objective (RTO) of 1 hour. Which replication option should they use?

Question 90easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 91mediummulti select

Read the full Design data storage solutions explanation →

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?

Question 92hardmulti select

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 THREE Azure data services should they consider?

Question 93easymulti select

Read the full Design data storage solutions explanation →

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?

Question 94hardmultiple choice

Review the full subnetting walkthrough →

Refer to the exhibit. An Azure SQL Database is deployed in a VNet with a private endpoint at IP 10.0.1.4. The network security group rule shown is applied to the subnet of the private endpoint. A developer reports that they cannot connect to the database from a VM in the same VNet. What is the most likely cause?

Exhibit

{
  "type": "Microsoft.Network/networkSecurityGroups/securityRules",
  "apiVersion": "2023-11-01",
  "properties": {
    "protocol": "Tcp",
    "sourcePortRange": "*",
    "destinationPortRange": "1433",
    "sourceAddressPrefix": "VirtualNetwork",
    "destinationAddressPrefix": "10.0.1.4",
    "access": "Allow",
    "priority": 100,
    "direction": "Inbound"
  }
}

Question 95mediummultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. An organization deployed this ARM template to create a storage account. After deployment, they try to enable geo-redundant storage (GRS) but receive an error. What is the most likely reason?

Exhibit

{
  "variables": {
    "storageAccountName": "[concat('storage', uniqueString(resourceGroup().id))]"
  },
  "resources": [
    {
      "type": "Microsoft.Storage/storageAccounts",
      "apiVersion": "2023-01-01",
      "name": "[variables('storageAccountName')]",
      "location": "[resourceGroup().location]",
      "sku": {
        "name": "Standard_LRS"
      },
      "kind": "StorageV2",
      "properties": {
        "minimumTlsVersion": "TLS1_2",
        "supportsHttpsTrafficOnly": true
      }
    }
  ]
}

Question 96hardmultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. A company is analyzing Azure Storage diagnostic logs using this KQL query. They notice a high number of GetBlob operations on BlockBlobs. The storage account is used for a web application that serves static content. What should they recommend to reduce the number of GetBlob operations?

Exhibit

{
  "query": "AzureDiagnostics | where ResourceProvider == \"MICROSOFT.STORAGE\" | where OperationName == \"GetBlob\" | summarize Count = count() by BlobType, bin(TimeGenerated, 1h) | order by TimeGenerated desc",
  "result": [
    {"BlobType": "BlockBlob", "Count": 1200, "TimeGenerated": "2026-03-15T10:00:00Z"},
    {"BlobType": "PageBlob", "Count": 50, "TimeGenerated": "2026-03-15T10:00:00Z"},
    {"BlobType": "AppendBlob", "Count": 200, "TimeGenerated": "2026-03-15T10:00:00Z"}
  ]
}

Question 97easymultiple choice

Read the full Design data storage solutions explanation →

A company is designing a data storage solution for a globally distributed application that requires low-latency read access to frequently accessed data and high throughput for write operations. The data is non-relational and can be stored as key-value pairs. Which Azure service should they use?

Question 98mediummultiple choice

Read the full Design data storage solutions explanation →

A healthcare organization needs to store patient records that must be immutable and auditable for compliance purposes. The records should be stored in a cost-effective manner with the ability to set retention policies. Which Azure storage solution should they implement?

Question 99hardmultiple choice

A financial services company is migrating its on-premises SAP HANA database to Azure. The database requires high IOPS and low latency with a capacity of 4 TB. They need to choose a storage solution that supports SAP HANA certified configurations. Which Azure storage solution should they use?

Question 100easymultiple choice

Read the full Design data storage solutions explanation →

A company wants to automatically tier data between hot, cool, and archive access tiers based on last access time to optimize costs. Which Azure feature should they implement?

Question 101mediummultiple choice

Read the full Design data storage solutions explanation →

A gaming company stores player session data in Azure Cosmos DB. They need to handle sudden spikes in write traffic without throttling and ensure low-latency reads globally. Which configuration should they use?

Question 102hardmultiple choice

Read the full Design data storage solutions explanation →

A multinational corporation needs to store and analyze petabytes of historical data for regulatory reporting. The data is rarely accessed but must be available for queries within 5 minutes. Which Azure storage solution should they choose to minimize cost?

Question 103easymultiple choice

A company is deploying a containerized microservices application on Azure Kubernetes Service (AKS). The application requires persistent storage that can be attached to pods and supports dynamic provisioning. Which Azure storage solution should they use?

Question 104mediummultiple choice

Read the full Design data storage solutions explanation →

A media company needs to store large video files that are frequently accessed for the first month, then infrequently after that. They want to minimize storage costs while ensuring files are instantly accessible when needed. Which storage strategy should they implement?

Question 105hardmultiple choice

Read the full Design data storage solutions explanation →

A company needs to store sensitive customer data in Azure Blob Storage with encryption at rest using customer-managed keys (CMK) stored in a hardware security module (HSM). Which Azure service should they use to manage the keys?

Question 106mediummulti select

Read the full Design data storage solutions explanation →

Which TWO of the following are benefits of using Azure Files shares for lift-and-shift migrations of on-premises file servers?

Question 107hardmulti select

Read the full Design data storage solutions explanation →

Which THREE of the following are best practices for designing a data storage solution using Azure Cosmos DB?

Question 108easymulti select

Read the full Design data storage solutions explanation →

Which TWO of the following are true about Azure Blob Storage access tiers?

Question 109hardmultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. A custom Azure RBAC role is defined as shown. A user assigned this role is unable to delete blobs in a container. What is the most likely reason?

Exhibit

Refer to the exhibit.

```json
{
  "roleName": "CustomStorageRole",
  "permissions": [{
    "actions": [
      "Microsoft.Storage/storageAccounts/blobServices/containers/read",
      "Microsoft.Storage/storageAccounts/blobServices/containers/write"
    ],
    "notActions": [],
    "dataActions": [
      "Microsoft.Storage/storageAccounts/blobServices/containers/blobs/read",
      "Microsoft.Storage/storageAccounts/blobServices/containers/blobs/write"
    ],
    "notDataActions": []
  }]
}
```

Question 110mediummultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. An organization deploys this ARM template to create a storage account. They need to ensure that data is replicated synchronously across two Azure regions. Does this template meet the requirement?

Exhibit

Refer to the exhibit.

```json
{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "storageAccountName": {
      "type": "string"
    }
  },
  "resources": [
    {
      "type": "Microsoft.Storage/storageAccounts",
      "apiVersion": "2023-01-01",
      "name": "[parameters('storageAccountName')]",
      "location": "[resourceGroup().location]",
      "sku": {
        "name": "Standard_GRS"
      },
      "kind": "StorageV2",
      "properties": {
        "supportsHttpsTrafficOnly": true
      }
    }
  ]
}
```

Question 111easymultiple choice

Read the full Design data storage solutions explanation →

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?

Exhibit

Refer to the exhibit.

```sql
SELECT 
  OperationName,
  COUNT(*) AS OperationCount
FROM 
  StorageBlobLogs
WHERE 
  TimeGenerated > ago(1h)
  AND StatusCode == 404
GROUP BY 
  OperationName
ORDER BY 
  OperationCount DESC
```

Question 112easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 113mediummultiple choice

Read the full Design data storage solutions explanation →

Your company runs a critical database on Azure SQL Managed Instance. You need to ensure zero data loss and automatic failover to a secondary region in the event of a regional outage. What should you configure?

Question 114hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 115easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 116mediummultiple choice

Read the full Design data storage solutions explanation →

Your company is migrating on-premises Oracle databases to Azure. The new solution must support a minimum of 99.99% availability SLA and allow for schema changes with minimal downtime. What should you recommend?

Question 117hardmultiple choice

Read the full Design data storage solutions explanation →

You are designing a data storage solution for a healthcare application that stores patient records. The solution must meet compliance requirements that data in the US must be stored in US regions, and data in the EU must be stored in EU regions. Additionally, the solution must support global queries with low latency. What should you use?

Question 118easymultiple choice

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?

Question 119mediummultiple choice

Read the full Design data storage solutions explanation →

Your company uses Azure Cosmos DB for a globally distributed application. You need to ensure that writes in one region are not lost if that region fails. Which consistency level should you use to guarantee that writes are durable?

Question 120hardmultiple choice

Read the full Design data storage solutions explanation →

You are designing a data lake solution using Azure Data Lake Storage Gen2. The solution must support file-level security for sensitive data and must integrate with Azure Purview for data cataloging. What should you use for file-level security?

Question 121mediummulti select

Read the full Design data storage solutions explanation →

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

Question 122hardmulti select

Read the full Design data storage solutions explanation →

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

Question 123easymulti select

Read the full Design data storage solutions explanation →

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

Question 124mediummultiple choice

Read the full Design data storage solutions explanation →

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

Exhibit

Refer to the exhibit. The following is an Azure Policy definition: 
{
  "if": {
    "field": "type",
    "equals": "Microsoft.Storage/storageAccounts"
  },
  "then": {
    "effect": "deny",
    "details": {
      "field": "Microsoft.Storage/storageAccounts/supportsHttpsTrafficOnly",
      "equals": false
    }
  }
}

Question 125hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Exhibit

Refer to the exhibit. The following is an Azure CLI command output:
{
  "id": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Storage/storageAccounts/st1",
  "kind": "StorageV2",
  "properties": {
    "accessTier": "Hot",
    "supportsHttpsTrafficOnly": true,
    "encryption": {
      "keySource": "Microsoft.Storage",
      "services": {
        "blob": {
          "enabled": true,
          "keyType": "Account"
        },
        "file": {
          "enabled": true,
          "keyType": "Account"
        }
      }
    },
    "networkAcls": {
      "bypass": "AzureServices",
      "defaultAction": "Deny",
      "ipRules": [],
      "virtualNetworkRules": []
    }
  }
}

Question 126easymultiple choice

Read the full Design data storage solutions explanation →

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

Exhibit

Refer to the exhibit. The following is a Bicep snippet for an Azure Cosmos DB account:
resource cosmosAccount 'Microsoft.DocumentDB/databaseAccounts@2024-08-15' = {
  name: 'mycosmos'
  location: resourceGroup().location
  properties: {
    databaseAccountOfferType: 'Standard'
    locations: [
      {
        locationName: 'East US'
        failoverPriority: 0
      }
      {
        locationName: 'West US'
        failoverPriority: 1
      }
    ]
  }
}

Question 127mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 128easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 129hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 130mediummultiple choice

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?

Question 131easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 132hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 133mediummultiple choice

Read the full Design data storage solutions explanation →

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?

Question 134hardmultiple choice

Read the full Design data storage solutions explanation →

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?

Question 135easymultiple choice

Read the full Design data storage solutions explanation →

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?

Question 136mediummulti select

Read the full Design data storage solutions explanation →

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

Question 137hardmulti select

Read the full Design data storage solutions explanation →

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

Question 138easymulti select

Read the full Design data storage solutions explanation →

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

Question 139hardmultiple choice

Read the full Design data storage solutions explanation →

You are reviewing the encryption settings of an Azure Storage account using the above JSON output. What is the current encryption status for files stored in Azure Files shares in this account?

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "defaultEncryption": false,
    "encryption": {
      "keySource": "Microsoft.Storage",
      "services": {
        "blob": {
          "enabled": true
        },
        "file": {
          "enabled": false
        }
      }
    }
  }
}
```

Question 140mediummultiple choice

Read the full Design data storage solutions explanation →

You are deploying an Azure SQL Database using the ARM template snippet above. Which of the following describes the resulting database configuration?

Exhibit

Refer to the exhibit.

```json
{
  "type": "Microsoft.Sql/servers/databases",
  "apiVersion": "2023-05-01-preview",
  "name": "mydatabase",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 1073741824,
    "requestedServiceObjectiveName": "S3",
    "zoneRedundant": false
  }
}
```

Question 141easymultiple choice

Read the full Design data storage solutions explanation →

You are reviewing the data protection settings of an Azure Blob Storage container using the above JSON. Which of the following is true?

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "isVersioningEnabled": true,
    "deleteRetentionPolicy": {
      "enabled": true,
      "days": 7
    },
    "restorePolicy": {
      "enabled": true,
      "days": 30
    }
  }
}
```

Question 142mediummultiple choice

Read the full Design data storage solutions explanation →

Your company is designing a data storage solution for a global e-commerce platform. The solution must support high-frequency read and write operations with sub-millisecond latency, and must be able to handle schema-less JSON documents. Which Azure data service should you recommend?

Question 143hardmultiple choice

A multinational corporation needs to store sensitive customer data in Azure. The data must be encrypted at rest using a customer-managed key stored in Azure Key Vault, and the key must be rotated every 90 days. The solution must also support geo-redundancy for disaster recovery. Which combination of services should you recommend?

Question 144easymultiple choice

You need to design a storage solution for a large-scale media streaming application. The application serves video files to users worldwide. The solution must minimize latency for end-users and optimize content delivery costs. Which Azure service combination should you use?

Question 145mediummultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. Your Azure policy team has created the following policy definition. After assigning this policy to a subscription, a developer tries to create a new storage account with network ACLs default action set to 'Allow'. What will happen?

Exhibit

{
  "policyRule": {
    "if": {
      "field": "type",
      "equals": "Microsoft.Storage/storageAccounts"
    },
    "then": {
      "effect": "deny",
      "details": {
        "field": "Microsoft.Storage/storageAccounts/networkAcls.defaultAction",
        "equals": "Allow"
      }
    }
  }
}

Question 146hardmultiple choice

Refer to the exhibit. Your team deploys this ARM template to a resource group in West US. After deployment, you need to ensure the storage account is geo-redundant. What is the most efficient way to modify the template to achieve this?

Exhibit

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "storageName": {
      "type": "string",
      "defaultValue": "[uniqueString(resourceGroup().id)]"
    },
    "location": {
      "type": "string",
      "defaultValue": "[resourceGroup().location]"
    }
  },
  "resources": [
    {
      "type": "Microsoft.Storage/storageAccounts",
      "apiVersion": "2023-01-01",
      "name": "[parameters('storageName')]",
      "location": "[parameters('location')]",
      "kind": "StorageV2",
      "sku": {
        "name": "Standard_LRS"
      },
      "properties": {
        "supportsHttpsTrafficOnly": true
      }
    }
  ]
}

Question 147easymultiple choice

Read the full Design data storage solutions explanation →

Your organization is migrating on-premises SQL Server databases to Azure. The databases are mission-critical and require the highest level of availability with automatic failover to a secondary region. Which Azure SQL deployment option should you recommend?

Question 148mediummultiple choice

Read the full Design data storage solutions explanation →

A financial services company needs to store transaction logs for regulatory compliance. The logs must be stored in a cost-effective manner, and they must be immutable to prevent tampering. The logs are accessed infrequently but must be retained for 7 years. Which Azure storage solution should you recommend?

Question 149hardmultiple choice

Read the full Design data storage solutions explanation →

You are designing a data storage solution for an IoT application that ingests millions of events per second. Each event is a small JSON message (under 1 KB). The solution must support real-time analytics and allow queries on recent data (last 24 hours) with low latency. Historical data (older than 24 hours) should be stored in a cost-optimized manner for occasional compliance queries. Which combination of Azure services should you recommend?

Question 150mediummulti select

Which TWO of the following Azure services support storing JSON documents without requiring a predefined schema? (Select two.)

Question 151hardmulti select

Read the full Design data storage solutions explanation →

Which THREE of the following are valid methods to securely transfer data to Azure Blob Storage? (Select three.)

Question 152easymulti select

Read the full Design data storage solutions explanation →

Which TWO of the following are features of Azure SQL Database that help ensure high availability? (Select two.)

Question 153mediummultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. You are deploying an ARM template with the above parameters. After deployment, you need to ensure that the storage account automatically moves blobs that are not accessed for 30 days to the archive tier. What should you do?

Exhibit

{
  "parameters": {
    "storageAccountName": {
      "value": "mystorageaccount"
    },
    "containerName": {
      "value": "logs"
    },
    "accessTier": {
      "value": "Cool"
    },
    "replication": {
      "value": "LRS"
    }
  }
}

Question 154hardmulti select

Read the full Design data storage solutions explanation →

Which THREE of the following are requirements for using Azure SQL Database auto-failover groups? (Select three.)

Question 155hardmultiple choice

Read the full Design data storage solutions explanation →

Your company is designing a data lake solution using Azure Data Lake Storage Gen2. The solution must support hierarchical namespace for efficient directory operations, and must provide encryption at rest using customer-managed keys stored in Azure Key Vault. Which steps must you take to enable customer-managed key encryption for the storage account?

Question 156easymultiple choice

Read the full Design data storage solutions explanation →

You need to provide temporary shared access to a specific blob in Azure Storage for a contractor. The access must expire after 24 hours. Which feature should you use?

Question 157mediummultiple choice

Read the full Design data storage solutions explanation →

A company is designing a storage solution for a critical application that requires low latency (under 5 ms) and high throughput for large files (up to 10 GB). The solution must support NFS and SMB protocols. Which Azure storage solution should you recommend?

Question 158hardmultiple choice

Read the full Design data storage solutions explanation →

Your company stores sensitive customer data in Azure Blob Storage. You must ensure that data is encrypted at rest using customer-managed keys (CMK) and that key rotation is automated. You also need to prevent data from being accessed by any Microsoft administrator. Which solution should you implement?

Question 159easymultiple choice

Read the full Design data storage solutions explanation →

A company needs to store millions of small JSON files (average 10 KB each) for a serverless application. The data must be accessed via HTTPS and support high read throughput. Which Azure storage solution is most cost-effective?

Question 160hardmultiple choice

Read the full Design data storage solutions explanation →

You are reviewing the above Azure Policy definition assigned to a storage account. What does this policy enforce?

Exhibit

Refer to the exhibit.

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Deny",
      "Action": [
        "Microsoft.Storage/storageAccounts/blobServices/containers/write"
      ],
      "Resource": "/subscriptions/sub123/resourceGroups/rg1/providers/Microsoft.Storage/storageAccounts/storage1/blobServices/default/containers/*",
      "Condition": {
        "BoolIfExists": {
          "Microsoft.Storage/encryptionScope": "false"
        },
        "StringNotEquals": {
          "Microsoft.Storage/encryptionScope": "customEncryptionScope"
        }
      }
    }
  ]
}

Question 161mediummultiple choice

Read the full Design data storage solutions explanation →

You are designing a disaster recovery solution for a SQL Server database hosted on an Azure VM. The recovery point objective (RPO) is 5 minutes, and the recovery time objective (RTO) is 1 hour. Which strategy should you recommend?

Question 162easymultiple choice

Read the full Design data storage solutions explanation →

A company wants to store log data from multiple applications for up to 30 days for analysis. The data is append-only, and queries are infrequent but need to be fast when run. Which Azure data storage solution should you recommend?

Question 163mediummultiple choice

Read the full Design data storage solutions explanation →

You need to design a storage solution for a global e-commerce application that requires low-latency access to product catalog data across multiple Azure regions. The data is read-heavy and updates are rare. Which service should you use for the primary data store?

Question 164hardmultiple choice

Read the full Design data storage solutions explanation →

You deploy the above ARM template. The deployment succeeds. However, you cannot access the storage account from the Azure portal. What is the most likely reason?

Exhibit

Refer to the exhibit.

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "storageName": {
      "type": "string",
      "defaultValue": "mystorageaccount"
    },
    "location": {
      "type": "string",
      "defaultValue": "[resourceGroup().location]"
    }
  },
  "resources": [
    {
      "type": "Microsoft.Storage/storageAccounts",
      "apiVersion": "2023-01-01",
      "name": "[parameters('storageName')]",
      "location": "[parameters('location')]",
      "kind": "StorageV2",
      "sku": {
        "name": "Standard_GRS"
      },
      "properties": {
        "accessTier": "Hot",
        "minimumTlsVersion": "TLS1_2",
        "supportsHttpsTrafficOnly": true,
        "encryption": {
          "keySource": "Microsoft.Storage"
        },
        "networkAcls": {
          "defaultAction": "Deny",
          "virtualNetworkRules": [],
          "ipRules": []
        }
      }
    }
  ]
}

Question 165easymultiple choice

Read the full Design data storage solutions explanation →

Your company uses Azure SQL Database and needs to retain backups for 7 years for compliance. Which backup retention policy should you configure?

Question 166hardmulti select

Read the full Design data storage solutions explanation →

Which TWO options are valid ways to enforce data residency in Azure Storage to ensure data does not leave a specific Azure region?

Question 167mediummulti select

Read the full Design data storage solutions explanation →

Which THREE considerations are important when designing a data archiving solution for Azure Storage to optimize costs?

Question 168easymulti select

Read the full Design data storage solutions explanation →

Which TWO Azure services provide native support for change data capture (CDC) to stream database changes to other systems?

Question 169mediummulti select

Which THREE features are available in Azure Files premium tier that are not available in standard tier?

Question 170hardmulti select

Read the full Design data storage solutions explanation →

Which TWO options can be used to automatically replicate Azure SQL Database to a secondary region for disaster recovery with no data loss in the event of a regional outage?

Question 171hardmultiple choice

Read the full Design data storage solutions explanation →

You run the above PowerShell script to upload a blob to Azure Storage. The script fails with an error: 'The specified container does not exist.' What should you do first to resolve the issue?

Exhibit

Refer to the exhibit.

$connectionString = "DefaultEndpointsProtocol=https;AccountName=mystorage;AccountKey=mykey;EndpointSuffix=core.windows.net"
$containerName = "mycontainer"
$blobName = "myblob.txt"
$content = "Hello, World!"

$ctx = New-AzStorageContext -ConnectionString $connectionString
Set-AzStorageBlobContent -Context $ctx -Container $containerName -Blob $blobName -Value $content -StandardBlobTier Hot

Question 172easymultiple choice

Read the full Design data storage solutions explanation →

A company needs to store video files for a media streaming application. The files are accessed frequently for the first 30 days, then rarely after that. The solution must minimize storage costs while ensuring low-latency access during the initial period. Which storage tier should be used for the first 30 days?

Question 173mediummultiple choice

Read the full Design data storage solutions explanation →

A company uses Azure SQL Database for a line-of-business application. They need to implement a disaster recovery solution across Azure regions with RPO of 5 seconds and RTO of 30 seconds. Which feature should they use?

Question 174hardmultiple choice

Read the full Design data storage solutions explanation →

A company is designing a data storage solution for an IoT pipeline that ingests time-series data from millions of devices. The data is append-only and queried by time range. The solution must support low-latency queries and automated retention policies. Which Azure data store should they choose?

Question 175mediummultiple choice

Read the full Design data storage solutions explanation →

A company needs to store sensitive customer data in Azure Blob Storage. They require encryption at rest using customer-managed keys (CMK) stored in Azure Key Vault. Additionally, they want to prevent data from being accessed if the key is revoked. Which feature should they enable?

Question 176easymultiple choice

Read the full Design data storage solutions explanation →

A company uses Azure Cosmos DB for a globally distributed e-commerce application. They need to ensure that write operations in one region are immediately visible in all other regions. Which consistency level should they choose?

Question 177hardmultiple choice

Read the full Design data storage solutions explanation →

A company is designing a hybrid storage solution to connect on-premises file shares to Azure. They need to cache frequently accessed files locally for low-latency access while storing all files in Azure. The solution must support SMB protocol and integrate with existing Windows file servers. Which Azure service should they use?

Question 178mediummultiple choice

Read the full Design data storage solutions explanation →

A company is migrating on-premises SQL Server databases to Azure. They need to minimize administrative overhead for patching and backups while ensuring high availability. The solution must support automatic failover within the same Azure region. Which Azure service should they choose?

Question 179hardmultiple choice

A company stores petabytes of sensor data in Azure Data Lake Storage Gen2. They need to run complex analytics queries that involve joining multiple datasets and aggregating time-series data. The queries must complete within seconds. Which Azure service should they use for querying?

Question 180mediummultiple choice

Read the full Design data storage solutions explanation →

A company uses Azure Redis Cache to improve the performance of a web application. They need to ensure that cached data survives a failover to a secondary region. Which Azure Redis Cache tier should they choose?

Question 181mediummulti select

Read the full Design data storage solutions explanation →

Which TWO data storage solutions in Azure provide built-in, automatic geo-redundancy for disaster recovery across paired regions?

Question 182hardmulti select

Read the full Design data storage solutions explanation →

Which THREE considerations are important when designing a data storage solution for a high-throughput IoT ingestion pipeline in Azure?

Question 183easymulti select

Read the full Design data storage solutions explanation →

Which TWO Azure services can be used to store unstructured data such as documents, images, and videos?

Question 184easymultiple choice

Read the full Design data storage solutions explanation →

A company plans to store operational logs from Azure App Services in a scalable and cost-effective way. The logs must be retained for 90 days and then automatically deleted. Which Azure data storage solution should you recommend?

Question 185mediummultiple choice

Read the full Design data storage solutions explanation →

A global e-commerce company uses Azure Cosmos DB for its product catalog. The write-heavy workload experiences high latency during peak hours. Which design change would most reduce write latency?

Question 186hardmultiple choice

Read the full Design data storage solutions explanation →

A financial services company needs to store sensitive transaction records in Azure for 7 years to meet regulatory compliance. The data must be immutable and cannot be deleted or modified during the retention period. Which Azure storage feature should you enable?

Question 187easymultiple choice

Read the full Design data storage solutions explanation →

You need to design a data storage solution for a mobile app that requires low-latency reads and writes globally. The data is JSON documents with varying schemas. Which Azure service should you choose?

Question 188mediummultiple choice

Read the full Design data storage solutions explanation →

A healthcare organization stores patient records in Azure SQL Database. They need to ensure that all read queries against the database are directed to a read-only replica to offload the primary. Which feature should you configure?

Question 189hardmultiple choice

A media company uploads large video files to Azure Blob Storage. Users frequently access recent videos, while older videos are rarely accessed after 30 days. The company wants to minimize storage costs while ensuring that recently accessed videos are immediately available. Which storage tier strategy should you recommend?

Question 190easymultiple choice

Read the full Design data storage solutions explanation →

A company needs to store and analyze petabytes of IoT telemetry data. The data is append-only and rarely updated. They require SQL-based querying and columnar storage for fast analytics. Which Azure storage solution should you choose?

Question 191mediummultiple choice

You need to design a disaster recovery strategy for Azure SQL Database. The primary region is East US. The database must be available within 1 hour of a regional outage with no data loss. Which solution meets the requirements?

Question 192hardmultiple choice

Read the full Design data storage solutions explanation →

A company uses Azure NetApp Files for high-performance file shares accessed by Linux VMs. They need to reduce latency for read-heavy workloads. Which configuration should you implement?

Question 193mediummultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. An Azure Policy is assigned to a subscription. A user tries to create a blob container via the Azure portal and receives a deny error. What is the most likely reason?

Exhibit

{
  "statement": "{\"Effect\": \"Deny\", \"Action\": [\"Microsoft.Storage/storageAccounts/blobServices/containers/write\"], \"NotAction\": [], \"Resource\": \"Microsoft.Storage/storageAccounts/*\", \"Condition\": {\"Bool\": {\"acs:RequestAction\": [\"Microsoft.Storage/storageAccounts/blobServices/containers/put\"]}}}",
  "policyName": "DenyContainerCreationWithoutEncryption"
}

Question 194hardmultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. You run a KQL query against Azure Cosmos DB diagnostics logs. The query shows increasing latency for Query operations over time. Which is the most likely root cause?

Exhibit

{
  "query": "AzureDiagnostics | where ResourceProvider == 'MICROSOFT.DOCUMENTDB' | where Category == 'DataPlaneRequests' | summarize avg(DurationMs) by bin(TimeGenerated, 1h), OperationName | order by avg_DurationMs desc",
  "resultSample": "TimeGenerated, OperationName, avg_DurationMs\n2024-01-01 10:00:00, Query, 150\n2024-01-01 11:00:00, Query, 300\n2024-01-01 12:00:00, Query, 450"
}

Question 195mediummulti select

Read the full Design data storage solutions explanation →

Which TWO Azure services can be used to host a MongoDB-compatible database with global distribution? (Select two.)

Question 196hardmulti select

Which THREE factors should you consider when selecting a partition key for an Azure Cosmos DB container? (Select three.)

Question 197easymulti select

Read the full Design data storage solutions explanation →

Which TWO Azure storage replication options provide durability for data in the event of a regional disaster? (Select two.)

Question 198hardmultiple choice

Read the full Design data storage solutions explanation →

Contoso Ltd. is a global retail company with headquarters in New York and operations in Europe and Asia. They are migrating their on-premises SQL Server databases to Azure. The databases include a customer database (500 GB), an orders database (2 TB), and a product catalog database (100 GB). The customer database requires high read throughput with sub-10 ms latency for global users. The orders database must support complex queries and reporting with point-in-time restore capability up to 35 days. The product catalog is updated infrequently but must be available for read-heavy workloads with strong consistency. Contoso wants to minimize costs while meeting performance and compliance requirements. They also need to support hybrid deployments for databases that must remain on-premises due to data sovereignty laws. You need to design a data storage solution. Which combination of Azure services and configurations should you recommend?

Question 199mediummultiple choice

Your company is migrating a critical on-premises database to Azure SQL Managed Instance. The database is 500 GB and requires minimal downtime during migration. You need to choose the best migration approach. What should you recommend?

Question 200hardmultiple choice

Read the full Design data storage solutions explanation →

You are designing a storage solution for a global e-commerce platform that must serve users from multiple regions with low latency. The data includes product catalog (read-heavy, rarely updated) and user session state (write-heavy, short-lived). Which combination of Azure services meets the requirements?

Question 201hardmultiple choice

Your company plans to store sensitive customer data in Azure Blob Storage. The data must be encrypted at rest and in transit. Additionally, access must be audited and restricted based on user identity. Which configuration meets these requirements?

Question 202mediummultiple choice

Read the full Design data storage solutions explanation →

You need to design a disaster recovery strategy for an Azure SQL Database that supports a critical financial application. The recovery point objective (RPO) is 5 seconds and recovery time objective (RTO) is 30 seconds. Which option should you choose?

Question 203easymultiple choice

Read the full Design data storage solutions explanation →

Your company has a large number of unstructured files (images, videos) that need to be stored cost-effectively in Azure. The data is accessed infrequently but must be available within minutes when needed. Which storage tier should you recommend?

Question 204easymultiple choice

Read the full Design data storage solutions explanation →

You need to store semi-structured data from IoT devices in Azure. The data has varying schemas and high write throughput. Which Azure service should you use?

Question 205mediummultiple choice

Read the full Design data storage solutions explanation →

Your organization needs to share large files (up to 100 GB) with external partners securely. The solution must allow partners to access files for a limited time and track who accessed which file. Which Azure solution should you use?

Question 206hardmultiple choice

Read the full Design data storage solutions explanation →

You are designing a data lake for advanced analytics in Azure. The data includes structured, semi-structured, and unstructured data. The solution must support schema-on-read and have the ability to query using SQL. Which Azure service should you choose?

Question 207easymultiple choice

Read the full Design data storage solutions explanation →

Your company needs to store configuration data (key-value pairs) for applications in a highly scalable and low-latency manner. The data is accessed frequently. Which Azure service should you choose?

Question 208mediummulti select

Read the full Design data storage solutions explanation →

Which TWO Azure services can be used to implement a globally distributed database that supports multi-region writes and provides low-latency access to users worldwide? (Choose two.)

Question 209hardmulti select

Read the full Design data storage solutions explanation →

Which THREE considerations are important when designing a storage solution for Azure Virtual Desktop (AVD) user profiles using FSLogix? (Choose three.)

Question 210mediummulti select

Read the full Design data storage solutions explanation →

Which TWO Azure services provide native support for Azure Active Directory (now Entra ID) authentication for accessing data? (Choose two.)

Question 211hardmultiple choice

Your company, Contoso Ltd., is a global financial services firm with a primary data center in London and a disaster recovery site in Paris. They are migrating their on-premises SQL Server databases to Azure. The databases include: (1) a 2-TB customer database with high transaction throughput, requiring an RPO of 5 seconds and an RTO of 30 seconds; (2) a 500-GB reporting database that is read-only and can tolerate an RPO of 1 hour and an RTO of 2 hours; (3) a 100-GB archival database that is accessed once a month. The solution must minimize costs while meeting requirements. You need to recommend a storage and database strategy for each database. What should you recommend?

Question 212hardmultiple choice

AdventureWorks is a global retailer with a cloud-native architecture. They have a microservices application deployed on Azure Kubernetes Service (AKS). Each microservice needs to store its own data. The data requirements vary: (1) Shopping cart service: key-value data with high write throughput and low latency, data can be lost if not critical; (2) Order service: transactional data with strong consistency and ACID compliance; (3) Product catalog service: semi-structured product data that supports complex queries and is globally distributed for low-latency reads. The solution must use Azure PaaS services and minimize operational overhead. You need to design the data storage for each microservice. What should you recommend?

Question 213mediummultiple choice

You are the Azure architect for a healthcare organization that needs to store patient medical records (unstructured data) and provide secure access to doctors and nurses via a web application. The data must be encrypted at rest and in transit. Access must be authorized based on the requester's role (doctor, nurse, admin). The solution must be cost-effective and support high concurrency. You decide to use Azure Blob Storage. You need to design the access control mechanism. What should you recommend?

Question 214mediummultiple choice

Read the full Design data storage solutions explanation →

A multinational corporation is designing a data storage solution for its global customer data. The data must be stored in the Azure region closest to each customer to minimize latency, but all data must be accessible from a central analytics platform for reporting. The solution must also comply with data residency regulations that require customer data to remain in the country of origin. Which Azure storage solution should the company recommend?

Question 215mediummulti select

A company is designing a solution for storing sensitive financial records that must be retained for 7 years. The solution must meet the following requirements: - Data must be immutable during the retention period. - After the retention period, data must be automatically deleted. - The solution must minimize storage costs. Which two Azure services should the company use? (Choose two.)

Question 216hardmulti select

Read the full Design data storage solutions explanation →

A company plans to migrate its on-premises Oracle database to Azure. The database is currently 2 TB and experiences high write throughput. The solution must support: - ACID transactions - Automatic failover to a secondary region - Minimal downtime during maintenance. Which three Azure services should the company include in the solution? (Choose three.)

Question 217easymultiple choice

Read the full Design data storage solutions explanation →

A startup needs a cost-effective data storage solution for its application logs. The logs are accessed infrequently but must be available for audit purposes for up to 3 years. The solution should minimize storage costs while allowing data retrieval within 24 hours when needed. Which Azure storage tier should the company recommend?

Question 218hardmultiple choice

Read the full Design data storage solutions explanation →

You are designing a data storage solution for a global e-commerce platform that handles millions of transactions per day. The platform uses Azure Cosmos DB for its transactional data. The company wants to implement a real-time analytics pipeline to monitor sales trends and detect anomalies. The analytics must be performed on the transactional data with minimal latency (under 5 seconds). The solution must not impact the transactional workload's performance. The analytics queries involve aggregations over time windows and joins with reference data stored in Azure SQL Database. You need to recommend a solution. Which option should you choose?

Question 219mediummultiple choice

Read the full Design data storage solutions explanation →

Refer to the exhibit. You are reviewing the configuration of an Azure Blob Storage container used for storing financial audit records. The exhibit shows the container's immutability policy and legal hold settings. You need to ensure that the audit records cannot be deleted or modified for at least 7 years. What should you do?

Exhibit

{
  "properties": {
    "immutabilityPolicy": {
      "state": "Locked",
      "allowProtectedAppendWrites": false,
      "immutabilityPeriodSinceCreationInDays": 365
    },
    "legalHold": {
      "tags": ["audit-2024"]
    }
  }
}

Question 220mediummultiple choice

A healthcare company is designing a data storage solution for its electronic health records (EHR) system. The system must store patient data in Azure SQL Database with high availability. The solution must meet the following requirements: - Data must be stored in the East US region with automatic failover to a secondary region in West US in case of a regional outage. - The Recovery Point Objective (RPO) must be less than 5 seconds. - The Recovery Time Objective (RTO) must be less than 1 hour. - The solution must minimize costs while meeting the RPO and RTO. Which Azure SQL Database configuration should the company recommend?

Question 221mediummulti select

Read the full Design data storage solutions explanation →

A company is designing a data storage solution for its IoT devices that generate telemetry data. The data is ingested at high velocity (millions of events per second) and must be stored for real-time dashboards and historical analysis. The solution must also support complex event processing and alerting. Which two Azure services should the company use together? (Choose two.)

Question 222mediummultiple choice

A gaming company is developing a multiplayer online game that requires a low-latency data store for player profiles, inventory, and session state. The data is accessed globally, and the solution must support millions of concurrent players. The company expects write-heavy workloads with occasional reads. The solution must provide single-digit millisecond latency for reads and writes. The company also needs to run analytics on the data to understand player behavior, but analytics queries can tolerate higher latency (minutes). Which Azure data storage solution should the company recommend for the transactional data?

Question 223hardmultiple choice

Read the full Design data storage solutions explanation →

A company is designing a disaster recovery solution for its on-premises SQL Server databases that are critical for business operations. The databases are approximately 500 GB each. The solution must meet the following requirements: - Replicate data to Azure with minimal data loss (RPO of 15 minutes). - Automatically failover to Azure in case of an on-premises outage. - Use existing SQL Server licenses to minimize costs. Which Azure service should the company use?

Question 224easymulti select

Read the full Design data storage solutions explanation →

A company is designing a storage solution for its backup data. The backups must be stored for 10 years for compliance reasons. The solution should minimize storage costs while ensuring data durability. Which two Azure services should the company consider? (Choose two.)

Question 225hardmultiple choice

Read the full Design data storage solutions explanation →

A financial services company is designing a data storage solution for its transaction processing system. The system uses Azure Cosmos DB with the Core (SQL) API. The company needs to implement a change data capture (CDC) pipeline to feed a downstream analytics system in near real-time (under 1 minute). The analytics system uses Azure Synapse Analytics. The data volume is approximately 10,000 transactions per second. The solution must minimize operational complexity and cost. Which approach should the company recommend?

Question 226mediummultiple choice