Question 150
A Snowflake acceptance test follows this incident: A data provider creates a direct share but the consumer cannot see a secure view because underlying reference privileges are incomplete. What evidence most directly proves the correction?
Explanation
Correct Answer
The consumer can query the shared secure view without direct access to unapproved underlying tables. This validates the relevant action: Configure the supported secure view sharing prerequisites and necessary database/object share grants. The underlying Snowflake behavior is: Shared secure views must satisfy supported object and dependency rules, not only a view name grant.
Incorrect Answers
A consumer in the remote region obtains the governed listing through supported fulfillment, not a same-region-only direct share. This evidence tests a DIFFERENT situation: Two Snowflake accounts are in different regions and a provider assumes a direct share can be added across the regions immediately. The correction required in this case is: Configure the supported secure view sharing prerequisites and necessary database/object share grants.
A consumer role can query only the added approved object after the share grant is applied. This evidence tests a DIFFERENT situation: A partner can see a shared database but cannot find a newly added table that the provider assumed would appear automatically. The correction required in this case is: Configure the supported secure view sharing prerequisites and necessary database/object share grants.
A pilot consumer can find the approved listing metadata and request or acquire access as designed. This evidence tests a DIFFERENT situation: A commercial dataset needs pricing, product descriptions and usage discovery, but its provider uses only an internal direct share. The correction required in this case is: Configure the supported secure view sharing prerequisites and necessary database/object share grants.