Implementing Analytics Solutions Using Microsoft Fabric — Question 75

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?

Answer options

• A. Table.schema
• B. Table.view
• C. Table.FuzzyGroup
• D. Table.Profile

Correct answer: D

Explanation

The correct answer is D, Table.Profile, as it generates detailed statistics about the columns in a table, including the required metrics. The other options do not provide the necessary statistical summaries: Table.schema only retrieves metadata, Table.view creates a view of a table, and Table.FuzzyGroup is used for grouping similar items, not for statistics.