Which masking policy will mask a column whenever it is queried through a view owned...

Snowflake ADA-C01 Question Answer

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

create or replace masking policy maskstring as (val string) returns string ->

case

when is_role_in_session ('MASKED_VIEW_ROLE') then ' **

else val

end;

create or replace masking policy maskString as (val string) returns string ->

case

when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then '*

else val

end;

** '

create or replace masking policy maskstring as (val string) returns string ->

case

when invoker_role() in ('MASKED_VIEW_ROLE') then

else val

end;

' **

create or replace masking policy maskString as (val string) returns string ->

case

when current_role() in ('MASKED_VIEW_ROLE') then ' ********* '

else val

end;

ADA-C01 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"