Question

You are a Fabric Analytics Engineer ingesting a large CSV file into a lakehouse using a Spark notebook. The business wants the resulting managed table to support ACID transactions, time travel, and efficient upserts for future incremental loads. Which write approach should you use in the notebook?

Accepted Answer

Write the DataFrame using df.write.format("delta").mode("overwrite").saveAsTable("sales") to create a managed Delta table

Answer

Write the DataFrame using df.write.format("csv").save("Files/sales") to persist the raw file in the Files area

Answer

Write the DataFrame using df.write.format("parquet").save("Tables/sales") to store the data as plain Parquet

Answer

Write the DataFrame using df.write.format("json").mode("append").save("Files/sales") to keep the data flexible