You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be configured for auto-termination. You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The solution must minimize costs. What should you do?

Correct Answer: Clone the cluster after it is terminated.

You are planning a big data solution in Azure. You need to recommend a technology that meets the following requirements: ✑ Be optimized for batch processing. ✑ Support autoscaling. ✑ Support per-cluster scaling. Which technology should you recommend?

Correct Answer: Azure Analysis Services

Inventory levels must be calculated by subtracting the current day's sales from the previous day's final inventory. Which two options provide Litware with the ability to quickly calculate the current inventory levels by store and product? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Correct Answer: Consume the output of the event hub by using Azure Stream Analytics and aggregate the data by store and product. Output the resulting data into Databricks. Calculate the inventory levels in Databricks and output the data to Azure Blob storage.

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?

Correct Answer: a server-level virtual network rule

You need to recommend a security solution that meets the requirements of Health Review. What should you include in the recommendation?

Correct Answer: Transport Layer Security (TLS)

You need to design the unauthorized data usage detection system. What Azure service should you include in the design?

Correct Answer: Azure Databricks

What should you do to improve high availability of the real-time data processing solution?

Correct Answer: Deploy identical Azure Stream Analytics jobs to paired regions in Azure.

You need to recommend a solution for storing the image tagging data. What should you recommend?

Correct Answer: Azure File Storage

You need to recommend a backup strategy for CONT_SQL1 and CONT_SQL2. What should you recommend?

Correct Answer: Configure Azure SQL Database long-term retention for all databases.

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3. Which type of disk should you recommend?

Correct Answer: Ultra SSD Managed Disk

You need to design a solution that meets the business requirements of Health Insights. What should you include in the recommendation?

Correct Answer: Azure Data Factory

You need to design the storage for the visual monitoring system. Which storage solution should you recommend?

Correct Answer: Azure Cosmos DB

Which Azure service should you recommend for the analytical data store so that the business analysts and data scientists can execute ad hoc queries as quickly as possible?

Correct Answer: Azure Stream Analytics

What should you recommend as a batch processing solution for Health Interface?

Correct Answer: Azure CycleCloud

You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?

Correct Answer: row-level security

You are developing a solution that performs real-time analysis of IoT data in the cloud. The solution must remain available during Azure service updates. You need to recommend a solution. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Monitor jobs in the primary region for failure.

You need to design a sharding strategy for the Planning Assistance database. What should you recommend?

Correct Answer: a list mapping shard map on the location column

You need to design the runtime environment for the Real Time Response system. What should you recommend?

Correct Answer: Memory Optimized Nodes without the Enterprise Security package

You need to recommend a solution to quickly identify all the columns in Health Review that contain sensitive health data. What should you include in the recommendation?

Correct Answer: SQL Server auditing

You need to design the solution for analyzing customer data. What should you recommend?

Correct Answer: Azure Data Lake Storage

You need to design the disaster recovery solution for customer sales data analytics. Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Migrate users, notebooks, and cluster configurations from one workspace to another in the same region.

You need to recommend an Azure SQL Database service tier. What should you recommend?

Correct Answer: Business Critical

You need to design the storage for the telemetry capture system. What storage solution should you use in the design?

Correct Answer: Azure Synapse Analytics

You need to design a telemetry data solution that supports the analysis of log files in real time. Which two Azure services should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: Azure Databricks

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution/ You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region. What should you recommend?

Correct Answer: SQL Replication

What should you recommend using to secure sensitive customer contact information?

Correct Answer: column-level security

You need to recommend a solution for storing customer data. What should you recommend?

Correct Answer: Azure Synapse Analytics

You need to recommend the appropriate storage and processing solution? What should you recommend?

Correct Answer: Enable Apache Spark RDD (RDD) caching.

You need to recommend a solution that meets the data platform requirements of Health Interface. The solution must minimize redevelopment efforts for the application. What should you include in the recommendation?

Correct Answer: Azure Synapse Analytics

You need to design the solution for the government planning department. Which services should you include in the design?

Correct Answer: Azure SQL Database and Polybase

You are planning a design pattern based on the Lambda architecture as shown in the exhibit. Which Azure service should you use for the hot path?

Correct Answer: Azure Data Lake Storage Gen2

You need to recommend an Azure SQL Database pricing tier for Planning Assistance. Which pricing tier should you recommend?

Correct Answer: Business critical Azure SQL Database single database

Which consistency level should you use for Health Interface?

Correct Answer: Consistent Prefix

You are designing an audit strategy for an Azure SQL Database environment. You need to recommend a solution to provide real-time notifications for potential security breaches. The solution must minimize development effort. Which destination should you include in the recommendation?

Correct Answer: Azure Blob storage

You are developing an application that uses Azure Data Lake Storage Gen 2. You need to recommend a solution to grant permissions to a specific application for a limited time period. What should you include in the recommendation?

Correct Answer: shared access signatures (SAS)

A company is designing a solution that uses Azure Databricks. The solution must be resilient to regional Azure datacenter outages. You need to recommend the redundancy type for the solution. What should you recommend?

Correct Answer: Geo-redundant storage

You need to design a real-time stream solution that uses Azure Functions to process data uploaded to Azure Blob Storage. The solution must meet the following requirements: Support up to 1 million blobs. ✑ Scaling must occur automatically. ✑ Costs must be minimized. What should you recommend?

Correct Answer: Deploy the Azure Function in a Consumption plan and use a Blob trigger.

You need to recommend a security solution to grant anonymous users permission to access the blobs in a specific container only. What should you include in the recommendation?

Correct Answer: shared access signatures (SAS)

You have a line-of-business (LOB) app that reads files from and writes files to Azure Blob storage in an Azure Storage account. You need to recommend changes to the storage account to meet the following requirements: Provide the highest possible availability. Minimize potential data loss. Which three changes should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Correct Answer: From the app, add retry logic to the storage account interactions.

A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices. The company must be able to monitor the devices in real-time. You need to design the solution. What should you recommend?

Correct Answer: Azure Data Factory instance using Microsoft Visual Studio

You are designing a solution that will use Azure Databricks and Azure Data Lake Storage Gen2. From Databricks, you need to access Data Lake Storage directly by using a service principal. What should you include in the solution?

Correct Answer: access keys in Data Lake Storage

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Designing an Azure Data Solution

Design an Azure data solution for scalable analytics.

4.8★★★★★(204 ratings)

19,662 studentsIntermediate

Learn to architect Azure data platforms that support enterprise analytics, governance, and performance. The exam emphasizes solution design across ingestion, storage, processing, and consumption layers. This certification is useful for architects and senior data professionals. It helps you choose the right Azure services to meet business and technical requirements.

What you'll learn

Design data architectures- Plan ingestion and storage- Support analytics governance- Optimize performance- Align solutions with requirements

DP-201

Lectures2

Quizzes0

Duration30 week

Students19,662

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!