DP-700 Question #120: Real Exam Question with Answer & Explanation

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.