DP-200

You need to ensure that phone-based poling data can be analyzed in the PollingData database. How should you configure Azure Data Factory?A . Use a tumbling schedule triggerB . Use an event-based triggerC . Use a schedule triggerD . Use manual executionView AnswerAnswer: C Explanation: When creating a schedule trigger,...

You need to process and query ingested Tier 9 data. Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Azure Notification HubB . Transact-SQL statementsC . Azure Cache for RedisD . Apache Kafka statementsE . Azure...

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

Topic 5, Misc Questions You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account. You need to output the count of tweets during the last five minutes every five minutes. Each tweet must only be counted...

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

You develop data engineering solutions for a company. A project requires the deployment of data to Azure Data Lake Storage. You need to implement role-based access control (RBAC) so that project members can manage the Azure Data Lake Storage resources. Which three actions should you perform? Each correct answer presents...

DRAG DROP You need to set up access to Azure SQL Database for Tier 7 and Tier 8 partners. Which three actions should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order....

Which windowing function should you use to perform the streaming aggregation of the sales data?A . TumblingB . HoppingC . SlidingD . SessionView AnswerAnswer: A Explanation: Scenario: The analytic process will perform aggregations that must be done continuously, without gaps, and without overlapping. The key differentiators of a Tumbling window...

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

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You plan to query db3 to retrieve a list of sales customers. The query will retrieve several columns that include the email address...