Question 110
For a global logistics company, the original problem was: A regional sales analyst can read rows for every country despite having permission only for their own region. What observation confirms success?
Explanation
Correct Answer
Two test roles see only their permitted country rows while a governed admin test gets its required scope. This validates the relevant action: Attach a row access policy using approved role/entitlement logic to filter visible records. The underlying Snowflake behavior is: Row access policies restrict result rows dynamically as SQL is executed.
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: Attach a row access policy using approved role/entitlement logic to filter visible records.
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: Attach a row access policy using approved role/entitlement logic to filter visible records.
The report shows an explicit freshness indicator and reconciles delayed cost rows later. This evidence tests a DIFFERENT situation: A cost dashboard immediately queries ACCOUNT_USAGE views after a warehouse change and declares telemetry missing. The correction required in this case is: Attach a row access policy using approved role/entitlement logic to filter visible records.