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

The correct answer is A. create or replace masking policy maskstring as (val string) returns string -> case. A masking policy is a SQL expression that transforms the data in a column based on the role that queries the column. The is_role_in_session function returns true if the specified role is in the current session. Therefore, the masking policy in option A will mask the column data…

Data and Access Management

Question

Options

Acreate or replace masking policy maskstring as (val string) returns string -> case
Bcreate or replace masking policy maskString as (val string) returns string -> case
Ccreate or replace masking policy maskstring as (val string) returns string -> case
Dcreate or replace masking policy maskString as (val string) returns string -> case

How the community answered

(26 responses)

A
77% (20)
B
4% (1)
C
4% (1)
D
15% (4)

Explanation

A masking policy is a SQL expression that transforms the data in a column based on the role that queries the column. The is_role_in_session function returns true if the specified role is in the current session. Therefore, the masking policy in option A will mask the column data with asterisks whenever it is queried through a view owned by the MASKED_VIEW_ROLE.

Topics

#masking policy#dynamic data masking#role-based masking#secure views

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice