SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 205


How can a row access policy be applied to a table or a view? (Choose two.)

Show Answer
Correct Answer: B,D,E

A row access policy can be applied to a table or a view using a create table or create view DDL (Data Definition Language). This allows for the policy to be included at the time the table or view is created. Additionally, it can be applied to an existing table or view using the ALTER command, specifically by using ALTER [object] ADD ROW ACCESS POLICY [policy]. This command modifies the existing table or view to include the specified row access policy.

Discussion

9 comments
Sign in to comment
tejarunOptions: BE
Nov 26, 2022

B, E https://docs.snowflake.com/en/user-guide/security-row-intro.html#apply-a-row-access-policy-to-a-table-or-view

EmiBOptions: AE
Mar 11, 2023

A. Within the policy DDL - CREATE TABLE t .. WITH ROW ACCESS POLICY p ON (c); E. Using the command ALTER TABLE t ADD ROW ACCESS POLICY p ON (c);

Omkarshingare
Apr 1, 2023

that is option B and E ryt

OTEOptions: BE
Mar 13, 2023

Create / Alter Table/View DDL with row access policy

HarpreetwalOptions: BE
May 13, 2023

B,E Correct. A is not correct as it is only defining not applying to table or view, Question is about applying to table/View https://docs.snowflake.com/en/user-guide/security-row-intro

weuzOptions: AE
Mar 30, 2023

A & E are the correct choices

MultiCloudIronManOptions: BE
Jul 20, 2023

Correct

Avi0407Options: BE
Oct 31, 2023

Table level is the key

_yyuktaOptions: BE
Feb 26, 2024

BE are correct

Mallikharjuna452Options: BE
Jul 21, 2024

B and E are correct