DP-201

DP-201 practice questions, page 3 of 9, with answer review and explanations.

Question 11

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.

  1. Use Azure Analysis Services to query the data. Output query results to Power BI.
  2. Configure an Azure Event Hub to capture data to Azure Data Lake Storage.
  3. 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.
  4. Develop an application that sends the IoT data to an Azure Event Hub.
  5. Develop an Azure Stream Analytics application that queries the data and outputs to Power BI. Use Azure Pipelines to deploy the Azure Stream Analytics application.
  6. Develop an application that sends the IoT data to an Azure Data Lake Storage container.

Question 12

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?

  1. Start the cluster after it is terminated.
  2. Pin the cluster
  3. Clone the cluster after it is terminated.
  4. Terminate the cluster manually at process completion.

Question 13

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?

  1. an Azure Cognitive Services application
  2. a Spark Streaming job
  3. interactive Spark queries
  4. Power BI models
  5. a Spark application that uses Spark MLib.

Question 14

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?

  1. SQL Server Migration Assistant
  2. SQL Data Sync
  3. Azure Data Factory
  4. Azure Database Migration Service
  5. Data Migration Assistant

Question 15

You manage an on-premises server named Server1 that has a database named Database1. The company purchases a new application that can access data from Azure SQL Database. You recommend a solution to migrate Database1 to an Azure SQL Database instance. What should you recommend? To answer, select the appropriate configuration in the answer area. NOTE: Each correct selection is worth one point. Hot Area: