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 =…
Statements to evaluate and their correct Yes/No answers are missing.
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
Explanation
Statements to evaluate and their correct Yes/No answers are missing.
Topics
#Spark DataFrame operations#PySpark#Data transformation#Data cleansing
Community Discussion
No community discussion yet for this question.

