COF-C03 Data Collaboration Practice Question
A provider has shared a database with a consumer. The consumer reports that they can see the shared database but cannot query any tables because they get an error about insufficient privileges. The provider used the following command to create the share: CREATE SHARE MY_SHARE; then added a database and a table to the share. The provider also granted USAGE on the database and SELECT on the table to a role named SHARE_ROLE, and then granted SHARE_ROLE to MY_SHARE. What is the most likely cause of the consumer's issue?
⚠ Common exam trap
The trap here is assuming that granting USAGE on the database and SELECT on the table is sufficient, forgetting that schema-level USAGE is also mandatory for any object access within that schema.
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 also grant USAGE on the schema containing the table to SHARE_ROLE.
To share a table, the provider must grant USAGE on the database, USAGE on the schema, and SELECT on the table to the share. The scenario omits the schema usage grant, which is required for the consumer to access objects within that schema. Without it, queries will fail with insufficient privileges. Adding the schema usage grant resolves the issue.
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 provider must also grant USAGE on the schema containing the table to SHARE_ROLE.
Why this is correct
In Snowflake, to grant access to a table in a share, the provider must grant USAGE on the database, USAGE on the schema, and SELECT on the table to the share. The scenario mentions granting USAGE on the database and SELECT on the table, but not USAGE on the schema. Without schema usage, the consumer cannot access the table, resulting in an insufficient privileges error.
- ✗
The consumer must create a database from the share before they can query the tables.
Why it's wrong here
The consumer must create a database from the share to access the data, but the scenario implies they already see the shared database, which means they have created it. The error occurs when querying tables, so the issue is likely within the share's privileges, not the consumer's database creation step.
- ✗
The share was not granted to the consumer account using ALTER SHARE ... ADD ACCOUNT.
Why it's wrong here
If the share was not granted to the consumer account, the consumer would not be able to see the shared database at all. The scenario states that the consumer can see the database, so the share must have been granted to the consumer account. Therefore, this is not the cause of the privilege error.
- ✗
The provider must use a secure view instead of a table to share data.
Why it's wrong here
While secure views are often used to share data with fine-grained control, they are not mandatory. Tables can be shared directly. The error is about insufficient privileges, not about the type of object. The missing schema usage grant is the likely cause, not the absence of a secure view.
Visual reference
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.