Implementing Analytics Solutions Using Microsoft Fabric — Question 90

You have a Microsoft Power BI semantic model.

You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The solution must minimize effort.

What should you use?

Answer options

• A. DAX Formatter in DAX Studio
• B. Model explorer in Microsoft Power BI Desktop
• C. Model view in Microsoft Power BI Desktop
• D. Best Practice Analyzer in Tabular Editor

Correct answer: D

Explanation

The Best Practice Analyzer in Tabular Editor is specifically designed to identify such properties in the model efficiently. The other options, while useful for various tasks, do not provide the focused analysis needed to identify surrogate key columns with non-default Summarize By settings.