Question 290
Consider this Snowflake situation: An analyst mistakenly shares a base table containing sensitive fields instead of a filtered representation for partners. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case. It supports the response: Design an authorized secure view or governed share object that exposes only the approved fields and rows. Confirm it with this observable result: A consumer test query returns approved columns while sensitive fields remain unavailable. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
Privacy-preserving collaboration can expose approved aggregate outcomes while constraining raw data visibility. That explanation applies to a different technical failure. Here the controlling principle is: Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case.
This principle describes a separate cause: Zero-copy clones initially share storage but later writes and retention can increase billed storage. The reported condition is governed by: Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case. The two mechanisms should not be conflated.
Multi-factor authentication reduces the risk from a stolen password in interactive access scenarios. That explanation applies to a different technical failure. Here the controlling principle is: Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case.