Transform data
23 practice questions under this official exam objective (DP-600) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Which Fabric Data Store Supports Dataflows and Automatic V-Order?
Choosing the right Fabric data store for dataflow ingestion plus automatic Delta optimization is the core of this DP-600 item, where a local folder mu
How to Convert CSV to Delta with V-Order in Fabric Lakehouse?
In Microsoft Fabric, the Load to Tables feature from Lakehouse explorer converts CSV files in a subfolder into Delta tables with V-Order optimization
Fabric Data Store for Semi-Structured Data
This page establishes the correct data store type for the AnalyticsPOC workspace in Microsoft Fabric based on technical requirements like T-SQL/Python
Execute Stored Procedure and Return Values in Fabric Pipeline
The Lookup activity in a Fabric Data Factory pipeline executes a stored procedure and makes its returned values available to downstream activities. Th
Type 1 SCD Data Loading Pattern
A Type 1 slowly changing dimension (SCD) overwrites existing data without preserving history. This guide confirms that updating changed rows and inser
How to Implement a Date Dimension in a Fabric Lakehouse?
In Microsoft Fabric, a date dimension can be implemented either by populating a table with a dataflow or by creating a T-SQL view in a lakehouse. This
Power Query Data View Options for Column Information
This guide identifies the three Data view options in Power Query required to display column value distribution, column profile, and column quality det
Fabric Copy Data Activity Table Action Overwrite
When copying external data to a Fabric lakehouse table with a regularly changing schema, setting the Copy data activity's Table action to Overwrite re
Which Fabric pipeline activity supports Power Query M for copying CSV data?
A Fabric pipeline in Workspace1 must copy CSV files from Azure Storage into Lakehouse1 while supporting Power Query M formula expressions. The answer
How to Identify Min and Max Values in Dataflow Data View
Identifying the minimum and maximum values for columns in a Fabric dataflow requires enabling specific data view options. This page confirms the corre
Using Data Wrangler Corrupt Image Impulse Noise to Make a Fraud Camera Model Robust to Image Quality Variation
A model detects automobile accidents from closed-circuit TV footage and performs well in training and validation but degrades in production because im
Evaluate PySpark DataFrame Statistics with df.show()
This page clarifies why the PySpark expression df.show() fails to calculate statistical summaries like min, max, mean, and standard deviation for a Sp
Processing Mixed CSV JSON XLSX Parquet Files in One S3 Folder with DataBrew and Outputting Apache Parquet
An S3 bucket holds 1 TB of files from different sources with CSV, JSON, XLSX, and Apache Parquet all mixed in the same folder. The engineer must proce
Finding Duplicate Records in a Large Unstructured Dataset with AWS Glue FindMatches
A large unstructured dataset contains many duplicate records across several key attributes, and the goal is duplicate detection with the least code de
Ignoring Spaces in Inner Join Fabric Dataflow
When performing an inner join in a Microsoft Fabric dataflow that needs to ignore spaces in values, you should merge the queries using fuzzy matching.
How to Minimize Data Shuffling in PySpark Joins
This page explains how to minimize data shuffling when joining a large DataFrame with a small DataFrame in PySpark. It establishes that using the broa
Unpivot Other Columns in Fabric Dataflow
Learn how to transform data columns into attribute-value pairs in a Microsoft Fabric data flow. Selecting the identifier column and using the 'Unpivot
One-Hot Encoding Ad Campaign Color Schemes for a Neural Network Without Implying Order
An ML engineer is preparing categorical color-scheme data for a neural network that predicts advertising campaign success. Colors are nominal categori
Loading Type 2 SCD in Fabric Data Warehouse
Loading rows into a Type 2 slowly changing dimension in a Microsoft Fabric data warehouse requires specific T-SQL statements because MERGE is unsuppor
Fixing Class Imbalance with the SageMaker Data Wrangler Balance Data Oversampling Operation
Before training the fraud detection model, the engineer must resolve the class imbalance in the dataset with the least operational effort. Both AWS Gl