COF-C03 Data Collaboration Practice Question
A provider has created a share and granted SELECT on a table to the share. The provider now wants to allow the consumer to query the table but also wants to ensure that the consumer cannot see the table's columns that contain personal data. The provider decides to create a secure view that excludes the sensitive columns and grants SELECT on the view to the share. The provider does NOT grant SELECT on the base table to the share. What will the consumer experience when querying the shared view?
⚠ Common exam trap
The trap here is thinking that consumers need privileges on base tables to query a shared view.
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 query the view successfully and will see only the non-sensitive columns.
A shared secure view executes with the owner's privileges, so the consumer does not need privileges on the base table. The view definition excludes sensitive columns, and the secure property hides that definition. As a result, the consumer can query the view and see only the non-sensitive columns. Granting SELECT on the base table is unnecessary and would actually expose the sensitive 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 must be granted SELECT on the base table for the view to return results, but this would expose the sensitive columns.
Why it's wrong here
Granting SELECT on the base table is not necessary for the view to work. The view uses the owner's privileges, so the consumer can query it without any direct access to the base table. If the provider did grant SELECT on the base table to the share, the consumer would be able to query the base table directly and see the sensitive columns, which is precisely what the provider wants to avoid.
- ✗
The consumer will receive an error because they lack privileges on the base table referenced by the view.
Why it's wrong here
Privileges on base tables are not required for consumers querying a shared view. The view executes with the owner's rights, meaning the provider's privileges on the base table are used. The consumer only needs SELECT on the view itself, which was granted to the share. Therefore, the query succeeds and returns the view's results without any privilege error.
- ✓
The consumer can query the view successfully and will see only the non-sensitive columns.
Why this is correct
A secure view executes with the owner's privileges, so the consumer does not need SELECT on the base table. The view's definition excludes the sensitive columns, and its results only include the projected columns. The consumer can query the view and see the non-sensitive data. The secure property hides the view definition, preventing the consumer from discovering the excluded columns through metadata.
- ✗
The consumer can query the view but will also be able to see the sensitive columns because the view is not secure.
Why it's wrong here
The scenario states the provider created a secure view. A secure view hides its definition and prevents consumers from seeing the underlying SQL, which would reveal the sensitive columns. Even if the view were not secure, the consumer would only see the columns projected by the view, not the base table columns. The secure property adds protection by hiding the view definition itself.
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.