Microsoft
DP-700 · Question #120
You have Fabric lakehouse that contains a table named Table1. Table1 stores data in the following format. You have a notebook that contains the following code segment. df = df.withColumn("customername
Sign in or unlock DP-700 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Design and implement data ingestion and transformation
Question
You have Fabric lakehouse that contains a table named Table1. Table1 stores data in the following format. You have a notebook that contains the following code segment.
df = df.withColumn("customername", when(col("customername").isNull(), lit("unknown")).otherwise(col("customername")))
df = df.withColumn("customername", split(col("email"), "@").getItem(0))
df = df.dropDuplicates(["OrderDate"]).select(col("OrderDate"), year("OrderDate").alias("Year"), col("customername"))
df = df.limit(10)
display(df.head(10))
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Exhibits
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Spark DataFrame operations#PySpark#Data transformation#Data cleansing

