Question 1

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 2

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements: Replace Table1 with the schema of the external data. Replace all the data in Table1 with the rows in the external data. You add a Copy data activity to the pipeline. What should you do for the Copy data activity?

Options :

A : From the Source tab, add additional columns.

B : From the Destination tab, set Table action to Overwrite.

C : From the Settings tab, select Enable staging

D : From the Source tab, select Enable partition discovery

E : From the Source tab, select Recursively

Answer: B

Question 3

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 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 have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.

What can you identify about the pickupLongitude column?

Options :

A : The column has duplicate values.

B : All the table rows are profiled.

C : The column has missing values.

D : There are 935 values that occur only once.

Answer: A

Confidently Practice Online with Free DP-600 Exam Cram

Buying Options: