ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 104 discussion

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

You have a Fabric tenant that contains a Microsoft Power BI report.

You are exploring a new semantic model.

You need to display the following column statistics:

• Count
• Average
• Null count
• Distinct count
• Standard deviation

Which Power Query function should you run?

  • A. Table.schema
  • B. Table.view
  • C. Table.FuzzyGroup
  • D. Table.Profile
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by prabhjot at April 5, 2024, 9:36 p.m.

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
Submit Cancel
prabhjot
Highly Voted 10 months ago
Ans D correct-The Table.Profile function provides an overview of the data in a table, including basic statistics like count, average, null count, distinct count, and standard deviation for numerical columns. T
upvoted 10 times
...
stilferx
Highly Voted 8 months, 3 weeks ago
Selected Answer: D
IMHO, D Returns a profile for the columns in table. Because: Table.Profile(table as table... The following information is returned for each column (when applicable): minimum maximum average standard deviation count null count distinct count Link: https://learn.microsoft.com/en-us/powerquery-m/table-profile
upvoted 7 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