COF-C03 Data Collaboration Practice Question
A consumer has mounted a shared database named 'SALES_DATA_SHARED'. They need to add a new column to one of the tables in this database to store local annotations. Which statement best describes the outcome if they attempt this?
⚠ Common exam trap
Candidates often think they can perform local transformations on shared data, failing to realize that shared databases are strictly read-only and cannot be modified by 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 operation will fail because shared databases are read-only for consumers.
Shared databases in Snowflake are strictly read-only for the consumer. The consumer cannot perform any Data Definition Language (DDL) operations like ALTER TABLE, nor any Data Manipulation Language (DML) operations like INSERT or UPDATE on the shared objects. This architecture ensures the integrity of the provider's data and maintains a single version of truth across all consumers.
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 operation will succeed, but the changes will only be visible to the consumer's account.
Why it's wrong here
Snowflake does not support 'local writes' or branching for shared databases. If a consumer needs to modify or annotate the data, they must first copy the data into a local table within their own database. Shared data is provided as a read-only stream, and any attempt to modify its structure or content will fail.
- ✓
The operation will fail because shared databases are read-only for consumers.
Why this is correct
Any DDL or DML attempt on a shared database results in an error. The read-only nature is a fundamental security and architectural constraint of Snowflake's sharing model. This ensures that the provider remains the sole authority for the data and that the consumer's role is limited to data analysis and retrieval.
- ✗
The operation will succeed only if the provider has granted the 'MODIFY' privilege to the share.
Why it's wrong here
There is no 'MODIFY' privilege that can be granted to a share. Snowflake's sharing implementation intentionally excludes the ability for consumers to write back to the provider's data structures. This design prevents complex locking issues, security vulnerabilities, and potential data corruption that would arise from allowing external accounts to alter provider objects.
- ✗
The operation will fail unless the consumer is using the 'ACCOUNTADMIN' role.
Why it's wrong here
The read-only restriction on shared databases applies regardless of the role used by the consumer. Even an ACCOUNTADMIN in the consumer account cannot bypass the read-only status of a shared database. The restriction is enforced at the database level based on its origin as a mount point for a share.
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.