Get data
11 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
Ingesting Customer Data into AnalyticsPOC Workspace
This scenario tests ingesting data into a Fabric data store while adhering to technical constraints. The page establishes that a dataflow is the corre
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
Cross-Workspace Lakehouse Querying Without Data Copies
Microsoft Fabric shortcuts allow you to query tables across different lakehouses and workspaces without duplicating data. This page establishes that a
What Can You Identify About a Column in Power Query Profile?
This page explains how to interpret Power Query column profiling statistics to identify duplicate values in a Fabric dataflow. It establishes that whe
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
AWS S3 Shortcut Authentication Values
When creating a OneLake shortcut to an Amazon S3 bucket in Microsoft Fabric, you must authenticate using AWS credentials. This page establishes that t
How to Read Lakehouse Shortcut Data in Fabric Notebook
This page explains the correct PySpark syntax to read data from a OneLake shortcut in a Fabric lakehouse notebook. It establishes that shortcuts inten