Question 70
A Snowflake acceptance test follows this incident: A supplier needs to query a Snowflake dataset in the same region but should not receive exported duplicate files each week. What evidence most directly proves the correction?
Explanation
Correct Answer
The consumer creates an imported database and sees updates to permitted data without file transfers. This validates the relevant action: Create a controlled direct secure share exposing approved objects and grant it to the authorized consumer account. The underlying Snowflake behavior is: Direct secure sharing exposes governed read-only objects without copying the provider's source table storage.
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: Create a controlled direct secure share exposing approved objects and grant it to the authorized consumer account.
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: Create a controlled direct secure share exposing approved objects and grant it to the authorized consumer account.
The approved aggregate overlap metric is returned while raw patient identities remain inaccessible to the partner role. This evidence tests a DIFFERENT situation: Two healthcare organizations want joint analysis of patient-overlap statistics but must avoid exposing identifiable source records directly. The correction required in this case is: Create a controlled direct secure share exposing approved objects and grant it to the authorized consumer account.