Configure Stages and File Formats SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A company loads CSV files that sometimes have extra columns not present in the target table. They want the load to succeed and ignore the extra columns. What file format option should they configure?

   • AFIELD_OPTIONALLY_ENCLOSED_BY = '"'
   • BNULL_IF = ('')
   • CSKIP_HEADER = 1
   • DERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A company is designing a data lake architecture in Snowflake. They have a mix of structured and semi-structured data. They want to choose file formats that balance performance and cost. What is the best practice?

   • AUse ORC for all data because it is similar to Parquet.
   • BUse Avro for all data because it is compact.
   • CUse CSV for all data because it is universally supported.
   • DUse Parquet for structured data and JSON for semi-structured data.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which SQL command is used to create an internal named stage in Snowflake?

   • ACREATE OR REPLACE STAGE my_stage
   • BCREATE INTERNAL STAGE my_stage
   • CCREATE STAGE my_stage
   • DCREATE NAMED STAGE my_stage
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company uses an external stage to load data from an S3 bucket. The stage was created with a storage integration. A new analyst needs to load data from this stage but should not be able to modify the stage definition. What is the minimal privilege to grant?

   • AREAD on the stage
   • BOWNERSHIP on the stage
   • CUSAGE on the stage
   • DCREATE STAGE on the schema
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which file format is columnar and optimized for analytical queries in Snowflake?

   • AXML
   • BJSON
   • CCSV
   • DParquet
   Reveal Solution Discussion Select an answer first