Answer-first summary for fast verification
Answer: To protect hidden data from other users, To hide the view definition from other users
The correct answers are C and E based on Snowflake's secure view functionality. Secure views are specifically designed to protect hidden data from other users (C) by preventing access to underlying base table data through optimizations that could expose hidden columns. They also hide the view definition from other users (E), making the view's structure and logic visible only to authorized users with the owning role. Option A is incorrect because secure views don't encrypt data in transit - that's handled by Snowflake's network security. Option B is incorrect because secure views typically execute slower than standard views due to security restrictions. Option D is incorrect because secure views generally have worse performance than standard views, not better performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Why should a Snowflake user create a secure view? (Choose two.)
A
To encrypt the data in transit
B
To execute faster than a standard view
C
To protect hidden data from other users
D
To improve the performance of a query
E
To hide the view definition from other users
No comments yet.