Question 310
A Snowflake acceptance test follows this incident: Two Snowflake accounts are in different regions and a provider assumes a direct share can be added across the regions immediately. What evidence most directly proves the correction?
Explanation
Correct Answer
A consumer in the remote region obtains the governed listing through supported fulfillment, not a same-region-only direct share. This validates the relevant action: Evaluate a supported cross-region listing with auto-fulfillment or approved replication-based sharing strategy. The underlying Snowflake behavior is: Direct shares are region-scoped; cross-region sharing needs a supported different distribution mechanism.
Incorrect Answers
The consumer can query the shared secure view without direct access to unapproved underlying tables. This evidence tests a DIFFERENT situation: A data provider creates a direct share but the consumer cannot see a secure view because underlying reference privileges are incomplete. The correction required in this case is: Evaluate a supported cross-region listing with auto-fulfillment or approved replication-based sharing strategy.
The consumer can query the shared table and can modify only its own separate local derived data. This evidence tests a DIFFERENT situation: A consuming team tries to UPDATE a shared sales table and reports an authorization failure despite having read access. The correction required in this case is: Evaluate a supported cross-region listing with auto-fulfillment or approved replication-based sharing strategy.
An intended partner can discover the listing while an unrelated test account cannot. This evidence tests a DIFFERENT situation: A private listing accidentally becomes visible beyond the intended partner audience because the provider selected public visibility. The correction required in this case is: Evaluate a supported cross-region listing with auto-fulfillment or approved replication-based sharing strategy.