nerdexam
Snowflake

COF-C02 · Question #204

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

The correct answer is B. IS_SECURE. In the Information Schema and Account Usage, the column that identifies whether a view is secure or not is IS_SECURE.

Account Access and Security

Question

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

Options

  • ACHECK_OPTION
  • BIS_SECURE
  • CIS_UPDATEABLE
  • DTABLE_NAME

How the community answered

(61 responses)
  • A
    2% (1)
  • B
    93% (57)
  • C
    2% (1)
  • D
    3% (2)

Explanation

In the Information Schema and Account Usage, the column that identifies whether a view is secure or not is IS_SECURE.

Topics

#Secure Views#Information Schema#Account Usage#Metadata Queries

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice