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

Questions 26–30

1. 26foundation · easy

   Which function can be used in a COPY INTO SELECT clause to convert a string to a date?

   • ATO_NUMBER
   • BTO_DATE
   • CTO_BOOLEAN
   • DTO_CHAR
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A data engineer needs to monitor the number of files loaded by a Snowpipe over the past week. Which Snowflake view or function should they query?

   • AINFORMATION_SCHEMA.LOAD_HISTORY
   • BPIPE_STATUS table function
   • CCOPY_HISTORY table function
   • DPIPE_USAGE_HISTORY table function
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which mechanism can be used to automatically trigger Snowpipe when new files arrive in an external cloud storage bucket?

   • ACloud storage event notifications
   • BA manual COPY INTO command
   • CA stored procedure that polls the stage
   • DA scheduled task that runs COPY INTO
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   What is required to enable auto-ingest for a pipe that reads from an internal stage?

   • AA cloud storage event notification from the external bucket
   • BA scheduled task that calls SYSTEM$PIPE_FORCE_RESUME
   • CA Snowflake event notification (e.g., using a notification integration)
   • DA user-defined function that polls the stage
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   How does Snowpipe consume credits?

   • ACredits are consumed based on the number of pipes created
   • BCredits are consumed continuously regardless of load activity
   • CCredits are consumed based on the size of the stage
   • DCredits are consumed only when files are loaded
   Reveal Solution Discussion Select an answer first