Free COF-C02 Exam Braindumps
SnowPro Core Questions 351–355 (page: 72)

Updated On: 10-Feb-2026

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

  1. Caching query results
  2. Running EXPLAIN and SHOW commands
  3. Cloning a database
  4. Running a custom query
  5. Running COPY commands

Answer(s): D,E



When loading data into Snowflake, the COPY command supports which of the following?

  1. Joins
  2. Filters
  3. Column reordering
  4. Aggregates

Answer(s): C



What is cached during a query on a virtual warehouse?

  1. All columns in a micro-partition
  2. Any columns accessed during the query
  3. The columns in the result set of the query
  4. All rows accessed during the query

Answer(s): B



What is the default character set used when loading CSV files into Snowflake?

  1. UTF-8
  2. UTF-16
  3. ISO 8859-1
  4. ANSI_X3.4

Answer(s): A


Reference:

https://snowflakesolutions.net/semi-structured-json-data/#:~:text=FILE%20FORMAT&text=The%20STRIP_OUTER_ARRAY%20array%20option%20removes,row%20in%20the%20destination%20table



Which of the following describes external functions in Snowflake?

  1. They are a type of User-defined Function (UDF).
  2. They contain their own SQL code.
  3. They call code that is stored inside of Snowflake.
  4. They can return multiple rows for each row received.

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake



Viewing page 72 of 221
Viewing questions 356 - 360 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!