What tasks can be completed using the COPY command? (Choose two.)
What tasks can be completed using the COPY command? (Choose two.)
The COPY command can be used to reorder columns and omit columns during the data loading process. Reordering columns involves specifying a different order for the columns when loading the data, and omitting columns allows you to exclude certain columns from being loaded into the table. These functionalities are typically available in data loading commands to provide flexibility in how the incoming data is handled.
yes CD, Note that COPY transformations do not support the FLATTEN function, or JOIN or GROUP BY (aggregate) syntax. https://docs.snowflake.com/en/user-guide/data-load-transform
https://docs.snowflake.com/en/user-guide/data-load-transform.html
Right answer
Columns can be reordered. Columns can be omitted.
Correct
C and D
C and D are correct
columns can be reordered and omitted