Answer-first summary for fast verification
Answer: No details of the query execution plan will be available in the query profiler., Secure views do not take advantage of the same internal optimizations as standard views.
The correct answers are A and C. Option A is correct because secure views do not expose query execution plan details in the query profiler to prevent potential data exposure through query optimization details. Option C is correct because secure views intentionally avoid certain internal optimizations that standard views use, as these optimizations might inadvertently expose underlying data through mechanisms like user-defined functions. Option B is incorrect because you can determine if a view is secure by checking the IS_SECURE column in the INFORMATION_SCHEMA.VIEWS. Option D is incorrect because Snowflake does support secure materialized views. Option E is incorrect because while the view definition is visible in the information schema for standard views, secure views hide the definition from unauthorized users.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following are true about Secure Views in Snowflake? (Choose two.)
A
No details of the query execution plan will be available in the query profiler.
B
Once created there is no way to determine if a view is secure or not.
C
Secure views do not take advantage of the same internal optimizations as standard views.
D
It is not possible to create secure materialized views.
E
The view definition of a secure view is still visible to users by way of the information schema.