Ingest and Prepare Data in Snowflake SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the primary purpose of Snowpipe?

   • ATo share data between accounts
   • BTo schedule SQL tasks
   • CTo automatically load data from staged files as they arrive
   • DTo transform data during loading
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is the purpose of a stage in Snowflake?

   • ATo provide a compute warehouse for loading
   • BTo execute SQL queries on data
   • CTo manage user permissions
   • DTo store data files temporarily for loading into tables
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which COPY INTO option allows you to skip a file entirely if it contains any errors?

   • AON_ERROR = 'CONTINUE'
   • BON_ERROR = 'SKIP_ROW'
   • CON_ERROR = 'ABORT_STATEMENT'
   • DON_ERROR = 'SKIP_FILE'
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What does the COPY INTO command do in Snowflake?

   • AExports data from a table to a file
   • BCopies data from one table to another within the same database
   • CLoads data from staged files into a table
   • DCreates a new stage for storing files
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which object must be created to use Snowpipe for continuous loading?

   • ATask
   • BStage
   • CWarehouse
   • DPipe
   Reveal Solution Discussion Select an answer first