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 7 months ago
B Enable column profile E Enable details pane C Show column profile in details pane
upvoted 16 times
...
AGTraining
Highly Voted 7 months ago
Selected Answer: BCE
answer is BEC
upvoted 7 times
...
praticewizards
Most Recent 6 days, 16 hours 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
5 months, 1 week ago
Selected Answer: BCE
Column quality: % of Valid, Error, Empty Column distribution: Number of distinct and unique values
upvoted 4 times
...
72bd3bc
5 months, 2 weeks ago
I have checked in Fabric. B. profile E. Enable detail pane C Show column profile in details pane.
upvoted 3 times
...
stilferx
5 months, 3 weeks ago
Selected Answer: BCE
IMHO, B&C&E looks right. Not A (what distribution?), nor D (what quantity?)
upvoted 2 times
...
bigdave987
6 months 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
6 months, 1 week 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago