COF-C03 Data Collaboration Practice Question
A consumer account has mounted a shared database named partner_db. The consumer wants to create a local table that combines data from the shared database with their own data. What must the consumer do to create this new table?
⚠ Common exam trap
The trap here is assuming that a mounted shared database can be written to like a local database.
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
✓
Create the table in one of their own databases using CREATE TABLE my_db.public.combined AS SELECT ... FROM partner_db.public.table
Consumers can query shared databases but cannot create objects inside them. To combine shared data with local data, the consumer creates a new table in their own database using CREATE TABLE AS SELECT that reads from the shared database. This keeps ownership and write privileges with the consumer and avoids any attempt to modify the read-only shared database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create the table in one of their own databases using CREATE TABLE my_db.public.combined AS SELECT ... FROM partner_db.public.table
Why this is correct
Consumers can read from shared databases and write results into their own local databases. A CREATE TABLE AS SELECT statement referencing the shared database creates a new table owned by the consumer in their own schema. This is the standard pattern for combining shared data with local data, and it does not require any write privileges on the shared database.
- ✗
Create the table in the shared database using CREATE TABLE partner_db.public.combined AS SELECT ...
Why it's wrong here
Shared databases are read-only for consumers. Any attempt to create, alter, or drop objects inside a shared database fails with an error indicating the database is read-only or that the consumer lacks ownership. The consumer cannot write to the provider's database through the share, because shares only grant read access to specified objects and do not transfer ownership.
- ✗
Request that the provider grant INSERT privileges on the shared schema so the consumer can create a table there.
Why it's wrong here
Providers cannot grant write privileges such as INSERT or CREATE TABLE through a share. Shares are read-only by design, and only a limited set of privileges like SELECT, USAGE, and REFERENCES can be granted to a share. Even if the provider wanted to allow writes, the share mechanism does not support it, so this approach is not possible.
- ✗
Clone the shared database into their account and then create the table inside the clone.
Why it's wrong here
Cloning a shared database is not supported for consumer accounts. A shared database is a read-only reference to provider objects, and CLONE operations cannot be performed on it. The consumer would need to create their own database and copy data using CREATE TABLE AS SELECT or INSERT INTO ... SELECT, which achieves the same result without cloning.
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.