What are characteristics of Dynamic Data Masking? (Select TWO).

The correct answer is A. A masking policy that Is currently set on a table can be dropped. B. A single masking policy can be applied to columns in different tables.. Dynamic Data Masking is a feature that allows masking sensitive data in query results based on the role of the user who executes the query. A masking policy is a user-defined function that specifies the masking logic and can be applied to one or more columns in one or more tables

Data Governance and Data Sharing

Question

Options

AA masking policy that Is currently set on a table can be dropped.
BA single masking policy can be applied to columns in different tables.
CA masking policy can be applied to the value column of an external table.
DThe role that creates the masking policy will always see unmasked data In query results
EA masking policy can be applied to a column with the GEOGRAPHY data type.

How the community answered

(55 responses)

A
87% (48)
C
7% (4)
D
2% (1)
E
4% (2)

Explanation

Dynamic Data Masking is a feature that allows masking sensitive data in query results based on the role of the user who executes the query. A masking policy is a user-defined function that specifies the masking logic and can be applied to one or more columns in one or more tables. A masking policy that is currently set on a table can be dropped using the ALTER TABLE command. A single masking policy can be applied to columns in different tables using the ALTER TABLE command with the SET MASKING POLICY clause.

Topics

#Dynamic Data Masking#Data Masking#Security Policies#Data Governance

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice