When unloading data with the COPY into command, what is the purpose of the PARTITION BY parameter option?

A. To sort the contents of the output file by the specified expression.

B. To delimit the records in the output file using the specified expression.

C. To include a new column in the output using the specified window function expression.

D. To split the output into multiple files, one for each distinct value of the specified expression.

SnowflakeSnowflake

COF-C02 · Question #571

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

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

Data Loading and Unloading

Question

When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY <expression> parameter option?

Options

ATo sort the contents of the output file by the specified expression.
BTo delimit the records in the output file using the specified expression.
CTo include a new column in the output using the specified window function expression.
DTo split the output into multiple files, one for each distinct value of the specified expression.

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 unloading#COPY into command#Output partitioning#External stages

Full COF-C02 Practice Browse All COF-C02 Questions