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

Questions 6–10

1. 6foundation · easy

   Which clause of the COPY INTO command is used to specify how errors encountered during data loading should be handled?

   • AON_ERROR
   • BPURGE
   • CVALIDATION_MODE
   • DFILE_FORMAT
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which command is used to create a named stage in Snowflake?

   • ACREATE STAGE
   • BCREATE PIPE
   • CCREATE TABLE
   • DCREATE FILE FORMAT
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   An organization stores historical sales data in Parquet files in Azure Blob Storage. The data analyst needs to query this data directly from Snowflake without loading it into a table, and the data is updated daily. The analyst wants to avoid maintaining a separate copy of the data. Which approach should be used?

   • AUse Snowpipe to continuously load the Parquet files into a Snowflake table.
   • BCreate an external stage referencing the Blob Storage container and create an external table over the Parquet files.
   • CCreate an internal stage and load the Parquet files into a Snowflake table using COPY INTO.
   • DCreate a file format object and use the GET command to download files to the local machine.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which data ingestion method is best suited for loading large historical datasets into Snowflake in a single, scheduled operation?

   • ABulk loading with COPY INTO
   • BContinuous loading with Snowpipe
   • CExternal table querying
   • DData sharing
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A data analyst is loading a CSV file that contains a date column in the format 'MM/DD/YYYY' and a numeric column stored as text. The target table expects dates in 'YYYY-MM-DD' format and numeric values as NUMBER. The analyst wants to transform the data during the COPY INTO operation. Which approach should be used?

   • ALoad the data as-is into a staging table and then run UPDATE statements to fix the formats.
   • BUse a file format with DATE_FORMAT and NUMBER_FORMAT options to automatically convert the data.
   • CUse a SELECT statement in the COPY INTO command that applies TO_DATE and TO_NUMBER functions to the staged columns.
   • DLoad the data into a VARIANT column and then use FLATTEN to extract the values.
   Reveal Solution Discussion Select an answer first