Question 40
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. What observation most directly confirms the correction?
Explanation
Correct Answer
This verifies reader account collaboration because a regular share consumer must have an account while the partner currently has none. The corresponding corrective action is: Evaluate an authorized reader account with scoped shared access and appropriate cost ownership. A green status for a different component would not independently establish this result.
Incorrect Answers
Importing a share does not automatically grant every consumer role usage and select privileges. “Grant approved imported-database privileges through the consumer's authorized roles” would address that alternative cause, not the condition in this question: a regular share consumer must have an account while the partner currently has none.
“Use an appropriate secured view or protected projection in the authorized share” responds to this separate finding: sharing unprotected base data would reveal more information than the collaboration needs. This question instead needs “Evaluate an authorized reader account with scoped shared access and appropriate cost ownership”, so the alternative does not meet the stated condition.
Secure Data Sharing exposes provider objects for read-only consumer use. “Keep writes in the provider's controlled ingestion process or design a separate approved feedback channel” applies to that separate problem. The observed case is a small external partner lacks its own Snowflake account but must query a limited provider dataset through governed Snowflake access; choosing this alternative would address the wrong failure mode.