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.
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.