Question 1

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 2

You have a Fabric tenant that contains a new semantic model in OneLake. You use a Fabric notebook to read the data into a Spark DataFrame. You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns. Solution: You use the following PySpark expression: df.show() Does this meet the goal?

Options :

A : Yes

B : No

Answer: B

Question 3

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual. What should you do?

Options :

A : Reference the columns in the Python code by index.

B : Modify the Sort Column By property for all columns.

C : Add a unique field to each row.

D : Modify the Summarize By property for all columns.

Answer: A

Question 4

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 5

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Options :

A : Update rows when the non-key attributes have changed.

B : Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.

C : Update the effective end date of rows when the non-key attribute values have changed.

D : Insert new records when the natural key is a new value in the table.

Answer: A,D

Free DP-600 Mock Exam – Practice Online Confidently

Buying Options: