How to Identify Min and Max Values in Dataflow Data View
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.
Community Votes
100% of anonymous learners picked answer BCE. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
To view min and max values in a dataflow, you must enable the column profile, enable the details pane, and show the column profile within that details pane.
Identifying the minimum and maximum values for columns in a Fabric dataflow requires enabling specific data view options. This page confirms the correct combination of settings to display column profile statistics in the details pane.
Selecting "Show column value distribution" (A) or "Show column quality details" (D) instead of the profile and details pane options, misunderstanding where min/max statistics are displayed.
Community Discussion (7 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
To identify the minimum and maximum values for each column in a Fabric dataflow, you must enable column profiling and ensure the results are visible. Option B ("Enable column profile") turns on the calculation of these statistics. Option E ("Enable details pane") makes the pane available, and Option C ("Show column profile in details pane") directs the min/max statistics to be rendered there. Together, BCE provides the complete path to visualize the min and max values.Why the Other Options Are Wrong
Option A ("Show column value distribution") displays a visual chart of value frequencies, not the discrete min and max statistics. Option D ("Show column quality details") reveals the percentage of valid, error, and empty values but does not include min/max metrics. Option E alone ("Enable details pane") only opens the pane but does not populate it with column profile data without C and B.Community Comment Notes
The community consensus strongly supports BCE. Commenters point out that B and E are prerequisites to display the output of C, as bigdave987 noted: "B - Enable column profile... E - Enable details pane... C - Show column profile in details pane". Another user clarified the distinction by stating that A is for distribution and D is for quality, neither of which provide min/max values.Official Reference
Exam Strategy
When asked how to view specific data profiling statistics like min or max, remember the three-step UI toggle: enable the profile, enable the pane, and show the profile in the pane. Distinguish between "quality" (valid/error/empty) and "profile" (min/max/distinct).
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →