Unload Data from Snowflake COF-C03 Practice Questions (Page 3)

Questions 11–13

1. 11foundation · easy

   What is the correct syntax to unload all rows from the table 'sales' to a stage named 'my_stage'?

   • AUNLOAD @my_stage FROM sales;
   • BCOPY INTO @my_stage FROM sales;
   • CCOPY INTO sales FROM @my_stage;
   • DCOPY sales INTO @my_stage;
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   How does Snowflake improve performance for large unloads?

   • ABy using parallel processing across multiple nodes
   • BBy caching the data in memory
   • CBy using a single large file to reduce overhead
   • DBy compressing all files to the smallest possible size
   Reveal Solution Discussion Select an answer first
3. 13foundation · easy

   Which option in a COPY INTO command is used to specify compression for unloaded files?

   • AFILE_COMPRESSION = 'GZIP'
   • BZIP = 'GZIP'
   • CCOMPRESSION = 'GZIP'
   • DENCRYPTION = 'AES'
   Reveal Solution Discussion Select an answer first