Load and Unload Data with COPY INTO and Snowpipe DEA-C02 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which file format option is commonly used to compress unloaded data files?

   • AFILE_EXTENSION = '.csv'
   • BCOMPRESSION = 'GZIP'
   • CFIELD_DELIMITER = ','
   • DNULL_IF = ('')
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which copy option is used to validate data files without loading them into the table?

   • APURGE
   • BVALIDATION_MODE
   • CON_ERROR
   • DSIZE_LIMIT
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which SQL statement unloads data from the table my_table to the stage @my_stage?

   • AUNLOAD DATA FROM my_table TO @my_stage;
   • BEXPORT my_table TO @my_stage;
   • CCOPY INTO my_table FROM @my_stage;
   • DCOPY INTO @my_stage FROM my_table;
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which SQL statement correctly loads data from the stage @my_stage into the table my_table using the default file format?

   • ACOPY @my_stage INTO my_table;
   • BINSERT INTO my_table FROM @my_stage;
   • CLOAD DATA INTO my_table FROM @my_stage;
   • DCOPY INTO my_table FROM @my_stage;
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the primary purpose of Snowpipe?

   • ATo load data continuously as soon as new files arrive in a stage
   • BTo create a backup of data files in a stage
   • CTo transform data using SQL functions during loading
   • DTo unload data from tables to external storage on a schedule
   Reveal Solution Discussion Select an answer first