SnowPro Core Certification — Question 288
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
Answer options
- A. In the metadata of the target table for 14 days
- B. In the metadata of the pipe for 14 days
- C. In the metadata of the target table for 64 days
- D. In the metadata of the pipe for 64 days
Correct answer: C
Explanation
The correct answer is C because the bulk data load history is indeed stored in the metadata of the target table and is retained for 64 days. Options A and B are incorrect as they state a shorter retention period of 14 days, while option D incorrectly attributes the storage to the pipe instead of the target table.