SnowPro Core Certification — Question 566
Which command should be used when loading many flat files into a single table?
Answer options
- A. PUT
- B. INSERT
- C. COPY INTO
- D. MERGE
Correct answer: C
Explanation
The correct answer is C, COPY INTO, as this command is specifically designed to load data from flat files into a table efficiently. Options A (PUT) and B (INSERT) are not optimal for bulk loading, and D (MERGE) is used for combining records rather than for loading files.