MENU
Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)
Suggested Answer: C
Get Premium ARA-R01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
29 comments · newest first
AN
Angelo
11 months ago
I think cloning a database with the policy is a bit misleading.
FL
Floyd
11 months ago
External tables as mapping tables? That's new to me!
ER
Erinn
11 months ago
Wait, you can't add a policy to a virtual column? That's surprising!
MA
Marvel
11 months ago
Totally agree, that's a key feature!
DE
Deja
11 months ago
A row access policy can be applied to the VALUE column of an existing external table.
AS
Ashley
12 months ago
I vaguely remember something about cloning databases and how row access policies are handled, but I can't remember if they get cloned along with the external table.
BA
Barrett
12 months ago
I’m pretty certain that a row access policy cannot be added to a virtual column of an external table, but I might be mixing it up with something else.
YU
Yuki
12 months ago
I feel like we practiced a question about whether external tables can be used in row access policies, and I think they can be, but I can't recall the specifics.
LA
Latonia
1 year ago
I think I remember that a row access policy can be applied to the VALUE column of an existing external table, but I'm not completely sure.
JE
Jerrod
1 year ago
I feel pretty good about this one. I remember that row access policies can be applied to external tables, and the table can even be used as a mapping table in the policy. But I don't think the policy can be directly added to a virtual column.
AL
Alesia
1 year ago
Okay, let me think this through. I know external tables are supported, and the policy can be applied to the table itself. But I'm not sure about things like virtual columns or using the external table as a mapping table. I'll have to review those details.
WI
Winfred
1 year ago
Hmm, I'm a bit unsure about the details here. I know row access policies can be used with external tables, but I'm not sure about the specifics like whether the policy can be applied to the VALUE column or if the policy and table get cloned together.
NI
Niesha
1 year ago
I'm pretty confident about this one. I think the key characteristics are that row access policies can be applied to external tables, but not directly to virtual columns, and external tables can be used as mapping tables in the policies.
RO
Roslyn
1 year 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.
AL
Alita
1 year ago
F) A row access policy cannot be applied to a view created on top of an external table.
WE
Wendell
1 year ago
B) A row access policy can be applied to the VALUE column of an existing external table.
MA
Mari
1 year ago
A) An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
MA
Maryanne
1 year 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!
DA
Darnell
1 year ago
Lenna: That makes sense. It's good to have options when setting up security measures.
ER
Erick
1 year ago
User 3: I think it gives more flexibility in managing access to external tables.
LE
Lenna
1 year ago
User 2: Yes, it's definitely an interesting twist in how row access policies work.
SH
Shenika
1 year ago
User 1: I agree, B is surprising. I didn't know we could apply the policy later.
JO
Jovita
1 year 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.
OS
Osvaldo
1 year ago
User3
ED
Edison
1 year ago
User2
DA
Daisy
2 years 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!
CH
Chanel
2 years ago
I'm not sure about E. Does cloning a database really clone both the row access policy and the external table?
SH
Shala
2 years ago
I agree with Paris. A, B, and D make sense because external tables can have row access policies applied to them.
PA
Paris
2 years ago
I think A, B, and D are the characteristics of how row access policies can be applied to external tables.