DP-200

HOTSPOT A company is deploying a service-based data environment. You are developing a solution to process this data. The solution must meet the following requirements: ✑ Use an Azure HDInsight cluster for data ingestion from a relational database in a different cloud service ✑ Use an Azure Data Lake Storage...

You develop data engineering solutions for a company. You need to ingest and visualize real-time Twitter data by using Microsoft Azure. Which three technologies should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Event Grid topicB . Azure Stream...

You have a SQL pool in Azure Synapse. You discover that some queries fail or take a long time to complete. You need to monitor for transactions that have rolled back. Which dynamic management view should you query?A . sys.dm_pdw_nodes_tran_database_transactionsB . sys.dm_pdw_waitsC . sys.dm_pdw_request_stepsD . sys.dm_pdw_exec_sessionsView AnswerAnswer: A Explanation: You...

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 questions sets might have more than one correct solution, while others might not have a correct solution. After you...

HOTSPOT You are processing streaming data from vehicles that pass through a toll booth. You need to use Azure Stream Analytics to return the license plate, vehicle make, and hour the last vehicle passed during each 10-minute window. How should you complete the query? To answer, select the appropriate options...

You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the reference data?A . Azure Cosmos DBB . Azure Event HubsC . Azure Blob storageD . Azure IoT HubView AnswerAnswer: C...

HOTSPOT You are building the data store solution for Mechanical Workflow. How should you configure Table1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Table Type: Hash distributed. Hash-distributed tables improve query performance on large fact tables....

Topic 2, Contoso Ltd Overview Current environment Contoso relies on an extensive partner network for marketing, sales, and distribution. Contoso uses external companies that manufacture everything from the actual pharmaceutical to the packaging. The majority of the company’s data reside in Microsoft SQL Server database. Application databases fall into one...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: A Explanation: We use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: A Explanation: We use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column...