Question 470
A Snowflake acceptance test follows this incident: A provider expects that consumer queries on shared data will be billed entirely to the provider's compute warehouse. What evidence most directly proves the correction?
Explanation
Correct Answer
Usage reports attribute consumer query compute and provider source storage to their respective accounts. This validates the relevant action: Model the shared-data consumer's own warehouse compute and the provider's ongoing storage responsibilities separately. The underlying Snowflake behavior is: Secure sharing allows consumers to query their own compute while data storage remains provider-managed.
Incorrect Answers
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: Model the shared-data consumer's own warehouse compute and the provider's ongoing storage responsibilities separately.
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: Model the shared-data consumer's own warehouse compute and the provider's ongoing storage responsibilities separately.
A representative consumer query remains valid through an approved schema evolution release. This evidence tests a DIFFERENT situation: A data provider changes a shared table schema in a listed data product and breaks downstream customer queries. The correction required in this case is: Model the shared-data consumer's own warehouse compute and the provider's ongoing storage responsibilities separately.