Question 30
For a telecommunications provider, the original problem was: A human resources dataset contains salary amounts, and a general analyst role should see only masked values. What observation confirms success?
Explanation
Correct Answer
A payroll role sees approved values while the analyst sees the configured masked representation. This validates the relevant action: Apply a dynamic data masking policy to the sensitive column using an appropriate role-aware expression. The underlying Snowflake behavior is: Masking policies evaluate authorized context at query time rather than copying a second redacted table.
Incorrect Answers
The consumer role queries its approved interface but cannot read the raw customer table directly. This evidence tests a DIFFERENT situation: A security review finds a shared role with direct access to raw customer names even though applications need only a masked view. The correction required in this case is: Apply a dynamic data masking policy to the sensitive column using an appropriate role-aware expression.
A governance report identifies responsible owners and classified fields without unauthorized tag drift. This evidence tests a DIFFERENT situation: An enterprise needs a reliable inventory of who owns sensitive schemas, but its governance tags are edited without review. The correction required in this case is: Apply a dynamic data masking policy to the sensitive column using an appropriate role-aware expression.
Authorized corporate connections succeed while an unapproved test source is rejected. This evidence tests a DIFFERENT situation: A company wants to restrict SQL console sign-in to trusted corporate networks but users can log in from unmanaged locations. The correction required in this case is: Apply a dynamic data masking policy to the sensitive column using an appropriate role-aware expression.