Explanation:
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.
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];