Question 320
After remediating the Snowflake issue, the team reviews: A provider shares a static dataset with a consumer but later learns that the partner needs a governed application, not only tables. Which recurring control is most targeted?
Explanation
Correct Answer
Document functional requirements before choosing share, listing or Native App distribution. This reduces recurrence of: Secure shares expose read-only data, while application distribution can require different packaging and permissions. The verification should demonstrate: The consumer receives the authorized application capabilities without unsupported expectations of ordinary read-only sharing.
Incorrect Answers
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: Secure shares expose read-only data, while application distribution can require different packaging and permissions.
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: Secure shares expose read-only data, while application distribution can require different packaging and permissions.
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: Secure shares expose read-only data, while application distribution can require different packaging and permissions.