When a Snowflake user loads CSV data from a stage, which copy into command guideline should they follow?

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.

SnowflakeSnowflake

COF-C02 · Question #586

COF-C02 Question #586: Real Exam Question with Answer & Explanation

Sign in or unlock COF-C02 to reveal the answer and full explanation for question #586. The question stem and answer options stay visible for context.

Data Loading and Unloading

Question

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

Options

AThe CSV field delimiter must be a comma character (*,"),
BThe number of columns in each row should be consistent.
CThe data file in the stage must be in a compressed format.
DThe data file must have the same number of columns as the target table.

Unlock COF-C02 to see the answer

You've previewed enough free COF-C02 questions. Unlock COF-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock COF-C02 - $49.99 / 30 days Sign in

Topics

#Data Loading#COPY INTO#CSV#Stages

Full COF-C02 Practice Browse All COF-C02 Questions