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.
No comments yet.
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.