Exactprep DP-600 Questions

To meet the technical requirement that data loading activities must ensure the raw and cleansed data is updated completely before populating the dimensional model, you would need a mechanism that allows for ordered execution. A pipeline in Microsoft Fabric with dependencies set between activities can ensure that activities are executed in a specific sequence. Once set up, the pipeline can be scheduled to run at the required intervals (hourly or daily depending on the data source).

Requirements:

Parallel processing → PySpark runs distributed across Spark clusters.

Minimize duplication of data → OneLake shortcut + Spark queries avoid unnecessary copies.

Time series analysis, anomaly detection, visualization → can be done in PySpark within Fabric Notebooks.

pandas (C) is single-threaded and not efficient for billions of items.

Power BI visuals (A) are good for visualization but not for transformation or large-scale anomaly detection.

Correct: B.

When you need to return all rows that are present in both tables, you use a full outer join. This type of join combines the results of both left and right outer joins and returns all rows from both tables, with matching rows from both sides where available. If there is no match, the result is NULL on the side of the join where there is no match.

The transformation you should select from the context menu of the VendorID column to transform the date columns into attribute-value pairs, where columns become rows, is Unpivot columns (B). This transformation will turn the selected columns into rows with two new columns, one for the attribute (the original column names) and one for the value (the data from the cells). References = Techniques for unpivoting columns are covered in the Power Query documentation, which explains how to use the transformation in data modeling.