Microsoft Exam DP-600 Topic 3 Question 15 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 15
Topic #: 3

You are analyzing customer purchases in a Fabric notebook by using PySpanc You have the following DataFrames:

You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling. You write the following code.

Which code should you run to populate the results DataFrame?

AOption A

BOption B

COption C

DOption D

Show Suggested 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 Rebecka at Jun 23, 2024, 07:52 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Felicidad

2 days ago

I'm not sure, but I think Option C could also work well. It's a tough decision.

upvoted 0 times

...

Anastacia

7 days ago

I agree with Lamar, Option B looks like the best choice for minimizing data shuffling.

upvoted 0 times

...

Lamar

15 days ago

I think we should run Option B.

upvoted 0 times

...