SnowPro Core Certification — Question 1123
What Snowflake recommendation is designed to ensure that staged data is only loaded once?
Answer options
- A. Partitioning staged data files
- B. Loading only the most recently-staged data files
- C. Removing data files after loading
- D. Identifying and removing duplicates after each data load
Correct answer: C
Explanation
The correct answer, C, is accurate because removing data files after loading prevents the same data from being loaded multiple times. Options A and B do not directly address the issue of repeated loading, while option D, although relevant to duplicates, does not prevent the original data from being loaded multiple times.