COF-C03 Data Collaboration Practice Question
A data provider at a healthcare analytics company wants to share live patient-readmission metrics with a partner hospital. The partner must query the data with low latency and the provider must retain full ownership and control of the underlying tables. The provider creates a share and grants USAGE on a secure view to the share. Which action must the provider perform next so the partner account can mount and query the shared data?
⚠ Common exam trap
The trap here is assuming that granting object privileges to a share is sufficient, when the share must also be associated with the consumer's account before any data is visible.
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
✓
Add the partner's account to the share using ALTER SHARE ... ADD ACCOUNTS.
For a direct share, the provider grants object privileges to the share, then associates the consumer account with the share. The consumer then creates a database from the share to query it. Adding the account is mandatory because privileges alone do not cross account boundaries; the share must be explicitly bound to the consumer's account before it can be mounted.
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 a database from the share in the provider account and grant USAGE to the partner.
Why it's wrong here
Creating a database from a share is a consumer-side action, not a provider-side step. The provider cannot create the shared database on behalf of the partner, and doing so in the provider account would not expose data to the partner. The partner must run CREATE DATABASE ... FROM SHARE after being added.
- ✗
Publish the share as a listing on the Snowflake Marketplace.
Why it's wrong here
Marketplace listings are for broad, discoverable distribution and are unnecessary for a single named partner. Direct sharing via account association is the appropriate mechanism here. Publishing a listing would not replace the need to add the specific consumer account for a private, targeted share.
- ✓
Add the partner's account to the share using ALTER SHARE ... ADD ACCOUNTS.
Why this is correct
A share becomes consumable only after the provider account is associated with a consumer account. ALTER SHARE ... ADD ACCOUNTS binds the share to the partner's Snowflake account identifier, allowing the consumer to create a database from the share. Until this association exists, the granted objects are inaccessible regardless of privileges.
- ✗
Grant the CONSUME privilege on the share to the partner's account.
Why it's wrong here
CONSUME is not a valid privilege for sharing in Snowflake. Consumer access is established by adding the consumer account to the share, not by granting a privilege. This distractor confuses share access with standard role-based privilege grants, which do not apply across account boundaries in this way.
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.