Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 821

How does the PARTITION BY option affect an expression for a COPY INTO command?

The unload operation partitions table rows into separate files unloaded to the specified table.

The unload operation partitions table rows into separate files unloaded to the specified stage.

A single file will be loaded with a user-defined partition key and the user can use this partition key for clustering.

A single file will be loaded with a Snowflake-defined partition key and Snowflake will use this key for pruning.

Correct Answer: B

The PARTITION BY option in a COPY INTO command partitions table rows into separate files that are unloaded to the specified stage. This allows for efficient data management and retrieval by organizing the data into partitions based on specified columns in the table.

Discussion

GwoOption: B

B. The PARTITION BY option in a COPY INTO command specifies an expression that partitions the unloaded table rows into separate files unloaded to the specified stage. The expression must be based on one or more columns in the table.

kayuhanbidukOption: B

B correct

HeetecOption: B

B correct - https://docs.snowflake.com/en/user-guide/data-unload-overview