DP-203 Certification Practice Question #195

Question

You have an Azure Synapse Analytics workspace that contains an Apache Spark pool named Pool1.

You need to read data from a CSV file and write the data to a Delta table by using Pool1.

How should you complete the PySpark code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The official Delta Lake pattern in Spark is to read the CSV into a DataFrame, work with a Delta table reference by path when the table location is being addressed directly, and then persist data in Delta format. The community specifically calls out `DeltaTable.forPath(...)`, and that fits the typical code-completion answer expected in a hotspot question of this type. Confidence is a bit lower only because the exact dropdown text is visible only in the image.

More DP-203 practice questions