COF-C03 Account Management and Data Governance Practice Question
What is the consequence of applying a Row Access Policy to a table that already contains existing data?
⚠ Common exam trap
Candidates often mistakenly believe that applying a Row Access Policy requires reloading data or recreating the table, failing to realize that Snowflake applies policies retroactively to all existing data immediately.
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 policy is applied immediately to all subsequent queries.
When a Row Access Policy is applied to an existing table, the policy immediately takes effect for all subsequent queries. Any user who runs a query against the table will only see the rows allowed by the policy logic. This is critical for governance because it provides an immediate, retroactive enforcement of security rules without needing to migrate or transform the existing data in the table, ensuring compliance from the moment the policy is activated.
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 data must be reloaded to apply the policy.
Why it's wrong here
Snowflake's architecture is designed so that policies are applied dynamically at query time. There is no need to reload or reprocess existing data. Once the policy is attached, the query engine automatically evaluates the policy logic for every row returned, making the implementation seamless and efficient for production environments.
- ✗
Existing queries will continue to return all rows.
Why it's wrong here
This is incorrect. Once a policy is attached, it becomes active immediately. Any new query executed by a user will be subject to the policy's filter. The query optimizer will inject the policy logic into the query plan, ensuring that unauthorized rows are filtered out before the result is returned.
- ✓
The policy is applied immediately to all subsequent queries.
Why this is correct
Row Access Policies are enforced at the query level. As soon as the policy is successfully attached to the table, the Snowflake engine will apply the filtering criteria to every query executed against that table, ensuring consistent security enforcement regardless of when the data was originally loaded.
- ✗
The table must be dropped and recreated.
Why it's wrong here
Dropping and recreating a table to apply security is never required in Snowflake. Policies are schema objects that can be attached to existing tables using 'ALTER TABLE' statements. This allows for flexible security governance without disrupting table availability or requiring complex object migration processes in a live production environment.
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.