Free Microsoft DP-203 Exam Dumps Questions & Answers

You have an Azure Blob storage account named storage! and an Azure Synapse Analytics serverless SQL pool named Pool! From Pool1., you plan to run ad-hoc queries that target storage!
You need to ensure that you can use shared access signature (SAS) authorization without defining a data source. What should you create first?

• A.  a stored access policy
• B.  a server-level credential
• C.  a database scoped credential
• D.  a managed identity

You have an Azure Synapse Analytics dedicated SQL pod.
You need to create a pipeline that will execute a stored procedure in the dedicated SQL pool and use the returned result set as the input (or a downstream activity. The solution must minimize development effort.
Which Type of activity should you use in the pipeline?

• A.  Script
• B.  Stored Procedure
• C.  U-SQL
• D.  Notebook

You have an Azure Factory instance named DF1 that contains a pipeline named PL1.PL1 includes a tumbling window trigger.
You create five clones of PL1. You configure each clone pipeline to use a different data source.
You need to ensure that the execution schedules of the clone pipeline match the execution schedule of PL1.
What should you do?

• A.  Create a tumbling window trigger dependency for the trigger of PL1.
• B.  Add a new trigger to each cloned pipeline
• C.  Modify the Concurrency setting of each pipeline.
• D.  Associate each cloned pipeline to an existing trigger.

You have an Azure subscription that contains an Azure Synapse Analytics workspace named ws1 and an Azure Cosmos D6 database account named Cosmos1 Costmos1 contains a container named container 1 and ws1 contains a serverless1 SQL pool.
you need to ensure that you can Query the data in container by using the serverless1 SQL pool.
Which three actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

• A.  In ws1. create a linked service that references Cosmos1
• B.  Enable Azure Synapse Link for Cosmos1
• C.  Enable the analytical store for container1
• D.  Disable the analytical store for container1.
• E.  Disable indexing for container1

A company uses Azure Stream Analytics to monitor devices.
The company plans to double the number of devices that are monitored.
You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load.
Which metric should you monitor?

• A.  Watermark delay
• B.  Input Deserialization Errors
• C.  Early Input Events
• D.  Late Input Events