SnowPro Advanced: Data Engineer — Question 56

A Data Engineer would like to define a file structure for loading and unloading data.
Where can the file structure be defined? (Choose three.)

Answer options

• A. COPY command
• B. MERGE command
• C. FILE FORMAT object
• D. PIPE object
• E. STAGE object
• F. INSERT command

Correct answer: A, C, E

Explanation

The correct answers are A, C, and E. The COPY command allows for specifying file structures during data loading, the FILE FORMAT object defines how files are interpreted, and the STAGE object is used for storing files before loading. The MERGE command, PIPE object, and INSERT command do not define file structures.