Answer-first summary for fast verification
Answer: Within the create table or create view DDL, Using the command ALTER [object] ADD ROW ACCESS POLICY [policy];
The correct answers are B and E. According to Snowflake documentation and the community consensus (78% agreement with BE), row access policies can be applied to tables or views either during creation using CREATE TABLE/VIEW DDL (option B) or after creation using ALTER TABLE/VIEW ADD ROW ACCESS POLICY command (option E). Option A (within policy DDL) is incorrect because policy DDL only defines the policy, not applies it to objects. Option C (future APPLY for all objects in a schema) is not a valid method for applying row access policies. Option D (within a control table) is not a standard method for applying row access policies in Snowflake. The community discussion strongly supports BE with multiple comments referencing official Snowflake documentation and high upvote counts.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can a row access policy be applied to a table or a view in Snowflake? (Choose two.)
A
Within the policy DDL
B
Within the create table or create view DDL
C
By future APPLY for all objects in a schema
D
Within a control table
E
Using the command ALTER [object] ADD ROW ACCESS POLICY [policy];