Implementing Analytics Solutions Using Microsoft Fabric — Question 97

You have a Fabric tenant that contains a semantic model. The model contains 15 tables.

You need to programmatically change each column that ends in the word Key to meet the following requirements:

• Hide the column.
• Set Nullable to False
• Set Summarize By to None.
• Set Available in MDX to False.
• Mark the column as a key column.

What should you use?

Answer options

• A. Microsoft Power BI Desktop
• B. ALM Toolkit
• C. Tabular Editor
• D. DAX Studio

Correct answer: C

Explanation

The correct answer is C, Tabular Editor, as it allows for bulk modifications of model properties, including hiding columns and adjusting key settings. Microsoft Power BI Desktop and DAX Studio do not provide the necessary features for these specific modeling changes, and ALM Toolkit is primarily focused on version control and deployment rather than direct model manipulation.