MDFT Academy Quizzes

Identify Surrogate Key Columns By Summarize By Property

MDFT Academy has deployed 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?

Choose the correct answer from the options below.

Explanations for each answer:

Tabular Editor Best Practice Analyzer is correct.
DAX Formatter in DAX Studio is incorrect. DAX Formatter is a tool for formatting and validating DAX expressions, but it does not analyze model properties or configurations.
Model explorer in Microsoft Power BI Desktop is incorrect. The Model explorer in Power BI Desktop allows you to view and manage model objects, but it does not provide automated analysis of surrogate key configurations. While you could manually check each surrogate key's Summarize By property, this would be time-consuming and not minimize effort as required.
Model view in Microsoft Power BI Desktop is incorrect. The Model view in Power BI Desktop provides a visual representation of the data model, but it does not include tools for analyzing surrogate key configurations. Although you could manually check each surrogate key's Summarize By property, this would be time-consuming and not minimize effort as required.

Exam Preparation Quiz

Identify Surrogate Key Columns By Summarize By Property