Free COF-C02 Exam Braindumps
SnowPro Core Questions 321–325 (page: 66)

Updated On: 10-Feb-2026

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  1. Files
  2. External tables
  3. Secure User-Defined Functions (UDFs)
  4. Sequences
  5. Streams

Answer(s): B,C



Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

  1. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
  2. A Data Exchange allows groups of accounts to share data privately among the accounts.
  3. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
  4. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
  5. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

Answer(s): B



A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

  1. No virtual warehouse will be used, data will be read from the result cache.
  2. No virtual warehouse will be used, data will be read from the local disk cache.
  3. The default virtual warehouse will be used to read all data.
  4. The virtual warehouse that is defined at the session level will be used to read all data.

Answer(s): A



Which feature allows a user the ability to control the organization of data in a micro-partition?

  1. Range Partitioning
  2. Search Optimization Service
  3. Automatic Clustering
  4. Horizontal Partitioning

Answer(s): C



Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

  1. CREATE_SHARE on the account
  2. SHARE on databases and schemas
  3. SELECT on tables used by the secure view
  4. REFERENCE_USAGE on databases

Answer(s): D



Viewing page 66 of 221
Viewing questions 326 - 330 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!