SnowPro Advanced: Architect — Question 12

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

Answer options

• A. An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
• B. A row access policy can be applied to the VALUE column of an existing external table.
• C. A row access policy cannot be directly added to a virtual column of an external table.
• D. External tables are supported as mapping tables in a row access policy.
• E. While cloning a database, both the row access policy and the external table will be cloned.
• F. A row access policy cannot be applied to a view created on top of an external table.

Correct answer: A, B, C

Explanation

Options A, B, and C are correct because they accurately describe the capabilities and limitations of applying row access policies to external tables. Option D is incorrect as external tables do not serve as mapping tables for row access policies. Options E and F are also incorrect; cloning behaviors and view restrictions differ from the specific characteristics of row access policies mentioned.