Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 30

Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)

    Correct Answer: B, C, D

    A row access policy can be applied to the VALUE column of an existing external table. A row access policy cannot be directly added to a virtual column of an external table. External tables are supported as mapping tables in a row access policy.

Discussion
hillcat111Options: ABC

Answer is A,B,C and is validated

callipso21Options: ABC

https://docs.snowflake.com/en/user-guide/security-row-intro#external-tables External Tables You can create an external table with a row access policy by executing a CREATE EXTERNAL TABLE statement and apply the policy to the VALUE column. You can apply the row access policy to VALUE column of an existing external table by executing an ALTER TABLE statement on the external table. A row access policy cannot be added to a virtual column directly. Instead, create a view on the external table and apply the row access policy to the columns on the view.

serg_kharOptions: ABC

https://docs.snowflake.com/en/user-guide/security-row-intro#external-tables