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

Questions 11–15

1. 11foundation · easy

   Which DDL command is used to remove a pipe from Snowflake?

   • ADROP PIPE
   • BALTER PIPE ... SET
   • CDELETE PIPE
   • DREMOVE PIPE
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which type of stage is created automatically when a table is created and is used to stage files for that table?

   • AExternal stage
   • BInternal named stage
   • CUser stage
   • DTable stage
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which practice can help optimize Snowpipe cost and performance?

   • ADisabling auto-ingest to reduce costs
   • BLoading files in larger batches to reduce the number of load operations
   • CCreating a separate pipe for each file
   • DUsing a larger warehouse for Snowpipe
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which external cloud storage service can be specified directly in a COPY INTO statement as a source location?

   • AAmazon S3
   • BGoogle Drive
   • COneDrive
   • DDropbox
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which file format type would you specify in a FILE_FORMAT clause to load newline-delimited JSON data?

   • APARQUET
   • BAVRO
   • CCSV
   • DJSON
   Reveal Solution Discussion Select an answer first