SnowPro Core Recertification — Question 22

When a Snowflake user loads CSV data from a stage, which COPY INTO <table> command guideline should they follow?

Answer options

• A. The CSV field delimiter must be a comma character (',').
• B. The number of columns in each row should be consistent.
• C. The data file in the stage must be in a compressed format.
• D. The data file must have the same number of columns as the target table.

Correct answer: B

Explanation

The correct answer is B because having a consistent number of columns in each row is essential for successful data loading. Options A, C, and D are incorrect because while they might be relevant, they do not pertain to the requirement for column consistency within the rows.