Question 1

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 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 semantic model. You need to prevent report creators from populating visuals by using implicit measures. What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

Options :

A : Microsoft Power BI Desktop

B : Tabular Editor

C : Microsoft SQL Server Management Studio (SSMS)

D : DAX Studio

Answer: A,B

Question 4

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

Question 5

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

Confidently Practice Online with Free DP-600 Exam Cram

Buying Options: