nerdexam
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

DP-700 question #120 exhibit 1
DP-700 question #120 exhibit 2

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.

Full DP-700 Practice