Snowflake COF-C02 Exam Questions
SnowPro Core (Page 40 )

Updated On: 17-Feb-2026

What is the default file size when unloading data from Snowflake using the COPY command?

  1. 5 MB
  2. 8 GB
  3. 16 MB
  4. 32 MB

Answer(s): C



What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

  1. Row level access policies
  2. Data masking policies
  3. Data encryption
  4. Time Travel
  5. External tokenization

Answer(s): C,D



Which Snowflake layer is always leveraged when accessing a query from the result cache?

  1. Metadata
  2. Data Storage
  3. Compute
  4. Cloud Services

Answer(s): D



Which connectors are available in the downloads section of the Snowflake web interface (UI)? (Choose two.)

  1. SnowSQL
  2. JDBC
  3. ODBC
  4. HIVE
  5. Scala

Answer(s): B,C



A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

  1. Use data encryption.
  2. Use dynamic data masking.
  3. Use secure materialized views.
  4. Revoke all roles for functional managers and end users.

Answer(s): B






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

Join the COF-C02 Discussion