Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-C02

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

Updated On: 16-Feb-2026
Page 12 of 221
PDF with 1300 Questions

True or False: When a data share is established between a Data Provider and a Data Consumer, the Data Consumer can extend that data share to other Data Consumers.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-intro.html



Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  1. Is available to all Snowflake Editions
  2. Is only available to customers with Business Critical Edition
  3. Restricts or enables access to specific IP addresses
  4. Is activated using an “ALTER DATABASE” command

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html



True or False: Snowflake charges additional fees to Data Providers for each Share they create.

  1. True
  2. False

Answer(s): B



Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

  1. 1 Hour
  2. 3 Hours
  3. 12 hours
  4. 24 hours

Answer(s): D


Reference:

https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse



A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  1. The tables are now orphaned
  2. The user that deleted the role
  3. SYSADMIN
  4. The assumed role that dropped the role

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/sql/drop-role.html






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

Join the COF-C02 Discussion