COF-C03 Data Collaboration Practice Question
A consumer account has created a database from a share provided by a partner. The consumer wants to ensure that when the provider adds new tables to the share, those tables become available in the consumer's shared database without any manual intervention. Which statement accurately describes the behavior of shared databases in Snowflake?
⚠ Common exam trap
The trap here is thinking that shared databases require manual refresh or recreation to see new objects, when in fact they are automatically synchronized.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
New tables added to the share by the provider are automatically available in the consumer's shared database.
Shared databases are automatically updated when the provider adds new objects to the share. The consumer does not need to refresh, recreate, or grant additional privileges. The provider's grant of SELECT on a new table to the share makes it immediately available in the consumer's shared database. This real-time propagation is a fundamental characteristic of Snowflake Data Sharing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The consumer must recreate the shared database to see new tables added by the provider.
Why it's wrong here
Recreating the shared database is unnecessary and disruptive. Snowflake automatically propagates changes to shared databases, including new tables, views, and other objects, as soon as the provider grants privileges on them to the share. The consumer does not need to drop and recreate the database. This option would cause unnecessary downtime and is not required.
- ✓
New tables added to the share by the provider are automatically available in the consumer's shared database.
Why this is correct
Shared databases in Snowflake are dynamic. When a provider grants SELECT on a new table to a share, that table immediately becomes visible and queryable in the consumer's shared database. No action is required from the consumer. This automatic synchronization is a key benefit of Snowflake Data Sharing, enabling real-time access to provider data without manual refreshes or recreation.
- ✗
The consumer must grant SELECT on the new tables to their own roles before they can be queried.
Why it's wrong here
In a shared database, the provider controls access by granting privileges on objects to the share. The consumer cannot grant privileges on shared objects to their own roles; they can only grant USAGE on the shared database and its schemas to their roles. The provider's grants to the share determine which objects are visible. This option misconstrues the privilege model for shared databases.
- ✗
The consumer must run ALTER DATABASE ... REFRESH to pull new objects from the share.
Why it's wrong here
There is no ALTER DATABASE ... REFRESH command for shared databases. Shared databases are automatically updated when the provider modifies the share. The consumer does not need to run any refresh command. This option describes a nonexistent operation and would not achieve the desired automatic synchronization.
About these practice questions
Courseiva writes every COF-C03 question from scratch — 280 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.