Free COF-C02 Exam Braindumps
SnowPro Core Questions 376–380 (page: 77)

Updated On: 10-Feb-2026

Which of the following can be executed/called with Snowpipe?

  1. A User Defined Function (UDF)
  2. A stored procedure
  3. A single COPY_INTO statement
  4. A single INSERT_INTO statement

Answer(s): C



Which snowflake objects will incur both storage and cloud compute charges? (Choose two.)

  1. Materialized view
  2. Sequence
  3. Secure view
  4. Transient table
  5. Clustered table

Answer(s): A,E



What file formats does Snowflake support for loading semi-structured data? (Choose three.)

  1. TSV
  2. JSON
  3. PDF
  4. Avro
  5. Parquet
  6. JPEG

Answer(s): B,D,E


Reference:

https://docs.snowflake.com/en/user-guide/semistructured-intro.html#:~:text=Snowflake%20can%20import%20semi%2Dstructured,to%20support%20semi%2Dstructured%20data



Which of the following statements about data sharing are true? (Choose two.)

  1. New objects created by a Data Provider are automatically shared with existing Data Consumers and Reader Accounts.
  2. All database objects can be included in a shared database.
  3. Reader Accounts are created by Data Providers.
  4. Shared databases are read-only.
  5. Reader Accounts are charged for warehouse usage.

Answer(s): C,D



Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

  1. The number of queries executed
  2. The number of active users assigned to the warehouse
  3. The size of the virtual warehouse
  4. The length of time the warehouse is running
  5. The duration of the queries that are executed

Answer(s): C,D



Viewing page 77 of 221
Viewing questions 381 - 385 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!