Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Microsoft DP-201

Microsoft DP-201 Exam Practice Questions (P. 3)

  • Full Access (208 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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. A
    Use Azure Analysis Services to query the data. Output query results to Power BI.
  2. B
    Configure an Azure Event Hub to capture data to Azure Data Lake Storage.
  3. 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.
  4. D
    Develop an application that sends the IoT data to an Azure Event Hub.
  5. E
    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. F
    Develop an application that sends the IoT data to an Azure Data Lake Storage container.

Correct Answer:
BCD

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. A
    Start the cluster after it is terminated.
  2. B
    Pin the cluster
  3. C
    Clone the cluster after it is terminated.
  4. D
    Terminate the cluster manually at process completion.

Correct Answer:
B
To keep an interactive cluster configuration even after it has been terminated for more than 30 days, an administrator can pin a cluster to the cluster list.
Reference:
https://docs.azuredatabricks.net/user-guide/clusters/terminate.html

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. A
    an Azure Cognitive Services application
  2. B
    a Spark Streaming job
  3. C
    interactive Spark queries
  4. D
    Power BI models
  5. E
    a Spark application that uses Spark MLib.

Correct Answer:
E
Spark in SQL Server big data cluster enables AI and machine learning.
You can use Apache Spark MLlib to create a machine learning application to do simple predictive analysis on an open dataset.
MLlib is a core Spark library that provides many utilities useful for machine learning tasks, including utilities that are suitable for:
✑ Classification
✑ Regression
✑ Clustering
✑ Topic modeling
✑ Singular value decomposition (SVD) and principal component analysis (PCA)
✑ Hypothesis testing and calculating sample statistics
Reference:
https://docs.microsoft.com/en-us/azure/hdinsight/spark/apache-spark-machine-learning-mllib-ipython

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. A
    SQL Server Migration Assistant
  2. B
    SQL Data Sync
  3. C
    Azure Data Factory
  4. D
    Azure Database Migration Service
  5. E
    Data Migration Assistant

Correct Answer:
C
Incorrect Answers:
D: Azure Database Migration Service is used to migrate on-premises SQL Server databases to the cloud.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/introduction https://azure.microsoft.com/en-us/blog/operationalize-azure-databricks-notebooks-using-data-factory/ https://azure.microsoft.com/en-us/blog/data-ingestion-into-azure-at-scale-made-easier-with-latest-enhancements-to-adf-copy-data-tool/

Question #15
HOTSPOT -
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:


Correct Answer:

 References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-import

Previous Questions Next Questions

All Pages