Question 300
For this Snowflake situation — A developer believes a masked column can be recovered merely by rewriting the SELECT with a different alias. — the team adopts: Enforce the masking policy on the data column and test alternate authorized query paths. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Test masking against common transformations and access paths after policy updates. It controls the recurring exposure associated with this mechanism: A properly applied masking policy follows the protected column rather than the specific SQL alias. The original action, enforce the masking policy on the data column and test alternate authorized query paths., still needs operational checks when the environment or workload changes.
Incorrect Answers
That safeguard is relevant to: Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case. The current failure instead follows from: A properly applied masking policy follows the protected column rather than the specific SQL alias. Its prevention measure is “Test masking against common transformations and access paths after policy updates”.
The suggested review tracks a different technical risk: Warehouse-level credit records make usage-based chargeback possible when ownership is governed. Here the sustained control must address: A properly applied masking policy follows the protected column rather than the specific SQL alias. Choose “Test masking against common transformations and access paths after policy updates”.
That safeguard is relevant to: Private connectivity mechanisms use supported provider networking paths with their own prerequisites. The current failure instead follows from: A properly applied masking policy follows the protected column rather than the specific SQL alias. Its prevention measure is “Test masking against common transformations and access paths after policy updates”.