Free Microsoft DP-200 Exam Dumps Questions & Answers

You have a data warehouse in Azure Synapse Analytics.
You need to ensure c rest.
What should you enable?

• A.Secure transfer required
• B.Always Encrypted for all columns
• C.Transparent Data Encryption (TDE)
• D.Advanced Data Security for this database

A company has a real-lime data analysis solution that is hosted on Microsoft Azure the solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job to analyze the dat a. The cloud job is configured to use 120 Streaming Units (SU).
You need to optimize performance for the Azure Stream Analytics job.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one port.

• A.Implement query parallelization by partitioning the data output
• B.Scale the SU count for the job up
• C.Scale the SU count for the job down
• D.Implement Azure Stream Analytics user-defined functions (UDF)
• E.Implement event ordering
• F.Implement query parallelization by partitioning the data input

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 once.
Which windowing function should you use?

• A.a five-minute Sliding window
• B.a five-minute Session window
• C.a five-minute Hopping window that has one-minute hop
• D.a five-minute Tumbling window

Your company uses Microsoft Azure SQL Database configure with Elastic pool. You use Elastic Database jobs to run queries across all databases in the pod.
You need to analyze, troubleshoot, and report on components responsible for running Elastic Database jobs.
You need to determine the component responsible for running job service tasks.
Which components should you use for each Elastic pool job services task? To answer, drag the appropriate component to the correct task. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview

You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. Df1 contains a linked service.
You have an Azure Key vault named vault1 that contains an encryption key named key1.
You need to encrypt df1 by using key1.
What should you do first?

• A.Create a self-hosted integration runtime.
• B.Disable soft delete on vault1.
• C.Disable purge protection on vault1.
• D.Remove the linked service from df1.