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%

Off

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

Contribute your Thoughts:

Submit Cancel

Roslyn

2 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

Alita

13 days ago

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

upvoted 0 times

...

Wendell

17 days ago

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

upvoted 0 times

...

Mari

1 months 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

2 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

18 days ago

Lenna: That makes sense. It's good to have options when setting up security measures.

upvoted 0 times

...

Erick

19 days ago

User 3: I think it gives more flexibility in managing access to external tables.

upvoted 0 times

...

Lenna

24 days ago

User 2: Yes, it's definitely an interesting twist in how row access policies work.

upvoted 0 times

...

Shenika

1 months 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

2 months ago

User3

upvoted 0 times

...

Edison

2 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

...