Explanation:
The PUT command in Snowflake automatically compresses files using GZIP (option C) and encrypts the file data in transit (option D). These are built-in security and optimization features of the PUT command when uploading files to internal stages. Option A is incorrect because PUT does not create file format objects - that requires the CREATE FILE FORMAT command. Option B is incorrect because PUT does not automatically use the last stage created; the stage must be explicitly specified. Option E is incorrect because PUT uploads files to stages, it does not create or populate tables.
Ultimate access to all questions.
What actions are automatically performed by the PUT command? (Choose two.)
A
It creates a file format object.
B
It uses the last stage created.
C
It compresses all files using GZIP.
D
It encrypts the file data in transit.
E
It creates an empty target table.
No comments yet.