Free COF-C02 Exam Braindumps
SnowPro Core Questions 381–385 (page: 78)

Updated On: 10-Feb-2026

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

  1. Query execution
  2. Data loading
  3. Time Travel data
  4. Security
  5. Authentication and access control

Answer(s): D,E



What is a responsibility of Snowflake’s virtual warehouses?

  1. Infrastructure management
  2. Metadata management
  3. Query execution
  4. Query parsing and optimization
  5. Permanent storage of micro-partitions

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20required,rows%20from%20tables%20and%20views)



What features does Snowflake Time Travel enable?

  1. Querying data-related objects that were created within the past 365 days
  2. Restoring data-related objects that have been deleted within the past 90 days
  3. Conducting point-in-time analysis for BI reporting
  4. Analyzing data usage/manipulation over all periods of time

Answer(s): B



Which of the following statements describes a schema in Snowflake?

  1. A logical grouping of objects that belongs to a single database
  2. A logical grouping of objects that belongs to multiple databases
  3. A named Snowflake object that includes all the information required to share a database
  4. A uniquely identified Snowflake account within a business entity

Answer(s): A



What is the recommended compressed file size range for continuous data loads using Snowpipe?

  1. 8-16 MB
  2. 16-24 MB
  3. 10-99 MB
  4. 100-250 MB

Answer(s): D



Viewing page 78 of 221
Viewing questions 386 - 390 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!