Question 280
An analytics engineering team reports this behavior: A small external partner lacks its own Snowflake account but must query a limited provider dataset through governed Snowflake access. Which Snowflake approach is most appropriate for this condition?
Explanation
Correct Answer
The root issue is that a regular share consumer must have an account while the partner currently has none. The selected fix targets that condition: Evaluate an authorized reader account with scoped shared access and appropriate cost ownership. Validate it by checking this outcome: The external reader accesses only the approved dataset using the designated account.
Incorrect Answers
This action targets secure view sharing, where sharing unprotected base data would reveal more information than the collaboration needs. In the given incident, the decisive issue is instead that a regular share consumer must have an account while the partner currently has none.
This action targets share consumer read-only, where Secure Data Sharing exposes provider objects for read-only consumer use. The corrective response here is “Evaluate an authorized reader account with scoped shared access and appropriate cost ownership”; this alternative does not provide that response.
This action targets cross-account share permissions, where importing a share does not automatically grant every consumer role usage and select privileges. The stem reports a small external partner lacks its own Snowflake account but must query a limited provider dataset through governed Snowflake access; this control addresses a different failure condition.