Free Practice Microsoft DP-600 Exam Questions 2025

What method involves transforming data from a wide format to a long format, or vice versa, in a warehouse or lakehouse environment?

When optimizing data storage in a warehouse, which technique involves storing data redundantly across multiple servers or nodes?

You are analyzing customer purchases in a Fabric notebook by using PySpark.

You have the following DataFrames:

transactions: Contains five columns named transaction_id, customer_id, product_id, amount, and date and has 10 million rows, with each row representing a transaction. customers: Contains customer details in 1,000 rows and three columns named customer_id, name, and country.

You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling.

You write the following code.

from pyspark.sql import functions as F

results =

Which code should you run to populate the results DataFrame?

When designing semantic models, what role does cardinality play in defining relationships between tables or entities?

You have a Fabric tenant.

You plan to create a data pipeline named Pipeline1. Pipeline1 will include two activities that will execute in sequence.

You need to ensure that a failure of the first activity will NOT block the second activity.

Which conditional path should you configure between the first activity and the second activity?