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

Questions 21–25

1. 21foundation · easy

   Which system function or view can be used to monitor the load history of a pipe?

   • ASYSTEM$PIPE_STATUS
   • BPIPE_HISTORY
   • CLOAD_HISTORY
   • DCOPY_HISTORY
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which function can be used to check the status of a pipe, including whether it is running or paused?

   • ACOPY_HISTORY
   • BSYSTEM$PIPE_ERROR
   • CSYSTEM$PIPE_STATUS
   • DSYSTEM$PIPE_HISTORY
   Reveal Solution Discussion Select an answer first
4. 23expert · medium

   A company uses Snowpipe to load data from an S3 bucket. They have a requirement to load files as soon as they arrive, but they also want to minimize credit consumption. The files arrive in bursts, with long idle periods. Which strategy best balances these requirements?

   • AUse a virtual warehouse with auto-suspend to run COPY INTO.
   • BUse Snowpipe with auto-ingest and rely on its event-driven nature to consume credits only when files arrive.
   • CUse Snowpipe without auto-ingest and call the REST API manually.
   • DUse a scheduled task to run COPY INTO every 5 minutes.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which SQL command is used to create a pipe in Snowflake?

   • ACREATE STREAM
   • BCREATE TASK
   • CCREATE PIPE
   • DCREATE SNOWPIPE
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which FILE_FORMAT option would you set to treat the first line of a CSV file as a header row?

   • ASKIP_HEADER = 1
   • BFIELD_OPTIONALLY_ENCLOSED_BY = '"'
   • CCOMPRESSION = 'GZIP'
   • DNULL_IF = ('')
   Reveal Solution Discussion Select an answer first