DP-201 practice test

1. Question 1 · 1

   You plan to store 100 GB of data used by a line-of-business (LOB) app. You need to recommend a data storage solution for the data. The solution must meet the following requirements: ✑ Minimize storage costs. ✑ Natively support relational queries. ✑ Provide a recovery time objective (RTO) of less than one minute. What should you include in the recommendation?

   Choose one answer.

   • Azure Cosmos DB
   • Azure SQL Database
   • Azure Synapse Analytics
   • Azure Blob storage

   Read explanation

   Incorrect Answers: A: Azure Cosmos DB would require an SQL API.

2. Question 2 · 18

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

   Choose one answer.

   • Use AzCopy and store the data in Azure.
   • Configure Azure SQL Database long-term retention for all databases.
   • Configure Accelerated Database Recovery.
   • Use DWLoader.

   Read explanation

   Scenario: The database backups have regulatory purposes and must be retained for seven years.

3. Question 3 · 2

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have streaming data that is received by Azure Event Hubs and stored in Azure Blob storage. The data contains social media posts that relate to a keyword of Contoso. You need to count how many times the Contoso keyword and a keyword of Litware appear in the same post every 30 seconds. The data must be available to Microsoft Power BI in near real-time. Solution: You use Azure Data Factory and an event trigger to detect when new blobs are created. You use mapping data flows in Azure Data Factory to aggregate and filter the data, and then send the data to an Azure SQL database. You consume the data in Power BI by using DirectQuery mode. Does the solution meet the goal?

   Choose one answer.

   • Yes
   • No

4. Question 4 · 2

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have streaming data that is received by Azure Event Hubs and stored in Azure Blob storage. The data contains social media posts that relate to a keyword of Contoso. You need to count how many times the Contoso keyword and a keyword of Litware appear in the same post every 30 seconds. The data must be available to Microsoft Power BI in near real-time. Solution: You use Azure Databricks to create a Scala notebook. You use a Structured Streaming job to connect to the event hub that counts the posts that have the specified keywords, and then writes the data to a Delta table. You consume the data in Power BI by using DirectQuery mode. Does the solution meet the goal?

   Choose one answer.

   • Yes
   • No

5. Question 5 · 2

   HOTSPOT - You design data engineering solutions for a company. You must integrate on-premises SQL Server data into an Azure solution that performs Extract-Transform-Load (ETL) operations have the following requirements: ✑ Develop a pipeline that can integrate data and run notebooks. ✑ Develop notebooks to transform the data. ✑ Load the data into a massively parallel processing database for later analysis. You need to recommend a solution. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   Choose an option for each prompt.

   

   Integrate the on-premises data into the cloud.

   • • Azure Databricks
   • • Azure Data Factory
   • • Azure Synapse Analytics
   • • Azure Batch

   Develop notebooks to transform the data.

   • • Azure Databricks
   • • Azure Data Factory
   • • Azure Synapse Analytics
   • • Azure Batch

   Run notebooks.

   • • Azure Databricks
   • • Azure Data Factory
   • • Azure Synapse Analytics
   • • Azure Batch

   Load the data.

   • • Azure Databricks
   • • Azure Data Factory
   • • Azure Synapse Analytics
   • • Azure Batch

   Store the transformed data.

   • • Azure Databricks
   • • Azure Data Factory
   • • Azure Synapse Analytics
   • • Azure Batch

6. Question 6 · 20

   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?

   Choose one answer.

   • Azure Synapse Analytics
   • Azure SQL Database
   • Azure Cosmos DB that uses the SQL API
   • Azure Cosmos DB that uses the Table API

   Read explanation

   Scenario: ADatum identifies the following requirements for the Health Interface application: ✑ Reduce the amount of development effort to rewrite existing SQL queries. ✑ Upgrade to a data storage solution that will provide flexible schemas and increased throughput for writing data. Data must be regionally located close to each hospital, and reads must display be the most recent committed version of an item. ✑ Reduce the amount of time it takes to add data from new hospitals to Health Interface. ✑ Support a more scalable batch processing solution in Azure.

7. Question 7 · 22

   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?

   Choose one answer.

   • Azure Data Lake Storage Gen2
   • Azure Cosmos DB
   • Azure Stream Analytics
   • Azure Synapse Analytics

   Read explanation

   There are several differences between a data lake and a data warehouse. Data structure, ideal users, processing methods, and the overall purpose of the data are the key differentiators. Scenario: Litware employs business analysts who prefer to analyze data by using Microsoft Power BI, and data scientists who prefer analyzing data in Azure Databricks notebooks. Note: Azure Synapse Analytics formerly known as Azure SQL Data Warehouse. Design Azure data storage solutions

8. Question 8 · 23

   DRAG DROP - You need to design the image processing solution to meet the optimization requirements for image tag data. What should you configure? To answer, drag the appropriate setting to the correct drop targets. Each source may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:

   Match each destination with an option.

   

   New York

   • • Write region
   • • Read region

   Manchester

   • • Write region
   • • Read region

   Singapore

   • • Write region
   • • Read region

   Melbourne

   • • Write region
   • • Read region

   Read explanation

   Tagging data must be uploaded to the cloud from the New York office location. Tagging data must be replicated to regions that are geographically close to company office locations.

9. Question 9 · 3

   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?

   Choose one answer.

   • Azure Synapse Analytics
   • Azure HDInsight with Spark
   • Azure Analysis Services
   • Azure Databricks

   Read explanation

   Azure Databricks is an Apache Spark-based analytics platform. Azure Databricks supports autoscaling and manages the Spark cluster for you. Incorrect Answers: A, B:

10. Question 10 · 5

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

    Choose one answer.

    • Business critical Azure SQL Database single database
    • General purpose Azure SQL Database Managed Instance
    • Business critical Azure SQL Database Managed Instance
    • General purpose Azure SQL Database single database

    Read explanation

    Azure resource costs must be minimized where possible. Data used for Planning Assistance must be stored in a sharded Azure SQL Database. The SLA for Planning Assistance is 70 percent, and multiday outages are permitted.

11. Question 11 · 5

    HOTSPOT - You need to design the Planning Assistance database. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:

    Choose an option for each prompt.

    

    Including a clustered columnstore index in the design will benefit performance.

    • • Yes
    • • No

    Including a nonclustered columnstore index in the design will benefit performance.

    • • Yes
    • • No

    Including an index on the License Plate column will benefit performance.

    • • Yes
    • • No

    Read explanation

    Box 1: No - Data used for Planning Assistance must be stored in a sharded Azure SQL Database. Box 2: Yes - Box 3: Yes - Planning Assistance database will include reports tracking the travel of a single vehicle Design Azure data storage solutions

12. Question 12 · 7

    HOTSPOT - Which Azure Data Factory components should you recommend using together to import the customer data from Salesforce to Data Lake Storage? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

    Choose an option for each prompt.

    

    Integration runtime type:

    • • Azure integration runtime
    • • Azure-SSIS integration runtime
    • • Self-hosted integration runtime

    Trigger type:

    • • Event-based trigger
    • • Schedule trigger
    • • Tumbling window trigger

    Activity type:

    • • Copy activity
    • • Lookup activity
    • • Stored procedure activity

    Read explanation

    Box 1: Self-hosted integration runtime A self-hosted IR is capable of nunning copy activity between a cloud data stores and a data store in private network. Box 2: Schedule trigger - Schedule every 8 hours - Box 3: Copy activity - Scenario: ✑ Customer data, including name, contact information, and loyalty number, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table. ✑ Product data, including product ID, name, and category, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table.

13. Question 13 · 7

    HOTSPOT - Which Azure Data Factory components should you recommend using together to import the daily inventory data from SQL to Azure Data Lake Storage? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

    Choose an option for each prompt.

    

    Integration runtime type:

    • • Azure integration runtime
    • • Azure-SSIS integration runtime
    • • Self-hosted integration runtime

    Trigger type:

    • • Event-based trigger
    • • Schedule trigger
    • • Tumbling window trigger

    Activity type:

    • • Copy activity
    • • Lookup activity
    • • Stored procedure activity

    Read explanation

    Box 1: Self-hosted integration runtime A self-hosted IR is capable of nunning copy activity between a cloud data stores and a data store in private network. Scenario: Daily inventory data comes from a Microsoft SQL server located on a private network. Box 2: Schedule trigger - Daily schedule - Box 3: Copy activity - Scenario: Stage inventory data in Azure Data Lake Storage Gen2 before loading the data into the analytical data store. Litware wants to remove transient data from Data Lake Storage once the data is no longer in use. Files that have a modified date that is older than 14 days must be removed.

14. Question 14 · 8

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

    Choose one answer.

    • General Purpose nodes without the Enterprise Security package
    • Memory Optimized Nodes without the Enterprise Security package
    • Memory Optimized nodes with the Enterprise Security package
    • General Purpose nodes with the Enterprise Security package

    Read explanation

    Scenario: You must maximize the performance of the Real Time Response system.

Paid access to all 14 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.