COF-C03 Data Collaboration Practice Question
A consumer has created a database from a share provided by a partner. The consumer wants to allow a specific role, ANALYST_ROLE, to query the shared data. Which privilege must the consumer grant to ANALYST_ROLE on the shared database?
⚠ Common exam trap
The trap here is assuming that granting USAGE on the database is sufficient, but USAGE only allows visibility of the database, not querying of its objects.
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
✓
IMPORTED PRIVILEGES
To allow a role to query data in a database created from a share, the consumer must grant the IMPORTED PRIVILEGES privilege on that database to the role. This privilege grants access to the shared objects, including SELECT on tables and views. It is the correct and only privilege that enables access to shared data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
OWNERSHIP
Why it's wrong here
OWNERSHIP on a shared database cannot be granted to a role; the database is owned by the share and is read-only. Granting OWNERSHIP is not possible and would not be appropriate. The consumer should grant IMPORTED PRIVILEGES to allow querying.
- ✓
IMPORTED PRIVILEGES
Why this is correct
When a consumer creates a database from a share, they must grant the IMPORTED PRIVILEGES privilege on that database to roles that need access. This privilege allows the role to access the shared objects as if they were local, including querying tables and views. It is the standard way to enable access to shared data.
- ✗
USAGE
Why it's wrong here
USAGE on the database allows a role to see the database and its schemas, but it does not grant the ability to query tables or views. To query the shared data, the role also needs SELECT privileges on the objects or IMPORTED PRIVILEGES on the database. Granting only USAGE would not suffice.
- ✗
SELECT
Why it's wrong here
SELECT on the database is not a valid privilege. SELECT is granted on specific objects like tables, views, and stages. To allow querying of all objects in the shared database, the consumer should grant IMPORTED PRIVILEGES on the database, which encompasses the necessary SELECT privileges on the shared objects.
About these practice questions
This COF-C03 question is part of Courseiva's 280-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.