COF-C03 Data Collaboration Practice Question
A provider has created a share and added a table. The consumer reports that they can see the shared database and schema but cannot see the table. The provider confirms the table was added with ALTER SHARE ... ADD TABLE. Which additional privilege must the provider grant to the share so the consumer can query the table?
⚠ Common exam trap
The trap here is believing that adding an object to a share implicitly grants the privileges needed to query it, when SELECT must be granted to the share explicitly.
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
✓
SELECT on the table, granted to the share.
When a table is added to a share, the provider must also grant SELECT on that table to the share. The consumer already has visibility of the database and schema, so the missing element is table-level read access. Granting SELECT to the share is the documented step that enables queries. Other privileges like USAGE, REFERENCES, or OWNERSHIP do not provide the needed row-level read permission.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
REFERENCES on the table, granted to the share.
Why it's wrong here
REFERENCES allows a role to create a foreign key referencing a table; it does not permit reading data. Sharing is about consumption, and the consumer needs to read rows. Granting REFERENCES to a share would not enable SELECT queries, and it is not a privilege used for data sharing. The correct privilege is SELECT.
- ✓
SELECT on the table, granted to the share.
Why this is correct
Adding a table to a share does not automatically grant SELECT on it. The provider must explicitly grant SELECT on the table to the share. Without this, the consumer can navigate to the table but queries fail with an authorization error. This is the standard step after ALTER SHARE ... ADD TABLE, and it is required for data access.
- ✗
OWNERSHIP on the table, transferred to the share.
Why it's wrong here
Ownership cannot be granted to a share, and transferring ownership would give the share control over the table, which is not how sharing works. Shares receive specific privileges such as SELECT or USAGE. Attempting to transfer ownership is invalid and would not be the intended solution for consumer read access.
- ✗
USAGE on the database and schema containing the table, granted to the share.
Why it's wrong here
USAGE on the database and schema is required for the consumer to see the shared database and schema at all, but the scenario states they already see those. The missing piece is access to the table itself. Granting USAGE again would not resolve the inability to query. The share needs SELECT on the table to make data visible.
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.