SnowPro Advanced: Architect Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  Answer is A,B,C and is validated

• Chose ABC1

  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.

• Chose ABC1

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