Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How does the PARTITION BY clause affect the output of files generated by a COPY INTO {location} command?
A
The unload operation partitions table rows into separate files unloaded to the specified table.
B
The unload operation partitions table rows into separate files unloaded to the specified stage.
C
A single file will be loaded with a user-defined partition key and the user can use this partition key for clustering.
D
A single file will be loaded with a Snowflake-defined partition key and Snowflake will use this key for pruning.
