Get data
6 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 file format and shortcut location enable Fabric SQL endpoint queries?
This DP-600 question asks which two actions let you query Amazon S3 sales files from a Fabric lakehouse SQL endpoint. The page establishes that you mu
How Do You Access the Productline1 Lakehouse Shortcut from a Fabric Notebook?
This DP-600 case-study question asks which notebook syntax reads the Productline1 data that Contoso exposes through a shortcut named ResearchProduct i
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 Do You Set a Partition Column in a Fabric Copy Activity?
In a Fabric Data Factory Copy activity, a destination lakehouse table can only be partitioned by a source column after the table action is switched to
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
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