COF-C03 Data Collaboration Practice Question
A provider wants to share a dynamic table with a consumer. The dynamic table is defined on a base table that is not shared. What must the provider ensure for the consumer to query the dynamic table?
⚠ Common exam trap
The trap here is assuming the consumer needs access to the base table, when dynamic tables execute with the owner's rights.
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 dynamic table must be added to the share, and the dynamic table owner must have the necessary privileges on the base table.
Dynamic tables can be shared directly. The consumer queries the dynamic table, which executes with the owner's privileges. The provider must add the dynamic table to the share and ensure the owner has SELECT on the base table. The consumer does not need any privileges on the base table. This allows sharing of transformed data without exposing the source.
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 must grant SELECT on the base table to the share.
Why it's wrong here
Granting SELECT on the base table to the share would allow the consumer to query the base table directly, which is not desired. Dynamic tables are shared as independent objects; the consumer does not need access to the base table. The provider must instead share the dynamic table and ensure the dynamic table owner has access to the base table.
- ✗
The dynamic table must be refreshed before sharing.
Why it's wrong here
Refreshing the dynamic table ensures it has current data, but it does not address the access requirements. The consumer still needs the dynamic table to be shared, and the provider must have the necessary privileges. Refreshing alone does not grant access. The key is to include the dynamic table in the share and ensure the provider's role has access to the base table.
- ✗
The consumer must be granted the ability to refresh the dynamic table.
Why it's wrong here
Consumers cannot refresh dynamic tables; refresh is managed by the provider. Granting such a privilege is not possible and would be a security risk. The consumer only needs to query the dynamic table. The provider is responsible for ensuring the dynamic table is refreshed and that the owner has access to the base table. This option misinterprets the refresh model.
- ✓
The dynamic table must be added to the share, and the dynamic table owner must have the necessary privileges on the base table.
Why this is correct
Dynamic tables can be shared like regular tables. The consumer queries the dynamic table directly, and it executes with the owner's privileges. Therefore, the provider must add the dynamic table to the share and ensure the dynamic table owner has SELECT on the base table. The consumer does not need access to the base table.
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.