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

Questions 11–15

1. 11foundation · easy

   Which SQL command loads data from files in a stage into a Snowflake table?

   • AINSERT INTO table FROM @stage
   • BMERGE INTO table FROM @stage
   • CLOAD DATA INTO table FROM @stage
   • DCOPY INTO table FROM @stage
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   In a COPY INTO command, which clause specifies the file format to use for parsing the files?

   • ATYPE = 'my_format'
   • BFORMAT = (FORMAT_NAME = 'my_format')
   • CFILE_FORMAT = (FORMAT_NAME = 'my_format')
   • DSTAGE_FILE_FORMAT = 'my_format'
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which of the following file formats is considered semi-structured in Snowflake?

   • AParquet
   • BCSV
   • CORC
   • DJSON
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A data analyst needs to load files that are shared across multiple users in a team. Which type of Snowflake stage is designed for this purpose?

   • AInternal named stage
   • BUser stage
   • CExternal stage
   • DTable stage
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which file format option controls how Snowflake handles errors during data loading?

   • AERROR_INTEGRATION
   • BCOMPRESSION
   • CENCODING
   • DON_ERROR
   Reveal Solution Discussion Select an answer first