COF-C03 Data Collaboration Practice Question
A provider wants to share data with a consumer using a Direct Share. Which two statements accurately describe the consumer's experience after the share is mounted? (Choose two.)
⚠ Common exam trap
The trap here is conflating ownership of the mounted database with write access to its contents, when shared databases are strictly read-only for the consumer.
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 can view the share's objects without any additional storage cost for the shared data.
With Direct Sharing, the consumer mounts a read-only database and queries it using their own compute. Storage remains with the provider, so the consumer incurs no storage cost for the shared data. The consumer cannot modify shared objects or add objects inside the shared database, which distinguishes sharing from copying 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.
- ✓
The consumer can view the share's objects without any additional storage cost for the shared data.
Why this is correct
Because shared data stays in the provider's storage, the consumer incurs no storage charges for the shared data itself. The consumer only pays for compute used to query it. This cost model is a key benefit of Snowflake sharing and is accurately described in this statement.
- ✗
The consumer can modify the shared data directly because they own the mounted database.
Why it's wrong here
A database created from a share is read-only. The consumer does not own the underlying data and cannot perform DML operations on shared tables or views. Ownership of the mounted database object does not confer write access to the shared content, so this statement is incorrect.
- ✗
The consumer must copy the shared data into their own tables before querying it.
Why it's wrong here
Copying is not required and defeats the purpose of sharing. Consumers query shared data in place, and the data remains in the provider's storage. While consumers can choose to copy data if they want to modify it, that is optional and not a requirement for querying the share.
- ✓
The consumer can query shared data using their own virtual warehouses.
Why this is correct
Shared data resides in the provider's storage, but queries against a mounted share execute on the consumer's virtual warehouses. This means the consumer pays for the compute used to query the shared data, while the provider pays for storage. This is a fundamental characteristic of Snowflake sharing and is correctly described here.
- ✗
The consumer can create their own tables in the same schema as the shared objects.
Why it's wrong here
Databases created from shares are read-only at the schema level as well. Consumers cannot create new objects such as tables or views inside the shared database or its schemas. They can create separate databases and join against shared data, but not add objects within the shared database itself.
About these practice questions
Courseiva writes every COF-C03 question from scratch — 280 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.