SnowPro Core Certification — Question 949

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 maintaining a consistent number of columns across rows ensures that data is loaded correctly into the target table. Option A is incorrect as other delimiters can be used. Option C is not necessary since the data file can be uncompressed. Option D is misleading because it can be true, but it doesn't address the requirement of each row having a consistent column count.