COF-C03 Data Collaboration Practice Question
A provider shares a database with a consumer using a direct share. The consumer reports that queries against the shared database fail with an error indicating the database does not exist, even though the share was successfully created and granted to the consumer account. The provider confirmed that the share contains the necessary tables and that the consumer account has been added to the share. What is the most likely cause of the issue?
⚠ Common exam trap
The trap here is assuming that granting the share to the consumer account automatically makes the data available without the consumer creating a database from the share.
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 consumer has not created a database from the share using CREATE DATABASE ... FROM SHARE.
For a consumer to access a direct share, they must create a database from the share using CREATE DATABASE ... FROM SHARE. The provider's role is to create the share, grant privileges on objects to the share, and add the consumer account. The consumer must then mount the share by creating a database. Without this step, the shared database is not visible, leading to errors when querying.
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 did not grant the USAGE privilege on the database to the consumer's role.
Why it's wrong here
In a direct share, the provider grants privileges to the share itself, not directly to the consumer's roles. The consumer's roles are granted access through the share when the database is created. Therefore, missing USAGE on the database from the provider is not the cause; the consumer must create the database from the share first.
- ✗
The consumer's account is in a different region than the provider's account, and cross-region sharing is not enabled.
Why it's wrong here
Cross-region sharing is supported in Snowflake, but it requires the provider to enable it and may involve replication. However, the error 'database does not exist' typically indicates the consumer has not created the database from the share yet. Region differences would produce different errors, such as replication or connectivity issues, not a missing database.
- ✗
The provider did not include a secure view in the share, so the consumer cannot access the tables.
Why it's wrong here
Secure views are not required for sharing; regular tables and views can be shared. The absence of a secure view would not cause a 'database does not exist' error. The error points to the consumer not having created the database from the share, which is a mandatory step for accessing shared data.
- ✓
The consumer has not created a database from the share using CREATE DATABASE ... FROM SHARE.
Why this is correct
A share makes data available, but the consumer must explicitly create a database from the share using CREATE DATABASE ... FROM SHARE. Until that step is performed, the shared database does not appear in the consumer's account, causing 'database does not exist' errors. The provider cannot create the database on behalf of the consumer because the share is mounted in the consumer's account.
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.