Which SQL statement is used to apply an existing masking policy to a column in a table?

CREATE MASKING POLICY ... ON COLUMN

UPDATE TABLE ... SET MASKING POLICY

GRANT MASKING POLICY ... TO TABLE

ALTER TABLE ... SET MASKING POLICY

How can you test a masking policy for a specific role without changing your current session role?

Create a new session with the target role

Use the POLICY_CONTEXT function to simulate a different role

Use the SET ROLE statement to switch roles

Use the EXECUTE AS ROLE statement

A data engineer is designing a data warehouse and wants to minimize the performance impact of masking and row access policies. The policies will be applied to large tables that are queried frequently. Which design choice is most likely to reduce the performance overhead?

Avoid using policies and instead rely on secure views for all access control.

Use complex subqueries in policies to handle all edge cases.

Apply masking policies to all columns to ensure comprehensive protection.

Use simple conditional expressions in policies that reference only context functions and a few columns.

What is the primary purpose of a row access policy in Snowflake?

To control column-level visibility at query time

To filter rows from query results based on user context or other conditions

To mask column values based on user role

To encrypt rows in the storage layer

Which SQL statement is used to apply a row access policy to a table?

ALTER TABLE ... SET ROW ACCESS POLICY

CREATE ROW ACCESS POLICY ... ON TABLE

UPDATE TABLE ... SET ROW ACCESS POLICY

GRANT ROW ACCESS POLICY ... TO TABLE

SnowflakeSnowPro Advanced — Data Engineer

Domain 5Objective 1

Apply Masking and Row Access Policies DEA-C02 Practice Questions (Page 1)

Part of the Data Governance domain, which accounts for 14% of the DEA-C02 exam.

21questions here

5free pages

8concepts

14%of the exam

Questions 1–5

1foundation · easy
Which SQL statement is used to apply an existing masking policy to a column in a table?
Select an answer first
2foundation · easy
How can you test a masking policy for a specific role without changing your current session role?
Select an answer first
3application · medium
A data engineer is designing a data warehouse and wants to minimize the performance impact of masking and row access policies. The policies will be applied to large tables that are queried frequently. Which design choice is most likely to reduce the performance overhead?
Select an answer first
4foundation · easy
What is the primary purpose of a row access policy in Snowflake?
Select an answer first
5foundation · easy
Which SQL statement is used to apply a row access policy to a table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DEA-C02

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. “DEA-C02” is a trademark of its owner, used for identification only.