DP-201

Question 1

Design Azure data storage solutions 
Testlet 1
Case study

You need to design the vehicle images storage solution.
What should you recommend?

Accepted Answer

B. Azure Premium Storage account

Answer

A. Azure Media Services

Answer

C. Azure Redis Cache

Answer

D. Azure Cosmos DB

Question 2

Design Azure data storage solutions ->Testlet 1->Case study
You need to design a sharding strategy for the Planning Assistance database. What should you recommend?

Accepted Answer

A.a list mapping shard map on the binary representation of the License Plate column

Answer

B.a range mapping shard map on the binary representation of the speed column

Answer

C. a list mapping shard map on the location column

Answer

D. a range mapping shard map on the time column

Question 3

Design Azure data storage solutions ->Testlet 1->Case study
You need to recommend an Azure SQL Database pricing tier for Planning Assistance. Which pricing tier should you recommend?

Accepted Answer

B. General purpose AzureSQL Database Managed Instance

Answer

A. Business critical AzureSQL Database single database

Answer

C. Business critical Azure SQL Database Managed Instance

Answer

D. General purpose Azure SQL Database single database

Question 4

Design Azure data storage solutions ->Testlet 2 -->Case study
You need to recommend a solution for storing the image tagging data.
What should you recommend?

Accepted Answer

C. Azure Blob Storage

Answer

A. Azure File Storage

Answer

B. Azure CosmosDB

Answer

D. Azure SQL Database

Answer

E. Azure Synapse Analytics

Question 5

Design Azure data storage solutions ->Testlet 2 -->Case study
You need to design the solution for analyzing customer data. What should you recommend?

Accepted Answer

A. Azure Databricks

Answer

B. Azure Data Lake Storage

Answer

C. Azure Synapse Analytics

Answer

D. Azure Cognitive Services

Answer

E. AzureBatch

Question 6

Design Azure data storage solutions ->Testlet 2 -->Case study
You need to recommend a solution for storing customer data.
What should you recommend?

Accepted Answer

C. Azure Databricks

Answer

A. Azure SQL Data Warehouse

Answer

B. Azure Stream Analytics

Answer

D. Azure SQL Database

Question 7

Design Azure data storage solutions Testlet 3
Case study
You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.
Which type of disk should you recommend?

Accepted Answer

C. Ultra SSD Managed Disk

Answer

A. Standard SSD Managed Disk

Answer

B. Premium SSD Managed Disk

Question 8

Design Azure data storage solutions Testlet 3
Case study
You need to recommend an Azure SQL Database service tier.
What should you recommend?

Accepted Answer

C. Premium

Answer

A. Business Critical

Answer

B. General Purpose

Answer

D. Standard

Answer

E. Basic

Question 9

Design Azure data storage solutions Testlet 3
Case study
You need to recommend the appropriate storage and processing solution? What should you recommend?

Accepted Answer

C. Enable Apache Spark RDD (RDD) caching.

Answer

A. Enable auto-shrink on the database.

Answer

B. Flush the blob cache using Windows PowerShell.

Answer

D. Enable Databricks IO (DBIO) caching.

Answer

E. ConfigurethereadingspeedusingAzureDataStudio.

Question 10

Design Azure data storage solutions Testlet 4
Case study
You need to design a solution that meets the business requirements of Health Insights. What should you include in the recommendation?

Accepted Answer

D. Azure Databricks

Answer

A. Azure CosmosDB that uses the Gremlin

Answer

B. Azure Data Factory

Answer

C. Azure Cosmos DB that uses the SQL API

Question 11

Design Azure data storage solutions Testlet 4
Case study
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?

Accepted Answer

C. Azure Cosmos DB that uses the SQL API

Answer

A. Azure Synapse Analytics

Answer

B. AzureSQL Database

Answer

D. Azure Cosmos DB that uses the Table API

Question 12

Design Azure data storage solutions Testlet 4
Case study
Which consistency level should you use for Health Interface?

Accepted Answer

D. Strong

Answer

A. Consistent Prefix

Answer

B. Session

Answer

C. Bounded Staleness

Question 13

Design Azure data storage solutions
Testlet 5
Overview
You need to design the storage for the visual monitoring system. Which storage solution should you recommend?

Accepted Answer

A. Azure Blob storage

Answer

B. Azure Table storage

Answer

C. Azure SQL database

Answer

D. Azure Media Services

Question 14

Design Azure data storage solutions
Testlet 5
Overview
You need to design the storage for the telemetry capture system. What storage solution should you use in the design?

Accepted Answer

C. Azure Cosmos DB

Answer

A. AzureSQL Synapse Analytics

Answer

B. AzureDatabricks

Question 15

Design Azure data storage solutions
Testlet 5
Overview
You need to design the solution for the government planning department.
  Which services should you include in the design?

Accepted Answer

C. Azure Synapse Analytics and Polybase

Answer

A. Azure Synapse Analytics and Elastic Queries

Answer

B. AzureSQL Database and Poly base

Answer

D. Azure SQL Database and Elastic Queries

Question 16

Design Azure data storage solutions Testlet 6
Case study
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?

Accepted Answer

A. Azure Data Lake Storage Gen2

Answer

B. Azure Cosmos DB

Answer

C. Azure SQL Database

Answer

D. Azure Synapse Analytics

Question 17

Design Azure data storage solutions Question Set 7
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 are designing an HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. The solution requires POSIX permissions and enables diagnostics logging for auditing.
You need to recommend solutions that optimize storage.
Proposed Solution: Ensure that files stored are larger than 250MB.
Does the solution meet the goal?

Answer

true

Question 18

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 are designing an HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. The solution requires POSIX permissions and enables diagnostics logging for auditing.
You need to recommend solutions that optimize storage.
Proposed Solution: Implement compaction jobs to combine small files into larger files.
Does the solution meet the goal?

Answer

true

Question 19

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 are designing an HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. The solution requires POSIX permissions and enables diagnostics logging for auditing.
You need to recommend solutions that optimize storage.
Proposed Solution: Ensure that files stored are smaller than 250MB.
Does the solution meet the goal?

Answer

true

Question 20

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 are designing an Azure SQL Database that will use elastic pools. You plan to store data about customers in a table. Each record uses a value for CustomerID.
You need to recommend a strategy to partition data based on values in CustomerID.
Proposed Solution: Separate data into customer regions by using vertical partitioning.
Does the solution meet the goal?

Answer

true

Question 21

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 are designing an Azure SQL Database that will use elastic pools. You plan to store data about customers in a table. Each record uses a value for CustomerID. You need to recommend a strategy to partition data based on values in CustomerID.
Proposed Solution: Separate data into customer regions by using horizontal partitioning.
Does the solution meet the goal?

Answer

true

Question 22

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 are designing an Azure SQL Database that will use elastic pools. You plan to store data about customers in a table. Each record uses a value for CustomerID. You need to recommend a strategy to partition data based on values in CustomerID.
Proposed Solution: Separate data into shards by using horizontal partitioning.
Does the solution meet the goal?

Answer

true

Question 23

You are evaluating data storage solutions to support a new application.
You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures. Which data storage solution should you recommend?

Accepted Answer

B. CosmosDB

Answer

A. BlobStorage

Answer

C. Data Lake Store

Answer

D. HDInsight

Question 24

You are designing a data processing solution that will implement the lambda architecture pattern. The solution will use Spark running on HDInsight for data processing.
You need to recommend a data storage technology for the solution.
Which two technologies should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Accepted Answer

A. Azure CosmosDB

Accepted Answer

E. KafkaHDInsight

Answer

B. Azure Service Bus

Answer

C. Azure Storage Queue

Answer

D. Apache Cassandra

Question 25

A company manufactures automobile parts. The company installs IoT sensors on manufacturing machinery. You must design a solution that analyzes data from the sensors.
You need to recommend a solution that meets the following requirements:
Data must be analyzed in real-time.
Data queries must be deployed using continuous integration. Data must be visualized by using charts and graphs.
Data must be available for ETL operations in the future.
The solution must support high-volume data ingestion.
Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Accepted Answer

B. Configure an Azure Event Hub to capture data to Azure Data Lake Storage.

Accepted Answer

C. Develop an Azure Stream Analytics application that queries the data and outputs to Power BI. Use Azure Data Factory to deploy the Azure Stream Analytics application.

Accepted Answer

D. Develop an application that sends the IoT data to an Azure Event Hub.

Answer

A. Use Azure Analysis Services to query the data. Out put query results to PowerBI.

Answer

E. Develop an Azure Stream Analytics application that queries the data and outputs to PowerBI. Use Azure Pipelines to deploy the Azure Stream Analytics application.

Answer

F. Develop an application that sends the IoT data to an Azure Data Lake Storage container.

Question 26

You are designing an Azure Databricks interactive cluster.
You need to ensure that the cluster meets the following requirements:
Enable auto-termination
Retain cluster configuration indefinitely after cluster termination.
What should you recommend?

Accepted Answer

B. Pin the cluster

Answer

A. Start the cluster after it is terminated.

Answer

C. Clone the cluster after it is terminated.

Answer

D. Terminate the cluster manually at process completion.

Question 27

You are designing a solution for a company. The solution will use model training for objective classification. You need to design the solution.
What should you recommend?

Accepted Answer

E. a Spark application that uses Spark MLib.

Answer

A. an Azure Cognitive Services application

Answer

B. a Spark Streaming job

Answer

C. interactive Spark queries

Answer

D. Power BI models

Question 28

A company stores data in multiple types of cloud-based databases.
You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day.
What should you recommend?

Accepted Answer

C. Azure Data Factory

Answer

A. SQL Server Migration Assistant

Answer

B. SQLDataSync

Answer

D. Azure Database Migration Service

Answer

E. DataMigrationAssistant

Question 29

You are designing an application. You plan to use Azure SQL Database to support the application.
The application will extract data from the Azure SQL Database and create text documents. The text documents will be placed into a cloud-based storage solution. The text storage solution must be accessible from an SMB network share.
You need to recommend a data storage solution for the text documents. Which Azure data storage type should you recommend?

Accepted Answer

B. Files

Answer

A. Queue

Answer

C. Blob

Answer

D. Table

Question 30

You are designing an application that will have an Azure virtual machine. The virtual machine will access an Azure SQL database. The database will not be accessible from the Internet
You need to recommend a solution to provide the required level of access to the database. What should you include in the recommendation?

Accepted Answer

B. Add a virtual network to the AzureSQL server that hosts the database.

Answer

A. Deploy an On-premises data gateway.

Answer

C. Add an application gateway to the virtual network that contains the Azure virtual machine.

Answer

D. Add a virtual network gateway to the virtual network that contains the Azure virtual machine.

Question 31

You are designing a data store that will store organizational information for a company. The data will be used to identify the relationships between users. The data will be stored in an Azure Cosmos DB database and will contain several million objects.
You need to recommend which API to use for the database. The API must minimize the complexity to query the user relationships. The solution must support fast traversals.
Which API should you recommend?

Accepted Answer

C. Gremlin

Answer

A. MongoDB

Answer

B. Table

Answer

D. Cassandra

Question 32

You need to recommend a storage solution to store flat files and columnar optimized files. The solution must meet the following requirements:
Store standardized data that data scientists will explore in a curated folder. Ensure that applications cannot access the curated folder.
Store staged data for import to applications in a raw folder.
Provide data scientists with access to specific folders in the raw folder and all the content the curated folder.
Which storage solution should you recommend?

Accepted Answer

B. Azure Blob storage

Answer

A. Azure Synapse Analytics

Answer

C. Azure Data Lake Storage Gen2

Answer

D. Azure SQL Database

Question 33

Your company is an online retailer that can have more than 100 million orders during a 24-hour period, 95 percent of which are placed between 16:30 and 17:00. All the orders are in US dollars. The current product line contains the following three item categories:
Games with 15,123 items Books with 35,312 items Pens with 6,234 items
You are designing an Azure Cosmos DB data solution for a collection named Orders Collection. The following documents is a typical order in Orders Collection.
Order Collection is expected to have a balanced read/write-intensive workload. Which partition key provides the most efficient throughput?

Accepted Answer

A. Item/Category

Answer

B. OrderTime

Answer

C. Item/Currency

Answer

D. Item/id

Question 34

You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses the MongoDB API. During testing, you discover that the migration takes longer than expected.
You need to recommend a solution that will reduce the amount of time it takes to migrate the data.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Accepted Answer

A. Increase the Request Units(RUs).

Accepted Answer

B. Turn off indexing.

Answer

C. Add a write region.

Answer

D. Create unique indexes.

Answer

E. Createcompoundindexes.

Question 35

You need to recommend a storage solution for a sales system that will receive thousands of small files per minute. The files will be in JSON, text, and CSV formats. The files will be processed and transformed before they are loaded into a data warehouse in Azure Synapse Analytics. The files must be stored and secured in folders.
  Which storage solution should you recommend?

Accepted Answer

A. Azure Data Lake Storage Gen2

Answer

B. Azure Cosmos DB

Answer

C. Azure SQL Database

Answer

D. Azure Blob storage

Question 36

You are designing an Azure Cosmos DB database that will support vertices and edges. Which Cosmos DB API should you include in the design?

Accepted Answer

C. Gremlin

Answer

A. SQL

Answer

B. Cassandra

Answer

D. Table

Question 37

You are designing a big data storage solution. The solution must meet the following requirements:
Provide unlimited account sizes.
Support a hierarchical file system.
Be optimized for parallel analytics workloads.
Which storage solution should you use?

Accepted Answer

A. Azure Data Lake Storage Gen2

Answer

B. Azure Blob storage

Answer

C. Apache HBase in Azure HDInsight

Answer

D. Azure Cosmos DB

Question 38

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 plan to store delimited text files in an Azure Data Lake Storage account that will be organized into department folders. You need to configure data access so that users see only the files in their respective department folder.
Solution: From the storage account, you enable a hierarchical namespace, and you use RBAC.
Does this meet the goal?

Answer

true

Question 39

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 plan to store delimited text files in an Azure Data Lake Storage account that will be organized into department folders. You need to configure data access so that users see only the files in their respective department folder.
Solution: From the storage account, you disable a hierarchical namespace, and you use RBAC.
Does this meet the goal?

Answer

true

Question 40

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 plan to store delimited text files in an Azure Data Lake Storage account that will be organized into department folders. You need to configure data access so that users see only the files in their respective department folder.
Solution: From the storage account, you disable a hierarchical namespace, and you use access control lists (ACLs).
Does this meet the goal?

Answer

true

Question 41

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?

Accepted Answer

D. Azure Blob storage

Answer

A. Azure CosmosDB

Answer

B. AzureSQL Database

Answer

C. Azure Synapse Analytics

Question 42

You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting.
Which storage solution should you use?

Accepted Answer

D. Azure SQL Database Hyperscale

Answer

A. AzureSQLDatabaseelasticpools

Answer

B. AzureSynapseAnalytics

Answer

C. Azure Cosmos DB that uses the Gremlin API

Question 43

Design data processing solutions Testlet 1
Case study
You need to design the runtime environment for the Real Time Response system. What should you recommend?

Accepted Answer

B. Memory Optimized Nodes without the Enterprise Security package

Answer

A. General Purpose nodes without the Enterprise Security package

Answer

C. Memory Optimized nodes with the Enterprise Security package

Answer

D. General Purpose nodes with the Enterprise Security package

Question 44

Design data processing solutions Testlet 2
Case study
Design data processing solutions Testlet 3
You need to optimize storage for CONT_SQL3. What should you recommend?

Accepted Answer

B. Transactional processing

Answer

A. Always On

Answer

C. General

Answer

D. Data warehousing

Question 45

Design data processing solutions Testlet 4
What should you recommend as a batch processing solution for Health Interface?

Accepted Answer

B. Azure Stream Analytics

Answer

A. Azure Cycle Cloud

Answer

C. Azure Data Factory

Answer

D. Azure Databricks

Question 46

Design data processing solutions
Testlet 5
Design data processing solutions Testlet 6
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.

Accepted Answer

A. Consume the output of the event hub by using Azure Stream Analytics and aggregate the data by store and product. Out put the resulting data directly to Azure
Synapse Analytics. Use Transact-SQL to calculate the inventory levels.

Accepted Answer

E. Output Event Hubs Avro files to Azure Blob storage. Trigger an Azure Data Factory copy activity to run every 10 minutes to load the data into Azure Synapse Analytics. Use Transact-SQL to aggregate the data by store and product.

Answer

B. Output Event Hubs Avro files to Azure Blob storage. Use Transact-SQL to calculate the inventory levels by using Poly Base in Azure Synapse Analytics.

Answer

C. Consume the output of the event hub by using Databricks. Use Databricks to calculate the inventory levels and output the data to Azure Synapse Analytics.

Answer

D. 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.

Question 47

You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading.
You need to design the staging tables.
What type of tables should you recommend?

Accepted Answer

A. Round-robindistributedtable

Answer

B. Hash-distributedtable

Answer

C. Replicated table

Answer

D. External table

Question 48

A company has an application that uses Azure SQL Database as the data store.
The application experiences a large increase in activity during the last month of each year.
You need to manually scale the Azure SQL Database instance to account for the increase in data write operations.
Which scaling method should you recommend?

Accepted Answer

C. Scale up by increasing the database throughput units.

Answer

A. Scale up by using elastic pools to distribute resources.

Answer

B. Scale out by sharding the data across databases.

Question 49

You are designing an Azure Data Factory pipeline for processing data. The pipeline will process data that is stored in general-purpose standard Azure storage. You need to ensure that the compute environment is created on-demand and removed when the process is completed.
Which type of activity should you recommend?

Accepted Answer

C. HDInsight Pig activity

Answer

A. DatabricksPythonactivity

Answer

B. DataLakeAnalyticsU-SQLactivity

Answer

D. Databricks Jar activity

Question 50

A company installs IoT devices to monitor its fleet of delivery vehicles. Data from devices is collected from Azure Event Hub. The data must be transmitted to Power BI for real-time data visualizations.
You need to recommend a solution.
What should you recommend?

Accepted Answer

C. Azure Stream Analytics

Answer

A. Azure HD Insight with Spark Streaming

Answer

B. Apache Spark in Azure Databricks

Answer

D. Azure HDInsight with Storm

Question 51

You have a Windows-based solution that analyzes scientific data. You are designing a cloud-based solution that performs real-time analysis of the data. You need to design the logical flow for the solution.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

C. Use an Azure Stream Analytics job in the cloud. Ingress data from the Azure Event Hub instance and build queries that output to Power BI.

Accepted Answer

F. Send data from the application to an Azure Event Hub instance.

Answer

A. Send data from the application to an Azure Stream Analytics job.

Answer

B. Use an Azure Stream Analytics job on an edge device. Ingress data from an Azure Data Factory instance and build queries that out put to PowerBI.

Answer

D. Use an Azure Stream Analytics job in the cloud. Ingress data from an Azure Event Hub instance and build queries that output to Azure Data Lake Storage.

Answer

E. Send data from the application to Azure Data Lake Storage.

Question 52

You are designing a real-time stream solution based on Azure Functions. The solution will process data uploaded to Azure Blob Storage. The solution requirements are as follows:
New blobs must be processed with a little delay as possible. Scaling must occur automatically.
Costs must be minimized.
What should you recommend?

Accepted Answer

C. Deploy the Azure Function in a Consumption plan and use a Blob trigger.

Answer

A. Deploy the Azure Function in an App Service plan and use a Blob trigger.

Answer

B. Deploy the Azure Function in a Consumption plan and use an Event Grid trigger

Answer

D. Deploy the Azure Function in an App Service plan and use an Event Grid trigger.

Question 53

You plan to migrate data to Azure SQL Database.
The database must remain synchronized with updates to Microsoft Azure and SQL Server. You need to set up the database as a subscriber.
What should you recommend?

Accepted Answer

E. SQLServerManagementStudio17.9.1orlater

Answer

A. Azure Data Factory

Answer

B. SQL Server Data T ools

Answer

C. Data Migration Assistant

Answer

D. SQL Server Agent for SQL Server 2017 or later

Question 54

You design data engineering solutions for a company.
A project requires analytics and visualization of large set of data. The project has the following requirements:
Notebook scheduling Cluster automation Power BI Visualization
You need to recommend the appropriate Azure service. Which Azure service should you recommend?

Accepted Answer

D. Azure Databricks

Answer

A. Azure Batch

Answer

B. Azure Stream Analytics

Answer

C. Azure ML Studio

Answer

E. AzureHDInsight

Question 55

A company plans to use Apache Spark Analytics to analyze intrusion detection data.
You need to recommend a solution to monitor network and system activities for malicious activities and policy violations. Reports must be produced in an electronic format and sent to management. The solution must minimize administrative efforts. What should you recommend?

Accepted Answer

D. Azure HDInsight

Answer

A. Azure Data Factory

Answer

B. Azure Data Lake

Answer

C. Azure Databricks

Question 56

You are designing an Azure Databricks interactive cluster.
You need to ensure that the cluster meets the following requirements:
Enable auto-termination
Retain cluster configuration indefinitely after cluster termination.
What should you recommend?

Accepted Answer

D. Pin the cluster.

Answer

A. Clone the cluster after it is terminated.

Answer

B. Terminate the cluster manually when processing completes.

Answer

C. Create an Azure runbook that starts the cluster every 90 days.

Question 57

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.

Accepted Answer

A. Azure Databricks

Accepted Answer

C. Azure Event Hubs

Answer

B. Azure Data Factory

Answer

D. Azure Data Lake Storage Gen2

Answer

E. Azure IoT Hub

Question 58

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?

Accepted Answer

A. Azure Databricks

Answer

B. AzureSQL Database

Answer

C. Azure Data Factory

Answer

D. Azure Database for PostgreSQL

Question 59

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?

Accepted Answer

D. Azure Log Analytics

Answer

A. Azure Blob storage

Answer

B. Azure Synapse Analytics

Answer

C. Azure Event Hubs

Question 60

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?

Accepted Answer

C. Deploy the Azure Function in a Consumption plan and use a Blob trigger.

Answer

A. Deploy the Azure Function in an App Service plan and use a Blob trigger.

Answer

B. Deploy the Azure Function in a Consumption plan and use an Event Grid trigger.

Answer

D. Deploy the Azure Function in an App Service plan and use an Event Grid trigger.

Question 61

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?

Accepted Answer

C. Azure Stream Analytics cloud job using Azure PowerShell

Answer

A. Azure Data Factory instance using Azure PowerShell

Answer

B. Azure Analysis Services using Microsoft Visual Studio

Answer

D. Azure Data Factory instance using Microsoft Visual Studio

Question 62

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?

Accepted Answer

C. Azure Stream Analytics Edge application using Microsoft Visual Studio

Answer

A. Azure Data Factory instance using Azure PowerShell

Answer

B. Azure Analysis Services using Microsoft Visual Studio

Answer

D. Azure Analysis Services using Azure PowerShell

Question 63

You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Databricks and PolyBase in Azure Synapse Analytics.
You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the files can be queried quickly and that the data type information is retained.
What should you recommend?

Accepted Answer

A. Avro

Answer

B. CSV

Answer

C. Parquet

Answer

D. JSON

Question 64

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?

Answer

true

DP-201

Crie uma conta grátis para terminar este quiz

Perguntas do quiz (84)

Informações

Fale Conosco

O que você acha do novo visual?