
Ultimate access to all questions.
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.