exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 103 discussion

Actual exam question from Microsoft's DP-600
Question #: 103
Topic #: 1
[All DP-600 Questions]

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.

  • A. Show column value distribution
  • B. Enable column profile
  • C. Show column profile in details pane
  • D. Show column quality details
  • E. Enable details pane
Show Suggested Answer Hide Answer
Suggested Answer: BCE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
taphyoe
Highly Voted 10 months, 2 weeks ago
B Enable column profile E Enable details pane C Show column profile in details pane
upvoted 16 times
...
AGTraining
Highly Voted 10 months, 2 weeks ago
Selected Answer: BCE
answer is BEC
upvoted 7 times
...
Aiden90
Most Recent 1 week, 3 days ago
Selected Answer: BCE
B, C, E directly provide min/max values with minimal steps in Power Query.
upvoted 1 times
...
praticewizards
3 months, 2 weeks ago
Selected Answer: ABC
Show column value distribution (A): Displays a visual representation of data values, which helps in identifying minimum and maximum values along with overall distribution. Enable column profile (B): Provides detailed statistics for each column, including min, max, distinct values, and row count. Show column profile in details pane (C): Allows viewing the column profile information within the details pane, ensuring easy access to min and max values. Why not the other options? D. Show column quality details: This option focuses on data completeness (valid, empty, or error values) but does not provide min/max statistics. E. Enable details pane: While this enables an additional panel for insights, it does not directly provide min/max value identification.
upvoted 1 times
...
282b85d
8 months, 3 weeks ago
Selected Answer: BCE
Column quality: % of Valid, Error, Empty Column distribution: Number of distinct and unique values
upvoted 4 times
...
72bd3bc
8 months, 4 weeks ago
I have checked in Fabric. B. profile E. Enable detail pane C Show column profile in details pane.
upvoted 3 times
...
stilferx
9 months, 1 week ago
Selected Answer: BCE
IMHO, B&C&E looks right. Not A (what distribution?), nor D (what quantity?)
upvoted 2 times
...
bigdave987
9 months, 1 week ago
Selected Answer: BCE
B - Enable column profile; this needs to be enabled to be able to select... C - Show column profile in details pane E - Enable details pane; this needs to be enabled to be able to see the output of (C)
upvoted 4 times
...
woliveiras
9 months, 3 weeks ago
Selected Answer: BCE
BCE are the correct answers.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...