Ultimate access to all questions.
As a Fabric tenant administrator with a semantic model containing 15 tables, your task involves programmatically updating each column whose name ends with the word "Key." The updates required for these columns are:
• 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 tool or method should you use to accomplish this?