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…

Question

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

• A
  2% (1)
• B
  10% (4)
• C
  80% (33)
• D
  7% (3)

Explanation

This code snippet will create a row access policy that returns true if the current role is ALL_ACCESS_ROLE or if the current role matches the region value in the entitlement_table. This means that the ALL_ACCESS_ROLE can see all rows regardless of region, while the other roles can only see rows for their own regions. According to the Snowflake documentation, the CURRENT_ROLE context function returns the name of the current role for the session. The EXISTS function returns true if the subquery returns any rows. The OR operator returns true if either operand is true. Therefore, this code snippet satisfies the requirements of the question.

No community discussion yet for this question.