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

Questions 1–5

1. 1application · medium

   A data engineer has set up a Snowpipe to load data from an external stage. They notice that some files are not being loaded and want to investigate the cause. Which Snowflake view or function should they query to see the load history and error details for the pipe?

   • AQuery the LOAD_HISTORY view to see all loads, but it does not include Snowpipe loads.
   • BQuery the PIPE_USAGE view to see the pipe's execution history.
   • CQuery the STAGE_STORAGE_USAGE view to see the files in the stage.
   • DQuery the COPY_HISTORY table function for the pipe name to see load status and errors.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Snowflake view or table provides metadata about files that have been loaded into a table, including load history?

   • APIPE_USAGE view
   • BSTAGE_STORAGE_USAGE view
   • CQUERY_HISTORY view
   • DCOPY_HISTORY table function
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which Snowflake feature allows you to enforce data quality rules by checking that loaded data meets specified conditions?

   • AData sharing
   • BConstraints (e.g., NOT NULL, UNIQUE)
   • CStored procedures
   • DExternal functions
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the purpose of the VALIDATION_MODE option in the COPY INTO command?

   • ATo skip files with errors
   • BTo load only a subset of columns
   • CTo specify the file format for validation
   • DTo test loading files without actually loading data
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which Snowflake feature is specifically designed to automatically load data from staged files as soon as they arrive, enabling continuous data ingestion without manual intervention?

   • ASnowpipe
   • BTask with a schedule
   • CExternal function
   • DCOPY INTO command
   Reveal Solution Discussion Select an answer first