Question 230
A Snowflake acceptance test follows this incident: A consuming team tries to UPDATE a shared sales table and reports an authorization failure despite having read access. What evidence most directly proves the correction?
Explanation
Correct Answer
The consumer can query the shared table and can modify only its own separate local derived data. This validates the relevant action: Keep shared objects read-only and use an approved local table copy if independent transformations are required. The underlying Snowflake behavior is: Standard secure shares grant consumers read access, not write ownership of provider tables.
Incorrect Answers
Usage reports attribute consumer query compute and provider source storage to their respective accounts. This evidence tests a DIFFERENT situation: A provider expects that consumer queries on shared data will be billed entirely to the provider's compute warehouse. The correction required in this case is: Keep shared objects read-only and use an approved local table copy if independent transformations are required.
New direct queries fail, while the exported-file inventory is handled by separate data lifecycle procedures. This evidence tests a DIFFERENT situation: A provider revokes a partner's access to a direct share but expects the partner's previously exported CSV files to vanish. The correction required in this case is: Keep shared objects read-only and use an approved local table copy if independent transformations are required.
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: Keep shared objects read-only and use an approved local table copy if independent transformations are required.