Question 1

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

Options :

A :

an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse

B :

an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse

C :

an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse

D :

an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the destination lakehouse

Answer: C

Question 2

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?

Options :

A : Table. MaxN

B : Table.Max

C : Table.Range

D : Table.Profile

Answer: B

Question 3

You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?Script

Options :

A : Script

B : Copy data

C : Switch

D : Append variable

Answer: A

Question 4

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements: Ensure that the developers can deploy items to the workspaces for Development and Test. Prevent the developers from deploying items to the workspace for Production. Follow the principle of least privilege. Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Options :

A : Build permission to the production semantic models

B : Admin access to the deployment pipeline

C : Viewer access to the Development and Test workspaces

D : Viewer access to the Production workspace

E : Contributor access to the Development and Test workspaces

F : Contributor access to the Production workspace

Answer: B,D,E

Question 5

You have a Fabric tenant that contains a warehouse. Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring?

Options :

A : the Capacity settings

B : the Monitoring hub

C : dynamic management views (DMVs)

D : the Microsoft Fabric Capacity Metrics app

Answer: D

Smartly Prepare Exam with Free Online DP-600 Practice Test

Buying Options: