Microsoft Exam DP-600 Topic 1 Question 8 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 8
Topic #: 1

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: A

by Estrella at Mar 21, 2024, 02:51 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Beatriz

5 days ago

I think the best option is to run code B.

upvoted 0 times

...

Louann

28 days ago

Haha, good one! I'll make sure to keep my notes in a Fabric notebook, just like the one in the question. Definitely the most efficient way to study for this exam.

upvoted 0 times

...

15 days ago

I think I will go with option C as well.

upvoted 0 times

...

Ooh, good catch! Option C does seem like the winner here. Broadcast joins are great for minimizing data movement, especially when one of the DataFrames is small enough to fit in memory on each partition.

upvoted 0 times

...