Question 80
After remediating the Snowflake issue, the team reviews: A company wants to provide query access to a small external partner that has no existing Snowflake account. Which recurring control is most targeted?
Explanation
Correct Answer
Track reader account warehouse costs and permitted user privileges. This reduces recurrence of: Reader accounts allow provider-funded consumption of shared data by organizations without their own Snowflake account. The verification should demonstrate: The partner can query the approved shared data under the reader account without establishing an independent paid Snowflake account.
Incorrect Answers
Schedule consumer-perspective access and policy regression tests for every data product change. That safeguard is aimed at ANOTHER risk: A company publishes an analytics dataset to collaborators but never checks whether shared policies expose new sensitive columns. It is less targeted than the control for: Reader accounts allow provider-funded consumption of shared data by organizations without their own Snowflake account.
Review approved computations, thresholds and privacy tests before partner onboarding. That safeguard is aimed at ANOTHER risk: Two healthcare organizations want joint analysis of patient-overlap statistics but must avoid exposing identifiable source records directly. It is less targeted than the control for: Reader accounts allow provider-funded consumption of shared data by organizations without their own Snowflake account.
Require legal, security and billing approval before publishing priced data products. That safeguard is aimed at ANOTHER risk: A commercial dataset needs pricing, product descriptions and usage discovery, but its provider uses only an internal direct share. It is less targeted than the control for: Reader accounts allow provider-funded consumption of shared data by organizations without their own Snowflake account.