Domain 2.3: Recommend a data storage solution

A hospital needs to store 500 TB of patient X-ray images in Azure Blob Storage. The access pattern is as follows: - Images are accessed frequently during the first 30 days. - From day 31 to 180, images are rarely accessed but must be available immediately if requested. - After 180 days, images are retained for 7 years for compliance but are almost never accessed. Retrieval can take up to 12 hours. You need to design a storage solution that minimizes costs while meeting performance requirements. What should you recommend?

An enterprise is migrating a high-performance computing (HPC) workload and an SAP HANA database to Azure. The workloads require a shared file system that supports the NFSv4.1 protocol, sub-millisecond latency, and throughput of up to 4,500 MiB/s. Which Azure storage service should you recommend?

You are designing a globally distributed e-commerce application using Azure Cosmos DB. The application has a shopping cart feature. You have the following requirements for the shopping cart data: - Users must always be able to read their own latest writes (e.g., if they add an item to the cart, they must see it immediately on the next page load). - The database must provide high availability and low latency. - You want to optimize Request Unit (RU) costs compared to the strongest consistency levels. Which TWO consistency levels meet these requirements? (Select TWO)

A data science team needs to store petabytes of raw data for machine learning. The data will be analyzed using Azure Databricks. The team requires POSIX-compliant Access Control Lists (ACLs) to restrict access at the directory and file level. Which storage solution should you recommend?

A media company stores 500 TB of video files in an Azure Storage account. Data access patterns show that videos are accessed frequently during the first 30 days after upload. From day 31 to 180, they are accessed rarely but must be available immediately if requested. After 180 days, they are kept only for compliance and are almost never accessed, but must be retained for 5 years. You need to design a cost-optimized storage solution. What should you configure?

You are designing the storage architecture for a massive SAP HANA deployment on Azure Virtual Machines. The database data and log files require a shared file storage solution that provides sub-millisecond latency, extremely high throughput, and supports the NFSv4.1 protocol. The business is willing to pay a premium for the highest possible performance. Which THREE characteristics describe the appropriate Azure storage service for this workload? (Select THREE)

You are designing a data lake for a financial institution using Azure Data Lake Storage Gen2. The security team requires granular access control. Specifically, they need to grant a data science team read access to a specific sub-directory (`/finance/2023/Q1/`) without granting them access to the parent directory (`/finance/`) or any other sub-directories. Which feature of ADLS Gen2 makes this possible?

You are provisioning a new Azure Storage account for a critical application. The application requires that data remains highly available even if an entire Azure data center goes offline due to a power failure. However, due to strict data residency laws, the data must NEVER leave the primary Azure region. Which storage redundancy option must you select?

A media company stores 500 TB of video files in an Azure Storage account. Data access patterns show: - Videos are accessed frequently during the first 30 days after upload. - From day 31 to day 180, videos are accessed infrequently. - After 180 days, videos are rarely accessed but must be kept for 5 years for compliance. You need to design a solution that minimizes storage costs without requiring manual intervention. What should you recommend?

A global gaming company is building a multiplayer leaderboard using Azure Cosmos DB. The architecture has the following requirements: 1. The database must be deployed in three regions: US East, Europe West, and Asia East. 2. Users in any region must be able to read and write their scores with less than 10ms latency. 3. When a user updates their score, they must immediately see their own updated score if they refresh the page. 4. It is acceptable if users in other regions see the updated score with a slight delay. Which THREE configurations should you recommend? (Select THREE)

An enterprise is migrating its mission-critical SAP HANA environment to Azure Virtual Machines. The SAP HANA database requires shared file storage that meets the following strict criteria: 1. Sub-millisecond latency. 2. Support for NFS v4.1 protocol. 3. Throughput of at least 4,000 MiB/s. Which TWO actions should you take to provision the appropriate storage? (Select TWO)

A data science team is building a data lake using Azure Storage. They need to store millions of files organized in a deep directory structure. Security requirements dictate that access must be controlled at the individual directory and file level using POSIX-compliant Access Control Lists (ACLs). Furthermore, renaming or moving a top-level directory containing thousands of files must be an atomic operation that completes instantly. Which storage configuration must you use?

A media company stores 500 TB of video files in an Azure Storage Account. The access pattern is highly predictable: videos are accessed frequently in the first 30 days, occasionally between 31 and 90 days, and rarely after 90 days. However, videos must be retained for 7 years for compliance. You need to design a storage solution that minimizes costs while meeting these requirements. Which feature should you implement?

You are designing the storage architecture for a mission-critical SAP HANA deployment on Azure Virtual Machines. The database requires shared file storage that supports the NFS v4.1 protocol, sub-millisecond latency, and extremely high throughput (up to 4,500 MiB/s). The solution must be a fully managed service. Which storage solution should you recommend?

You are designing an Azure Cosmos DB database for a global IoT application. Millions of devices will write telemetry data continuously. The data will be queried heavily by a dashboard that filters by `DeviceId` and `Date`. You need to select a partition key that ensures even distribution of storage and throughput (Request Units) to avoid 'hot partitions'. Which TWO partition key strategies would be effective? (Select TWO)

A healthcare company requires a storage solution for patient records. Compliance mandates that the data must be highly available within the primary region, surviving a datacenter failure. Additionally, the data must be replicated to a secondary region hundreds of miles away for disaster recovery. In the event of a regional outage, the secondary region must be available for read access immediately without waiting for a failover. Which storage redundancy option should you recommend?

A healthcare company must retain patient X-ray images for 7 years to meet regulatory compliance. The images are frequently accessed during the first 30 days. After 30 days, they are rarely accessed. After 1 year, they are almost never accessed but must be kept for the remaining 6 years. You need to design a storage solution that minimizes costs. Which Azure Storage lifecycle management policy should you implement?

You are migrating a mission-critical SAP HANA environment to Azure Virtual Machines. The database requires a shared file storage solution that supports the NFS v4.1 protocol. The storage must deliver sub-millisecond latency and support up to 450,000 IOPS to meet the SAP HANA certification requirements. Which Azure storage service should you recommend?

You are designing the storage architecture for a financial application. The application stores transaction receipts in an Azure Storage account. The business requires that the data remains highly available even if an entire Azure region goes offline. Furthermore, if a region fails, the application must still be able to read the receipts from the secondary region immediately, without waiting for Microsoft to initiate a failover. Which TWO storage redundancy options meet these requirements? (Select TWO)

A global social media company uses Azure Cosmos DB to store user posts. The database is replicated across 5 regions globally. The application requires that when a user makes a post, their followers in other regions see the posts in the exact order they were written. However, to maintain high performance, the company is willing to accept a slight delay (up to 5 seconds) before the posts appear in other regions. Which Cosmos DB consistency level should you configure?

A media company stores 500 TB of video files in Azure Blob Storage. Files are accessed frequently for the first 30 days, occasionally for the next 90 days, and rarely afterward. However, compliance requires retaining all files for 7 years. You need to minimize storage costs while meeting these requirements. What should you design?

You are migrating a high-performance computing (HPC) workload to Azure. The application requires a shared file system accessible via NFS v3. It demands sub-millisecond latency and throughput of up to 4,500 MiB/s. Which storage solution should you recommend?

You are designing an Azure Cosmos DB database for an e-commerce application. The database will store product catalog data. You need to select a partition key. The catalog has 10,000 categories and 5 million products. Queries almost always filter by 'CategoryId'. You need to ensure even distribution of storage and throughput. Which TWO statements describe the characteristics of a good partition key in this scenario? (Select TWO)

A web application hosted on Azure App Service experiences slow page load times due to frequent, repetitive database queries to an Azure SQL Database. The data changes infrequently. You need to improve application performance and reduce the load on the database. What should you recommend?