Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ARA-R01 Topic 2 Question 23 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 23
Topic #: 2
[All ARA-R01 Questions]

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

Show Suggested Answer Hide 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.


Contribute your Thoughts:

Chanel
4 days ago
I'm not sure about E. Does cloning a database really clone both the row access policy and the external table?
upvoted 0 times
...
Shala
9 days ago
I agree with Paris. A, B, and D make sense because external tables can have row access policies applied to them.
upvoted 0 times
...
Paris
10 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
...

Save Cancel