Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-600 Topic 3 Question 15 Discussion

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

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?

A)

B)

C)

D)

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.


Contribute your Thoughts:

Jodi
17 hours ago
Option B looks like the winner to me. Spark's join() method with 'broadcast' seems like the way to go for minimizing data shuffling.
upvoted 0 times
...
Felicidad
4 days ago
I'm not sure, but I think Option C could also work well. It's a tough decision.
upvoted 0 times
...
Anastacia
9 days ago
I agree with Lamar, Option B looks like the best choice for minimizing data shuffling.
upvoted 0 times
...
Lamar
17 days ago
I think we should run Option B.
upvoted 0 times
...

Save Cancel