Question 400
After remediating the Snowflake issue, the team reviews: A company publishes an analytics dataset to collaborators but never checks whether shared policies expose new sensitive columns. Which recurring control is most targeted?
Explanation
Correct Answer
Schedule consumer-perspective access and policy regression tests for every data product change. This reduces recurrence of: Sharing boundaries must be governed continually because producer schemas and entitlements evolve. The verification should demonstrate: An external test role sees only approved columns and rows even after a new sensitive field is introduced.
Incorrect Answers
Track reader account warehouse costs and permitted user privileges. That safeguard is aimed at ANOTHER risk: A company wants to provide query access to a small external partner that has no existing Snowflake account. It is less targeted than the control for: Sharing boundaries must be governed continually because producer schemas and entitlements evolve.
Document functional requirements before choosing share, listing or Native App distribution. That safeguard is aimed at ANOTHER risk: A provider shares a static dataset with a consumer but later learns that the partner needs a governed application, not only tables. It is less targeted than the control for: Sharing boundaries must be governed continually because producer schemas and entitlements evolve.
Use a provider-to-consumer role test when publishing new secure views. That safeguard is aimed at ANOTHER risk: A data provider creates a direct share but the consumer cannot see a secure view because underlying reference privileges are incomplete. It is less targeted than the control for: Sharing boundaries must be governed continually because producer schemas and entitlements evolve.