1. Home
  2. Discussions
  3. Snowflake
  4. SnowPro Advanced: Administrator
  5. ADA-C01 Discussions
  6. ADA-C01 Exam Topic 3 Question 23 Discussion

Snowflake SnowPro Advanced Administrator ADA-C01 Question # 23 Topic 3 Discussion

 Snowflake Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous

Snowflake SnowPro Advanced Administrator ADA-C01 Question # 23 Topic 3 Discussion

ADA-C01 Exam Topic 3 Question 23 Discussion:
Question #: 23
Topic #: 3

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?
A.

create or replace row access policy region policy as (region_value varchar) returns boolean ->

'ALL ACCESS_ROLE' = current_role ()

and exists (

select 1 from entitlement_table

where role = current_role ()

and region = region_value

)

B.

create or replace row access policy region policy as (region_value varchar) returns boolean ->

exists (

select 1 from entitlement_table

where role = current_role ()

and region = region_value

)

C.

create or replace row access policy region policy as (region_value varchar) returns boolean ->

'ALL_ACCESS_ROLE' = current_role ()

or exists (

select 1 from entitlement_table

where role = current_role ()

and region = region_value

)

D.

create or replace row access policy region policy as (region_value varchar) returns boolean ->

'ALL ACCESS ROLE' = current_role ()

)

Get Premium ADA-C01 Questions
Actual exam question for Snowflake ADA-C01 exam by Talon3510 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous