Data Storage Solutions

A retail enterprise is migrating a massive 80 TB on-premises SQL Server data warehouse to Azure.

The database experiences highly unpredictable workloads, requiring rapid scaling of compute resources independent of storage. The company requires a fully managed PaaS solution. They do not use any legacy SQL Server features like CLR or cross-database distributed transactions.

Which Azure SQL deployment option should you recommend?

You are designing the disaster recovery strategy for a mission-critical application backed by Azure SQL Database.

The business requires an RPO (Recovery Point Objective) of less than 5 seconds and an RTO (Recovery Time Objective) of less than 1 hour. In the event of a regional outage, the database failover must happen automatically without requiring application connection strings to be updated.

Which feature should you implement?

A media company is building a global content management system using Azure Database for PostgreSQL - Flexible Server.

The application has a heavy read-to-write ratio (90% reads, 10% writes). Users in Europe and Asia are experiencing high latency when reading data, as the primary database is located in East US. You need to improve read performance for global users while maintaining high availability for the primary database in East US.

Which TWO features should you configure? (Select TWO)

You are assessing an on-premises SQL Server 2014 database for migration to Azure.

The application relies heavily on SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and cross-database distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). The company wants to minimize code changes during the migration.

Which target architecture should you recommend?

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?

You are designing an Azure Cosmos DB database for a multi-tenant IoT application.

The application receives telemetry from millions of devices across 5,000 different corporate customers (tenants). You need to select a partition key for the telemetry container.

Requirements:

• Queries frequently filter by TenantId and DeviceId.
• Data must be evenly distributed across logical partitions to avoid hot partitions.
• Some large tenants generate more than 20 GB of telemetry data per month.

Which partition key strategy should you recommend?

A logistics company wants to analyze GPS tracking data from its fleet of 100,000 trucks.

The trucks send location and engine telemetry every 5 seconds. The data engineering team needs to perform complex, ad-hoc time-series analysis on this massive volume of append-only log data to identify route inefficiencies. The query language must support advanced analytics, windowing, and text search.

Which Azure data service is best suited for this workload?

A legal firm has 5 million scanned PDF documents stored in Azure Blob Storage.

They are building an internal search portal. The solution must meet the following requirements:

• Extract printed text (OCR) from the scanned PDFs.
• Identify key entities (people, organizations, locations) within the text.
• Provide a searchable index that users can query via a web application.

Which TWO Azure services should you combine to build this solution? (Select TWO)

You are designing a simple key-value store for a web application.

The application requires storing user session state data. The data volume is small (under 50 GB), the query patterns are extremely simple (lookup by PartitionKey and RowKey), and the primary business requirement is to minimize costs. Global distribution is not required.

Which storage solution should you recommend?

You are migrating an on-premises SQL Server database to Azure.

The database is currently 12 TB in size and is expected to grow by 2 TB annually. The application relies heavily on SQL Server Agent jobs, cross-database queries, and legacy Common Language Runtime (CLR) assemblies. The business requires a fully managed PaaS solution to minimize administrative overhead.

Which Azure data service should you recommend?

You are designing a disaster recovery solution for a mission-critical application backed by Azure SQL Database.

The requirements are:

• The database must automatically fail over to a secondary region if the primary region experiences an outage.
• The application connection string must NOT need to be updated after a failover.
• You must be able to offload read-only reporting queries to the secondary region.

Which TWO features must you configure? (Select TWO)

You are designing an architecture for a new web application that uses Azure Database for PostgreSQL - Flexible Server.

The application requires high availability with an SLA of 99.99%. In the event of an infrastructure failure, the database must fail over automatically with zero data loss (RPO = 0) and minimal downtime.

Which high availability configuration should you recommend?

A company is migrating a third-party vendor application to Azure.

The vendor explicitly states that the application requires sysadmin access to the database server, the ability to install custom third-party agents on the underlying operating system, and support for SQL Server Distributed Transaction Coordinator (MSDTC).

Which database solution MUST you use?

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?

You are designing a globally distributed application using Azure Cosmos DB. The database is replicated across 4 regions.

The application is a social media feed. When a user posts an update, it is critical that the user immediately sees their own post. However, it is acceptable if users in other regions see the post with a slight delay. You want to maximize read throughput and minimize latency.

Which Cosmos DB consistency level should you recommend?

You are designing an Azure Cosmos DB database for an IoT application that tracks vehicle telemetry.

The database will store millions of documents per day. You need to select a partition key. The most common query will retrieve all telemetry for a specific vehicle on a specific date.

Which TWO characteristics describe a good partition key for this workload? (Select TWO)

Your company generates 10 TB of application log data daily.

You need to design a solution to ingest, store, and analyze this data. The analytics team requires the ability to run highly complex, ad-hoc queries over billions of rows of time-series data with sub-second response times. They are proficient in Kusto Query Language (KQL).

Which TWO Azure services are best suited for this architecture? (Select TWO)

You are architecting an e-commerce web application hosted on Azure App Service.

During flash sales, the application experiences massive spikes in traffic, causing the backend Azure SQL Database to become overwhelmed with read requests for the product catalog. The product catalog data changes infrequently.

Which service should you introduce to the architecture to improve performance and reduce the load on the database?

A financial services company is migrating a legacy on-premises application to Azure. The application relies on a SQL Server database.

The database heavily utilizes SQL Server Common Language Runtime (SQL CLR) integration, Service Broker, and cross-database transactions. The company wants to minimize administrative overhead for OS patching and backups, but cannot rewrite the application code.

Which data storage solution should you recommend?

An e-commerce company is designing the database architecture for their new product catalog.

The database is expected to grow rapidly and may exceed 50 TB within the first year. The application requires extremely fast storage scaling and the ability to nearly instantaneously scale out read workloads to multiple compute nodes during holiday sales.

Which Azure SQL Database service tier should you recommend?

A global SaaS provider uses Azure Database for PostgreSQL - Flexible Server for their core application.

The business requires a disaster recovery architecture that meets the following constraints:

1. The database must be replicated to a secondary Azure region.
2. In the event of a primary region failure, the application must be able to fail over to the secondary region.
3. During normal operations, the secondary region database must be accessible for read-only analytical queries to offload reporting workloads.

Which TWO features should you configure to meet these requirements? (Select TWO)

You are designing the high availability architecture for a mission-critical application backed by Azure SQL Database.

The application requires:

• Automatic failover to a secondary region if the primary region goes down.
• The application connection string must NOT require updating after a failover occurs.
• Multiple databases must fail over together simultaneously.

Which feature should you implement?

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)