Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DP-600 Topic 4 Question 10 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 10
Topic #: 4
[All DP-600 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

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.


by Jutta at Apr 19, 2024, 05:32 PM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Olene
7 months ago
I think DAX Studio might work as well, but Tabular Editor seems like the most popular choice.
upvoted 0 times
...
Fannie
7 months ago
I'm not sure, but I think ALM Toolkit could also be a good option.
upvoted 0 times
...
Salena
7 months ago
I agree with User1, Tabular Editor seems like the right tool for the job.
upvoted 0 times
...
Arminda
7 months ago
I think we should use Tabular Editor for this.
upvoted 0 times
...
Pearlie
8 months ago
I have heard that Tabular Editor is really efficient for these kinds of tasks.
upvoted 0 times
...
Audry
8 months ago
I agree with you, B) Tabular Editor seems like the right choice.
upvoted 0 times
Jacob
7 months ago
I agree, Tabular Editor is the best option for programmatically changing those column properties.
upvoted 0 times
...
Art
7 months ago
Tabular Editor is a great choice for managing semantic models. It's designed for tasks like these.
upvoted 0 times
...
Catalina
7 months ago
I have used Tabular Editor before and it worked well for similar tasks. It's a powerful tool.
upvoted 0 times
...
Lakeesha
7 months ago
I think Tabular Editor is the way to go. It offers a lot of flexibility for making those specific changes.
upvoted 0 times
...
Nohemi
8 months ago
Definitely B) Tabular Editor. It allows for precise control over column properties.
upvoted 0 times
...
...
Pearly
8 months ago
I think the answer is B) Tabular Editor.
upvoted 0 times
...

Save Cancel