SnowPro Core Certification — Question 321

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Answer options

• A. CHECK_OPTION
• B. IS_SECURE
• C. IS_UPDATEABLE
• D. TABLE_NAME

Correct answer: B

Explanation

The correct answer is B, IS_SECURE, as it specifically identifies the security status of a view. The other options do not pertain to the security classification of views; CHECK_OPTION relates to the check constraints, IS_UPDATEABLE indicates if a view can be updated, and TABLE_NAME simply refers to the name of the table associated with a view.