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

Questions 11–15

1. 11foundation · easy

   Which COPY INTO option allows you to skip a file entirely if any errors are encountered during loading?

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

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

   • ATo validate the permissions of the user running the COPY command
   • BTo validate the file format before creating a file format object
   • CTo check if the target table exists before loading
   • DTo test the load without actually inserting data into the table
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which component is required to set up Snowpipe for automatic loading from an external stage?

   • AA storage integration
   • BA file format object
   • CA virtual warehouse
   • DA notification integration
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A data analyst needs to load a very large dataset (several terabytes) from an external stage into Snowflake. The data is currently stored as many small uncompressed CSV files. The analyst wants to optimize the load performance and reduce cost. Which approach is the best practice?

   • ALoad the files as-is using COPY INTO with a large warehouse size.
   • BLoad the files into a single VARIANT column and then parse them later.
   • CUse Snowpipe to load the files continuously.
   • DConsolidate the small files into larger files (e.g., 100-250 MB) and compress them (e.g., gzip) before loading.
   Reveal Solution Discussion Select an answer first
6. 15expert · medium

   A data analyst is loading a large number of CSV files from an external stage. The analyst wants to ensure data quality by validating that all rows meet certain criteria before loading. The analyst also wants to avoid loading any data if the validation fails. Which approach should be used?

   • AUse the VALIDATE function to check the files before running COPY INTO, and only load if validation passes.
   • BLoad the data into a staging table and then run validation queries before inserting into the final table.
   • CUse ON_ERROR = 'ABORT_STATEMENT' in COPY INTO to stop the load if any row fails.
   • DUse a file format with STRIP_NULL_VALUES = TRUE to remove invalid rows.
   Reveal Solution Discussion Select an answer first