Exam DP-600 Topic 2 Question 87 Discussion
Actual exam question for Microsoft's DP-600 exam
Question #: 87
Topic #: 2
Question #: 87
Topic #: 2
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?
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?
Suggested Answer: B Vote an answer
Tabular Editor is an advanced tool for editing Tabular models outside of Power BI Desktop that allows you to script out changes and apply them across multiple columns or tables. To accomplish the task programmatically, you would:
* Open the model in Tabular Editor.
* Create an Advanced Script using C# to iterate over all tables and their respective columns.
* Within the script, check if the column name ends with 'Key'.
* For columns that meet the condition, set the properties accordingly: IsHidden = true, IsNullable = false, SummarizeBy = None, IsAvailableInMDX = false.
* Additionally, mark the column as a key column.
* Save the changes and deploy them back to the Fabric tenant.
References: The ability to batch-edit properties using scripts in Tabular Editor is well-documented in the tool's official documentation and user community resources.
* Open the model in Tabular Editor.
* Create an Advanced Script using C# to iterate over all tables and their respective columns.
* Within the script, check if the column name ends with 'Key'.
* For columns that meet the condition, set the properties accordingly: IsHidden = true, IsNullable = false, SummarizeBy = None, IsAvailableInMDX = false.
* Additionally, mark the column as a key column.
* Save the changes and deploy them back to the Fabric tenant.
References: The ability to batch-edit properties using scripts in Tabular Editor is well-documented in the tool's official documentation and user community resources.
by Maria at Mar 19, 2025, 02:45 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).