
Ultimate access to all questions.
A data engineer is responsible for executing a daily operation that involves copying sales data from the previous day into a table named transactions. The sales data for each day is stored in separate files located in the directory "/transactions/raw". To perform today’s data copying task, the data engineer runs a specific command. However, after executing the command, the data engineer observes that the number of records in the transactions table remains unchanged. Which of the following could explain why the command did not add any new records to the table?
A
The format of the files to be copied were not included with the FORMAT_OPTIONS keyword._
B
The names of the files to be copied were not included with the FILES keyword.
C
The previous day's file has already been copied into the table.
D
The PARQUET file format does not support COPY INTO.
E
The COPY INTO statement requires the table to be refreshed to view the copied rows.