Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data engineer loaded data from external CSV files into a Delta table using the COPY INTO command as shown below:
COPY INTO my_table
FROM ‘dbfs:/mnt/retail/bronze/*.csv‘
FILEFORMAT = CSV
COPY INTO my_table
FROM ‘dbfs:/mnt/retail/bronze/*.csv‘
FILEFORMAT = CSV
After successfully running the command for the first time, it was immediately run again, but no data was loaded the second time. What could be the reason for this?*_
A
Execute the REFRESH TABLE command before running COPY INTO again.
B
The COPY INTO command is designed for one-time data ingestion into a Delta table and cannot handle incremental data.
C
Use AUTO LOADER instead of COPY INTO for incremental data ingestion.
D
The COPY INTO command is idempotent, meaning it skips files in the source location that have already been loaded.
E
Replace the COPY INTO command with INSERT OVERWRITE to ensure data is loaded.