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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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.


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

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Roslyn
1 months ago
This is all great, but I'm just wondering - can we use row access policies to control who sees the external table's secret ingredient recipe? Asking for a friend, of course.
upvoted 0 times
Wendell
B) A row access policy can be applied to the VALUE column of an existing external table.
upvoted 0 times
...
Mari
18 days ago
A) An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
upvoted 0 times
...
...
Maryanne
1 months ago
B is a bit surprising. I thought we could only create the policy when the external table is made, not apply it later. Interesting twist!
upvoted 0 times
Darnell
1 days ago
Lenna: That makes sense. It's good to have options when setting up security measures.
upvoted 0 times
...
Erick
2 days ago
User 3: I think it gives more flexibility in managing access to external tables.
upvoted 0 times
...
Lenna
7 days ago
User 2: Yes, it's definitely an interesting twist in how row access policies work.
upvoted 0 times
...
Shenika
23 days ago
User 1: I agree, B is surprising. I didn't know we could apply the policy later.
upvoted 0 times
...
...
Jovita
2 months ago
C and F make sense. Can't apply a policy to a virtual column or a view on an external table. Gotta keep those policies on the base table.
upvoted 0 times
Osvaldo
29 days ago
User3
upvoted 0 times
...
Edison
1 months ago
User2
upvoted 0 times
...
...
Daisy
2 months ago
A, D, and E - Looks like we can create an external table with a row access policy, use it as a mapping table, and even clone the policy along with the table. Handy stuff!
upvoted 0 times
...
Chanel
2 months 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
2 months 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
2 months 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