Snowflake Exam ARA-R01 Topic 2 Question 23 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 23
Topic #: 2

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

AAn external table can be created with a row access policy, and the policy can be applied to the VALUE column.

BA row access policy can be applied to the VALUE column of an existing external table.

CA row access policy cannot be directly added to a virtual column of an external table.

DExternal tables are supported as mapping tables in a row access policy.

EWhile cloning a database, both the row access policy and the external table will be cloned.

FA row access policy cannot be applied to a view created on top of an external table.

Show Suggested Answer

Suggested Answer: C

Enabling the search optimization service on the table can improve the performance of queries that have selective filtering criteria, which seems to be the case here. This service optimizes the execution of queries by creating a persistent data structure called a search access path, which allows some micro-partitions to be skipped during the scanning process. This can significantly speed up query performance without increasing compute costs1.

Reference

* Snowflake Documentation on Search Optimization Service1.

by Laticia at Oct 23, 2024, 04:12 AM

Limited Time Offer

25%

24 days ago

I think A, B, and D are the characteristics of how row access policies can be applied to external tables.

upvoted 0 times

...