QuestionQ12Verified/Manage and administer Snowflake accounts, data security, and governanceCopy linkReport a problemAsk AstroTutorSave questionWhich of the following are characteristics of Dynamic Data Masking?Choose twoAA 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 single masking policy can be applied to columns with different data types.Show AnswerAnswerExplanationA masking policy may be applied to matching columns in multiple tables. It may also be assigned to an external table’s VALUE column with an ALTER TABLE … ALTER COLUMN statement; the policy protecting that column must have the VARIANT data type. Unmasked query results depend on the policy conditions and active role, rather than on who created the policy.Learn moreUnderstanding Column-level SecurityUnderstanding Dynamic Data MaskingShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion