Try our Free Demo Practice Tests for Comprehensive DP-203 Exam Preparation

You need to identify the extent of the data skew in Table1.

What should you do in Synapse Studio?

You need to configure workspace1 to support autoscaling all-purpose clusters. The solution must meet the following requirements:

✑ Automatically scale down workers when the cluster is underutilized for three minutes.

✑ Minimize the time it takes to scale to the maximum number of workers.

✑ Minimize costs.

What should you do first?

You need to grant Group1 read access to container1. The solution must use the principle of least privilege.

Which role should you assign to Group1?

You have the following function.

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.

The output data will contain items purchased, quantity, line total sales amount, and line total tax amount.

✑ Line total sales amount and line total tax amount will be aggregated in Databricks.

✑ Sales transactions will never be updated. Instead, new rows will be added to adjust a sale.

You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data.

What should you recommend?