Masking policies are created at what level in Snowflake?

The correct answer is B. Column. In Snowflake, dynamic data masking policies are created and applied at the column level. A masking policy is a schema-level object, but it is assigned to specific columns within a table or view using the ALTER TABLE ... ALTER COLUMN command or at column definition time. This…

Data Governance

Question

Options

ATable
BColumn
CSchema
DDatabase

How the community answered

(19 responses)

B
89% (17)
C
5% (1)
D
5% (1)

Explanation

In Snowflake, dynamic data masking policies are created and applied at the column level. A masking policy is a schema-level object, but it is assigned to specific columns within a table or view using the ALTER TABLE ... ALTER COLUMN command or at column definition time. This granular, column-level application allows organizations to selectively protect sensitive data (e.g., SSNs, credit card numbers) without affecting other columns in the same table. The policy itself defines transformation logic based on the querying role, and assigning it per column provides precise data governance control.

Topics

#Masking Policies#Data Governance#Column-level Security

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice