Explanation:
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.
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.
No comments yet.