Ingest Data for Analysis SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 6)

Questions 26–30

1. 26foundation · easy

   What is the difference between an internal stage and an external stage in Snowflake?

   • AInternal stages are faster than external stages.
   • BInternal stages are used for loading data, while external stages are used for unloading data.
   • CInternal stages store files within Snowflake, while external stages reference files in cloud storage.
   • DExternal stages are more secure than internal stages.
   Reveal Solution Discussion Select an answer first
2. 27expert · medium

   A company uses Snowpipe to load JSON files from an S3 bucket into a Snowflake table. The files are small (a few KB) and arrive in bursts of hundreds at a time. The data analyst notices that Snowpipe is taking a long time to load the files and wants to improve performance. Which change is most likely to improve Snowpipe performance?

   • AConsolidate the small files into larger files (e.g., 10-50 MB) before uploading to S3.
   • BIncrease the size of the warehouse used by the pipe.
   • CEnable the PIPE_EXECUTION_TIMEOUT option to allow more time for loading.
   • DUse a scheduled task to run COPY INTO instead of Snowpipe.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   What is the primary purpose of a Snowpipe in Snowflake?

   • ATo manage user access and permissions
   • BTo automatically load data from staged files as soon as they arrive
   • CTo create external tables for querying data in place
   • DTo transform data using SQL functions during loading
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A data analyst sets up a Snowpipe to load JSON files from an S3 bucket. The analyst wants to be notified if the pipe fails to load files due to errors. Which feature should be used to monitor the pipe's health and receive alerts?

   • ASet up a Snowflake task that periodically checks the PIPE_STATUS and sends an email notification if the pipe is in an error state.
   • BConfigure the S3 bucket to send notifications to an email address.
   • CUse the COPY_HISTORY view to check for failed loads after the fact.
   • DEnable the ERROR_INTEGRATION option on the pipe.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A company uses Snowpipe to load CSV files from an Azure Blob Storage container. The files are uploaded by a legacy system that sometimes writes incomplete files and then overwrites them. The data analyst notices that some partial files are being loaded. What should the analyst do to prevent loading incomplete files?

   • AUse a file format with VALIDATE_UTF8 = TRUE to reject incomplete files.
   • BSet the PIPE_NOTIFICATION_INTEGRATION to only trigger on file rename events.
   • CSet the COPY INTO option ON_ERROR = 'SKIP_FILE' in the pipe definition.
   • DConfigure the legacy system to write files to a temporary folder and then move them to the main container after they are complete.
   Reveal Solution Discussion Select an answer first