Question 270
For a telecommunications provider, the original problem was: A data owner requests a clean audit of who accessed a sensitive table, but the team looks only at warehouse spend charts. What observation confirms success?
Explanation
Correct Answer
The audit identifies query principals and accessed objects for representative governed tests. This validates the relevant action: Use suitable ACCOUNT_USAGE or access-history sources with required privileges and known reporting lag. The underlying Snowflake behavior is: Usage, access history and cost metering contain different evidence about data access.
Incorrect Answers
Newly tagged sensitive test columns inherit the intended masking behavior where supported. This evidence tests a DIFFERENT situation: An enterprise classifies PII in columns but ignores data classification tags when assigning masking rules. The correction required in this case is: Use suitable ACCOUNT_USAGE or access-history sources with required privileges and known reporting lag.
The affected identity cannot read the restricted view through any remaining authorized role chain. This evidence tests a DIFFERENT situation: A data steward revokes a user's role but their previous worksheet continues to query an authorized view under a different active role. The correction required in this case is: Use suitable ACCOUNT_USAGE or access-history sources with required privileges and known reporting lag.
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: Use suitable ACCOUNT_USAGE or access-history sources with required privileges and known reporting lag.