SnowPro Core Certification — Question 520

When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?

Answer options

• A. FILE_FORMAT
• B. PATTERN
• C. VALIDATION_MODE
• D. FILES

Correct answer: B

Explanation

The correct answer is B, as using the PATTERN parameter requires the system to evaluate each file against the specified regex, which can lead to performance issues with many files. The other options, such as FILE_FORMAT, VALIDATION_MODE, and FILES, do not inherently cause the same level of performance degradation when handling large file sets.