SnowPro Core Certification — Question 373

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Answer options

• A. Use data encryption.
• B. Use dynamic data masking.
• C. Use secure materialized views.
• D. Revoke all roles for functional managers and end users.

Correct answer: B

Explanation

The correct answer is B, as dynamic data masking allows for sensitive data to be partially obscured based on user roles, providing the necessary visibility for functional managers while keeping it hidden from end users. Option A, data encryption, secures data but does not selectively hide it based on user roles. Option C, secure materialized views, does not specifically address the need for visibility control for different users. Option D would eliminate access for functional managers, which contradicts the requirement of partial visibility.