Snowflake
ADA-C01 · Question #49
ADA-C01 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Question
A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region. When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?
Options
- Acreate or replace row access policy region policy as (region_value varchar) returns boolean ->
- Bcreate or replace row access policy region policy as (region_value varchar) returns boolean ->
- Ccreate or replace row access policy region policy as (region_value varchar) returns boolean ->
- Dcreate or replace row access policy region policy as (region_value varchar) returns boolean ->
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.