DP-600: Prepare & Serve Data (lakehouse, warehouse, pipelines)
Prepare & Serve Data (lakehouse, warehouse, pipelines) is one of the skill areas tested on the Fabric Analytics Engineer (DP-600) exam. Below are free DP-600 practice questions with worked answers and a concept diagram — each with a plain-language explanation. Practice the first 10 questions of DP-600 free, no signup.
The concept, in one picture
3 free DP-600 Prepare & Serve Data (lakehouse, warehouse, pipelines) questions
You have a Fabric tenant. In a Fabric notebook you intend to turn a Spark DataFrame into Power BI visuals. You execute the following cell: from powerbiclient import QuickVisualize, get_dataset_config, Report PBI_visualize = QuickVisualize(get_dataset_config(df)) PBI_visualize For each statement, indicate whether it is true (Yes) or false (No).
- The code attaches and embeds a report that already exists in Power BI.No
- The code generates a new Power BI report.Yes
- The code renders an overview of the DataFrame's contents.Yes
QuickVisualize(get_dataset_config(df)) builds a brand-new quick-visualize report from the DataFrame; it does not embed a pre-existing report. Evaluating PBI_visualize renders the auto-generated summary visualization of the DataFrame.
In a Fabric notebook you are exploring a Spark DataFrame stored in a variable named df. You want to switch to the built-in Chart view to visualize the data interactively. Which command renders the DataFrame so the Chart view becomes available?
- show
- ✓ display
- write
- displayHTML
Fabric's built-in display() function renders Spark/Pandas DataFrames and SQL results as a rich table and chart view, so it is what enables the notebook's Chart view for manual exploration.
In a Fabric workspace named Workspace1 there is a dataflow named Dataflow1 that returns 500 rows. You need the minimum and maximum value of every column in the query output. Which three Data view options must you turn on? Each correct answer is part of the solution.
- ✓ Enable details pane
- Show column value distribution
- ✓ Enable column profile
- Show column quality details
- ✓ Show column profile in details pane
Displaying per-column min and max requires enabling the column profile, enabling the details pane, and choosing to show the column profile in the details pane, where the statistics (including min and max) appear.
Practice DP-600 free
The first 10 questions of every exam are free. No signup, no email wall.
Start practicing →Get a free DP-600 study plan by email
A short plan to work through DP-600 by skill area, plus a note when we add new questions. Optional — the practice above stays free. No spam, unsubscribe anytime.