Configure Stages, File Formats, and Connectors DEA-C02 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   When a COPY INTO command fails due to a file format mismatch, what is a common troubleshooting step?

   • ADrop and recreate the table.
   • BRestart the virtual warehouse.
   • CGrant more privileges on the stage.
   • DCheck the file format options against the actual file structure.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   In a COPY INTO statement, which clause is used to specify the file format to use for parsing the source files?

   • AVALIDATION_MODE = 'RETURN_ERRORS'
   • BFILE_FORMAT = (FORMAT_NAME = 'my_csv')
   • CSTAGE = 'my_stage'
   • DPATTERN = '.*.csv'
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which connector would a data engineer use to load data from a Spark DataFrame into Snowflake?

   • ASnowflake Connector for Kafka
   • BSnowflake Connector for Python
   • CSnowflake ODBC Driver
   • DSnowflake Connector for Spark
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Snowflake connector is used to stream data from Apache Kafka into Snowflake?

   • ASnowflake Connector for Python
   • BSnowflake ODBC Driver
   • CSnowflake Connector for Spark
   • DSnowflake Connector for Kafka
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which file format option would you use to skip the first line of a CSV file that contains column headers?

   • ARECORD_DELIMITER = '\n'
   • BNULL_IF = ('NULL')
   • CSKIP_HEADER = 1
   • DFIELD_DELIMITER = ','
   Reveal Solution Discussion Select an answer first