A masking policy was applied to a column, but the administrator needs to remove the masking so that all users can see the original values. What is the correct SQL command to achieve this?

REVOKE APPLY MASKING POLICY from the role that applied it.

ALTER TABLE ... ALTER COLUMN ... UNSET MASKING POLICY

ALTER MASKING POLICY ... SET BODY = ...

Which SQL command applies a row access policy to a table?

ALTER TABLE ... ADD ROW ACCESS POLICY

When a column has both a masking policy and a row access policy on its table, how do they interact?

Only the masking policy is applied

The policies conflict and cause an error

Only the row access policy is applied

Both policies are applied independently

Which command removes a masking policy from a column?

ALTER TABLE ... UNSET MASKING POLICY

SnowPro® Core Certification

Domain 3Objective 3

Apply Data Governance Features Including Masking and Row Access Policies COF-C03 Practice Questions (Page 3)

Part of the Account Management and Data Governance domain, which accounts for 20% of the COF-C03 exam.

14questions here

3free pages

6concepts

20%of the exam

Questions 11–14

11application · medium
A masking policy was applied to a column, but the administrator needs to remove the masking so that all users can see the original values. What is the correct SQL command to achieve this?
Select an answer first
12foundation · easy
Which SQL command applies a row access policy to a table?
Select an answer first
13foundation · easy
When a column has both a masking policy and a row access policy on its table, how do they interact?
Select an answer first
14foundation · easy
Which command removes a masking policy from a column?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to COF-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.