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

Questions 1–5

1. 1foundation · easy

   Which clause is required in a COPY INTO statement to specify the source files for loading?

   • AFILE_FORMAT
   • BINTO
   • CFROM
   • DON_ERROR
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which clause in a COPY INTO statement is used to specify the external cloud storage location?

   • ASTORAGE = 's3://bucket/path'
   • BFROM 's3://bucket/path'
   • CINTO 's3://bucket/path'
   • DLOCATION = 's3://bucket/path'
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which benefit does Snowpipe provide over manual COPY INTO commands?

   • AFaster loading for large files
   • BLower storage costs for staged files
   • CAutomated loading without user intervention
   • DAbility to load data from any source
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which SQL command creates an internal named stage?

   • ACREATE STAGE my_stage;
   • BCREATE TABLE STAGE my_stage;
   • CCREATE INTERNAL STAGE my_stage;
   • DCREATE LOCATION my_stage;
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which COPY option should you use to skip files that contain errors and continue loading other files?

   • ASIZE_LIMIT = 1000000
   • BON_ERROR = 'CONTINUE'
   • CPURGE = TRUE
   • DON_ERROR = 'ABORT_STATEMENT'
   Reveal Solution Discussion Select an answer first