nerdexam
Snowflake

COF-R02 · Question #164

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required…

The correct answer is D. SELECT EVENT_TIMESTAMP, USER_NAME. See the full explanation below for the reasoning.

Question

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

Options

  • ASELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
  • BSELECT EVENT_TIMESTAMP, USER_NAME
  • CSELECT EVENT_TIMESTAMP, USER_NAME
  • DSELECT EVENT_TIMESTAMP, USER_NAME

How the community answered

(48 responses)
  • A
    6% (3)
  • B
    4% (2)
  • C
    17% (8)
  • D
    73% (35)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice