Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Microsoft Exam DP-600 Topic 3 Question 12 Discussion
Actual exam question for
Microsoft's
DP-600 exam
Question #: 12
Topic #: 3
[All DP-600 Questions]
Topic #: 3
You have a Fabric tenant that contains a Microsoft Power Bl 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?
Suggested Answer:
B
The Table.Profile function in Power Query is used to generate column statistics such as count, average, null count, distinct count, and standard deviation. You can use this function as follows:
Invoke the Power Query Editor.
Apply the Table.Profile function to your table.
The result will be a table where each row represents a column from the original table, and each column in the result represents a different statistic such as those listed in the requirement.
Currently there are no comments in this discussion, be the first to comment!