Free Preparation Discussions
MENU
Microsoft DP-600 Exam - 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.
Aleisha
4 months agoCurtis
4 months agoAdria
4 months agoFredric
4 months agoHerman
4 months agoArleen
5 months agoKyoko
5 months agoDorian
5 months agoGracia
5 months agoEzekiel
5 months agoLennie
5 months agoIola
5 months agoArt
5 months agoChaya
5 months agoJade
6 months agoAmira
6 months agoLatrice
10 months agoMirta
9 months agoJaney
10 months agoAlberto
10 months agoPhillip
11 months agoBrynn
10 months agoChana
10 months agoGerald
10 months agoGalen
11 months agoAlpha
10 months agoCristy
10 months agoYuki
10 months agoJaclyn
10 months agoDerrick
11 months agoJodi
11 months agoLouisa
10 months agoTheodora
11 months agoFelicidad
11 months agoAnastacia
11 months agoLamar
12 months ago