Answer-first summary for fast verification
Answer: `CONVERT TO DELTA` can only be used with parquet data.
The `CONVERT TO DELTA` command is specifically designed to convert parquet files into Delta tables, enabling the data to be accessed as a table and leveraging the benefits of Delta tables. Attempting to convert a CSV file using this command results in an error, as it only supports parquet tables. For more information, refer to the Databricks documentation on using `CONVERT TO DELTA`.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data engineer discovered a CSV file containing records of the company’s old customers, including some columns with PII data. The engineer attempted to convert this file to a Delta table using the command: CONVERT TO DELTA csv.′path_to_csv′. However, the command failed. What is the reason for this failure?
A
CONVERT TO DELTA is an invalid command.
B
CONVERT TO DELTA can only be used with partitioned data.
C
CONVERT TO DELTA can only be used with parquet data.
D
Databricks restricts the conversion of CSV files with PII data to a Delta table.