Question 310
Consider this Snowflake situation: A team applies masking only in one dashboard and assumes data remains protected from any SQL client. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Client-side presentation controls do not protect data from other SQL access paths. It supports the response: Move sensitive-data enforcement into appropriate Snowflake masking and access policies. Confirm it with this observable result: An unauthorized direct SQL query receives only the governed representation. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
This principle describes a separate cause: Snowflake object ownership and stewardship information enable accountable changes and grant management. The reported condition is governed by: Client-side presentation controls do not protect data from other SQL access paths. The two mechanisms should not be conflated.
OAuth access tokens support delegated or scoped authentication for compatible clients. That explanation applies to a different technical failure. Here the controlling principle is: Client-side presentation controls do not protect data from other SQL access paths.
This principle describes a separate cause: Snowflake network policy controls can restrict network-source access independently of SQL object grants. The reported condition is governed by: Client-side presentation controls do not protect data from other SQL access paths. The two mechanisms should not be conflated.