SnowPro Core Certification — Question 274

What should be considered when deciding to use a Secure View? (Choose two.)

Answer options

• 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.

Correct answer: A, C

Explanation

Option A is correct because secure views do not allow visibility into the query execution plan, which is a limitation in the query profiler. Option C is also correct since secure views have different optimization behavior compared to standard views. The other options are incorrect as they either misrepresent the functionality of secure views or state inaccuracies about their visibility and creation.