COF-C03 Data Collaboration Practice Question
A provider uses a reader account to share data with a client that does not have its own Snowflake account. The client now reports that it cannot see newly added tables that the provider granted to the share. The provider confirms the new tables were added to the share with SELECT grants. Which statement explains why the client cannot see the new tables?
⚠ Common exam trap
The trap here is assuming that SELECT on a newly added table is enough, when the share also needs USAGE on the schema that contains it.
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
✓
The provider must grant USAGE on the schema containing the new tables to the share.
For any table to be visible through a share, the share needs USAGE on the table's database and schema in addition to SELECT on the table. If the new tables reside in a schema that was never granted to the share, the consumer cannot see them. Granting the missing schema-level USAGE makes the new tables appear to the reader account without recreating anything.
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 reader account's shared database must be recreated to pick up new tables.
Why it's wrong here
A shared database does not need to be dropped and recreated when tables are added to the share. The consumer database reflects the share's current contents; new grants become visible without recreation. Recreating the database would disrupt the client unnecessarily and is not the correct remedy.
- ✗
Reader accounts require a separate share for each new table.
Why it's wrong here
A reader account consumes the same share as a normal consumer; there is no requirement to create a new share per table. Newly granted tables appear automatically once the share is updated and the reader account refreshes its view of the shared database. This distractor invents an administrative overhead that does not exist.
- ✓
The provider must grant USAGE on the schema containing the new tables to the share.
Why this is correct
Adding tables to a share requires that the share also holds USAGE on the containing database and schema. If the new tables live in a schema not yet granted to the share, the consumer cannot see them even though SELECT was granted on the tables themselves. Adding the missing USAGE grant resolves the issue.
- ✗
Reader accounts can only query tables that existed when the reader account was created.
Why it's wrong here
Reader accounts are not frozen to the initial share contents; they see whatever the share currently exposes. New tables become queryable once the appropriate grants are in place. This distractor misstates reader account behavior and would lead a provider to wrongly rebuild the reader account instead of fixing grants.
About these practice questions
One of 280 original COF-C03 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.