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

Questions 16–20

1. 16foundation · easy

   In a COPY INTO command, which option allows you to load only specific columns from a staged file into a target table?

   • APATTERN
   • BFILES
   • CCOLUMN_MAPPING
   • DSELECT statement
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which Snowflake feature is specifically designed to automatically load data from staged files as soon as new files arrive in a cloud storage location?

   • ACOPY INTO
   • BSnowpipe
   • CData sharing
   • DExternal table
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which practice is recommended to optimize data loading performance in Snowflake?

   • AUse external tables instead of loading data
   • BSplit large files into smaller files of a few hundred MB or less
   • CUse uncompressed files to avoid CPU overhead
   • DLoad all data in a single large file to minimize overhead
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A data analyst needs to load Avro files from an external stage into a Snowflake table. The Avro files contain nested records and arrays. The analyst wants to extract specific fields from the nested structure during the load. Which approach should be used?

   • ALoad the Avro files into a VARIANT column and then use LATERAL FLATTEN to extract the nested fields.
   • BUse a file format with STRIP_OUTER_ARRAY = TRUE and load directly into columns.
   • CUse COPY INTO with a SELECT that references the nested fields directly using dot notation.
   • DConvert the Avro files to CSV before loading.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which cloud storage services can be used as external stages in Snowflake?

   • AAmazon S3 and Azure Blob Storage only
   • BAmazon S3 only
   • CAny cloud storage service
   • DAmazon S3, Azure Blob Storage, and Google Cloud Storage
   Reveal Solution Discussion Select an answer first