You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 receives new data once every 24 hours. You have the following function. You have the following query. The query is executed once every 15 minutes and the @parameter value is set to the current date. You need to minimize the time it takes for the query to return results. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Convert the avg_c column into a calculated column.

Create an index on the avg_f column.

Convert the avg_c column into a calculated column.

Create an index on the sensorid column.

Change the table distribution to replicate.

You have an Azure Data Factory pipeline named pipeline1 that is invoked by a tumbling window trigger named Trigger1. Trigger1 has a recurrence of 60 minutes. You need to ensure that pipeline1 will execute only if the previous execution completes successfully. How should you configure the self-dependency for Trigger1?

offset: "-01:00:00" size: "01:00:00"

offset: "-00:01:00" size: "00:01:00"

offset: "01:00:00" size: "-01:00:00"

offset: "01:00:00" size: "01:00:00"

offset: "-01:00:00" size: "01:00:00"

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1. SQLPool1 is currently paused.You need to restore the current state of SQLPool1 to a new SQL pool. What should you do first?

Create a user-defined restore point.

You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the following exhibit. How is the data for the lineage populated?

by executing a Data Factory pipeline

You have an Azure data factory that connects to a Microsoft Purview account. The data factory is registered in Microsoft Purview. You update a Data Factory pipeline.You need to ensure that the updated lineage is available in Microsoft Purview. What should you do first?

Locate the related asset in the Microsoft Purview portal.

Disconnect the Microsoft Purview account from the data factory.

Execute an Azure DevOps build pipeline.

You have the Azure Synapse Analytics pipeline shown in the following exhibit. You need to add a set variable activity to the pipeline to ensure that after the pipeline’s completion, the status of the pipeline is always successful.What should you configure for the set variable activity?

a failure dependency on the Upon Failure activity

a success dependency on the Business Activity That Fails activity

a failure dependency on the Upon Failure activity

a skipped dependency on the Upon Success activity

a skipped dependency on the Upon Failure activity

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.

Enable Azure Synapse Link for Cosmos1

In ws1. create a linked service that references Cosmos1

Enable the analytical store for container1

Enable Azure Synapse Link for Cosmos1

Disable the analytical store for container1.

In ws1. create a linked service that references Cosmos1

Enable the analytical store for container1

Disable indexing for container1

Microsoft DP-203 Practice Test 7 - Free Online Exam Prep & Questions

HOTSPOT

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool. You plan to deploy a solution that will analyze sales data and include the following:

• A table named Country that will contain 195 rows

• A table named Sales that will contain 100 million rows

• A query to identify total sales by country and customer from the past 30 days You need to create the tables. The solution must maximize query performance. How should you complete the script? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-203 Practice Test 7

Question

Microsoft DP-203 Practice Tests

Practice Tests