What is the primary purpose of applying tags to Snowflake objects?

To improve query performance by indexing tagged columns.

To classify data and enable governance policies based on the assigned tags.

To physically separate data into different storage locations.

To automatically encrypt data with a specific key.

A company has a table with a column named salary that should only be visible to users with the HR_ADMIN role. Other users should not see the column at all (not even masked values). The security engineer needs to enforce this requirement. What should the security engineer do?

Create a secure view that excludes the salary column and grant all users access to the view instead of the base table.

Apply a masking policy to the salary column that returns NULL for all roles except HR_ADMIN.

Revoke SELECT privilege on the salary column from all roles except HR_ADMIN.

Apply a masking policy to the salary column that returns an error for all roles except HR_ADMIN.

Snowflake SnowPro Advanced:Security Engineer

Domain 1Objective 1

Design and Enforce Data Protection, Privacy, and Governance Across Snowflake SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 5)

Part of the Data Protection, Privacy, and Governance domain, which makes up ~17% of our current practice bank.

30questions here

6free pages

12concepts

Questions 21–25

21foundation · easy
What is the primary purpose of applying tags to Snowflake objects?
Select an answer first
22foundation · easy
Which Snowflake feature allows you to share data with another account without copying the data?
Select an answer first
23application · medium
A company has a table with a column named salary that should only be visible to users with the HR_ADMIN role. Other users should not see the column at all (not even masked values). The security engineer needs to enforce this requirement. What should the security engineer do?
Select an answer first
24foundation · easy
Which Snowflake feature allows customers to manage their own encryption keys?
Select an answer first
25foundation · easy
Which Snowflake feature is commonly used to implement column-level security?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-SECURITY-ENGINEER

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. “SNOWPRO-ADVANCED-SECURITY-ENGINEER” is a trademark of its owner, used for identification only.

Design and Enforce Data Protection, Privacy, and Governance Across Snowflake SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 5)

Questions 21–25

What is the primary purpose of applying tags to Snowflake objects?

Which Snowflake feature allows you to share data with another account without copying the data?

A company has a table with a column named salary that should only be visible to users with the HR_ADMIN role. Other users should not see the column at all (not even masked values). The security engineer needs to enforce this requirement. What should the security engineer do?

Which Snowflake feature allows customers to manage their own encryption keys?

Which Snowflake feature is commonly used to implement column-level security?

Keep studying — Data Protection, Privacy, and Governance