DEA-C02 Data Movement Practice Question
An analytics team wants to let external partners query a curated set of rows from a Snowflake table through a secure share. The partners use their own Snowflake accounts and must not be able to see any rows outside the curated set. Which approach should the data engineer use?
⚠ Common exam trap
The trap here is assuming that a row access policy attached to a shared base table enforces row filtering for external consumers, when sharing a secure view is the reliable control.
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
✓
Create a secure view that filters the base table, grant the share access to the view, and add the view to the share.
Secure views are the supported way to expose a constrained subset of data in a share. Because the view definition is hidden and the base table is not shared, consumers can query only the curated rows. This satisfies both the access requirement and the restriction that partners must not see the full table.
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 secure view that filters the base table, grant the share access to the view, and add the view to the share.
Why this is correct
A secure view hides its definition and the underlying base table from consumers, and sharing the view rather than the table restricts partners to exactly the rows the view exposes. This is the standard pattern for row-level curation in a share and prevents consumers from querying the base table directly.
- ✗
Grant the share SELECT on the base table and rely on a row access policy to filter rows for the partners.
Why it's wrong here
Row access policies are not applied to shares in a way that reliably restricts external consumers, and sharing the base table exposes its full structure and any rows the policy does not filter. The safer design is to share a curated view so the base table is never directly accessible to partners.
- ✗
Create a materialized view of the curated rows and add it to the share for the partners to query.
Why it's wrong here
Materialized views are not supported as shareable objects, so adding one to a share is not a valid mechanism. Even if the rows could be exposed another way, the materialized view would still require the base table to remain accessible for maintenance. A secure view is the supported construct for this use case.
- ✗
Add the base table to the share and instruct partners to query only the approved rows using their own filters.
Why it's wrong here
Placing the base table in a share grants access to all of its rows, and relying on consumers to self-filter is not a security control. Partners could query any row, including data outside the curated set. The requirement that partners must not see other rows rules out this approach entirely.
About these practice questions
Courseiva writes every DEA-C02 question from scratch — 229 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 DEA-C02 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 DEA-C02 exam.