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?

• 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.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a Microsoft Power Bl report.
You are exploring a new semantic model.
You need to display the following column statistics:
* Count
* Average
* Null count
* Distinct count
* Standard deviation
Which Power Query function should you run?

• A.Table. FuzzyGroup
• B.Table.Profile
• C.Table.View
• D.Table.Schema

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a lakehouse.
You plan to query sales data files by using the SQL endpoint. The files will be in an Amazon Simple Storage Service (Amazon S3) storage bucket.
You need to recommend which file format to use and where to create a shortcut.
Which two actions should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

• A.Create a shortcut in the Tables section.
• B.Use the delta format.
• C.Use the Parquet format
• D.Create a shortcut in the Files section.
• E.Use the CSV format.

Comment: *

Name: *

Email: *

Verification: *

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.explain()
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.
You need to use slowly changing dimension (SCO) to manage the versioning of data. The solution must meet the requirements shown in the following table.

Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

For the Customers table, where the requirement is to create a new version of the row, you would use:
* Type 2 SCD: This type allows for the creation of a new record each time a change occurs, preserving the history of changes over time.
For the Products table, where the requirement is to overwrite the existing value in the latest row, you would use:
* Type 1 SCD: This type updates the record directly, without preserving historical data.

Comment: *

Name: *

Email: *

Verification: *