Free Preparation Discussions
MENU
Microsoft Exam DP-600 Topic 3 Question 15 Discussion
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?
A)
B)
C)
D)
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.
Latrice
1 months agoJaney
18 days agoAlberto
20 days agoPhillip
1 months agoBrynn
8 days agoChana
16 days agoGerald
22 days agoGalen
1 months agoAlpha
13 days agoCristy
15 days agoYuki
18 days agoJaclyn
20 days agoDerrick
1 months agoJodi
2 months agoLouisa
22 days agoTheodora
1 months agoFelicidad
2 months agoAnastacia
2 months agoLamar
2 months ago