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

Questions 1–5

1. 1foundation · easy

   Which option in a COPY INTO command is used to control the number of output files generated during an unload?

   • AFILE_COUNT
   • BSINGLE_FILE
   • CMAX_FILE_SIZE
   • DPARTITION BY
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which SQL command is used to export data from a Snowflake table to files in a stage?

   • ACOPY INTO <location> FROM <table>
   • BSELECT * FROM <table> INTO <location>
   • CUNLOAD TO <location> FROM <table>
   • DEXPORT DATA TO <location>
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What does the PARTITION BY clause do in an UNLOAD command?

   • ASorts the output data by the specified column
   • BDivides the output into separate files based on column values
   • CLimits the number of rows in each file
   • DSpecifies the file format for each partition
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A data engineer is unloading a 5 TB table to an external stage. The unload is taking over an hour, and the engineer needs to complete it faster. The engineer is using an X-Small warehouse. The engineer has the option to increase the warehouse size or to use a larger warehouse. Which action should the engineer take to improve the unload performance?

   • AUse a smaller file format, such as CSV instead of Parquet, to reduce the amount of data written.
   • BIncrease the warehouse size to a 2X-Large warehouse.
   • CUse a single file for the output to reduce the overhead of managing multiple files.
   • DDisable compression to reduce the CPU overhead during the unload.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which of the following is a best practice when unloading large datasets?

   • AAlways unload to a single file for simplicity
   • BUse compression only for external stages
   • CAvoid using PARTITION BY to reduce complexity
   • DSet MAX_FILE_SIZE to a reasonable value to avoid too many small files
   Reveal Solution Discussion Select an answer first