DP-600 · Question #89
DP-600 Question #89: Real Exam Question with Answer & Explanation
The correct answer is B: Enable column profile. In Power Query (used by Fabric Dataflows), column statistics including min and max values are surfaced through the column profile feature. You must: (B) Enable column profile to activate statistical analysis of column data; (E) Enable details pane to make the lower details area v
Question
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data. You need to identify the min and max values for each column in the query results. Which three Data view options should you select? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Options
- AShow column value distribution
- BEnable column profile
- CShow column profile in details pane
- DShow column quality details
- EEnable details pane
Explanation
In Power Query (used by Fabric Dataflows), column statistics including min and max values are surfaced through the column profile feature. You must: (B) Enable column profile to activate statistical analysis of column data; (E) Enable details pane to make the lower details area visible in the Data view; and (C) Show column profile in details pane to display the full statistics (min, max, average, etc.) there. 'Show column quality details' (D) shows error/valid/empty percentages, not min/max. 'Show column value distribution' (A) shows a histogram, not the specific min/max statistics.
Topics
Community Discussion
No community discussion yet for this question.