Exam DP-600 topic 1 question 87 discussion

Best Practice Analyzer should be able to identify these with some rules

Model view in Microsoft Power BI Desktop: This tool allows you to visually inspect and manage the relationships and properties of tables and columns in your Power BI model. You can easily identify surrogate key columns and check their Summarize By property.

The Best Practice Analyzer (BPA) in Tabular Editor can be configured to check for specific properties and configurations in your model. This includes identifying columns with certain "Summarize By" settings. You can create or use existing BPA rules to quickly identify any surrogate key columns that do not have the "Summarize By" property set to "None," thus minimizing the manual effort required.

D (although it can be done it B, but not as efficiently as D) To identify surrogate key columns with the 'Summarize By' property set to a value other than 'None,' the Best Practice Analyzer in Tabular Editor is the most efficient tool. The Best Practice Analyzer can analyze the entire model and provide a report on all columns that do not meet a specified best practice, such as having the 'Summarize By' property set correctly for surrogate key columns. Here's how you would proceed: Open your Power BI model in Tabular Editor. Go to the Advanced Scripting window. Write or use an existing script that checks the 'Summarize By' property of each column. Execute the script to get a report on the surrogate key columns that do not have their 'Summarize By' property set to 'None'. You can then review and adjust the properties of the columns directly within the Tabular Editor.

I go with D) Best Practice Analyzer

It should be B https://learn.microsoft.com/en-us/power-bi/transform-model/model-explorer#anatomy-of-model-explorer https://www.purplefrogsystems.com/2021/08/how-to-change-the-summarization-of-multiple-columns-in-power-bi/#:~:text=Once%20you've%20selected%20the,That's%20it!