Question 320
For this Snowflake situation — A legacy report reveals raw personal records because a row policy was disabled during a migration. — the team adopts: Restore the approved row access policy and test sensitive queries before reopening report access. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Include row-policy regression tests in every data-release checklist. It controls the recurring exposure associated with this mechanism: Row-level protection must remain enforced through data migrations and application changes. The original action, restore the approved row access policy and test sensitive queries before reopening report access., still needs operational checks when the environment or workload changes.
Incorrect Answers
The suggested review tracks a different technical risk: Snowflake object ownership and stewardship information enable accountable changes and grant management. Here the sustained control must address: Row-level protection must remain enforced through data migrations and application changes. Choose “Include row-policy regression tests in every data-release checklist”.
That safeguard is relevant to: Snowflake role-based access control separates authentication from authorization on database objects. The current failure instead follows from: Row-level protection must remain enforced through data migrations and application changes. Its prevention measure is “Include row-policy regression tests in every data-release checklist”.
The suggested review tracks a different technical risk: Multi-factor authentication reduces the risk from a stolen password in interactive access scenarios. Here the sustained control must address: Row-level protection must remain enforced through data migrations and application changes. Choose “Include row-policy regression tests in every data-release checklist”.