COF-C02 Question #68: Real Exam Question with Answer & Explanation

The correct answer is D: SELECT EVENT_TIMESTAMP, USER_NAME. To generate a report listing all Snowflake logins within the last 90 days, the ACCOUNT_USAGE.LOGIN_HISTORY view should be used. This view provides information about login attempts, including successful and unsuccessful logins, and is suitable for security

Account Access and Security

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

Explanation

To generate a report listing all Snowflake logins within the last 90 days, the ACCOUNT_USAGE.LOGIN_HISTORY view should be used. This view provides information about login attempts, including successful and unsuccessful logins, and is suitable for security

Topics

#Login History#Account Usage Views#Security Auditing#Information Schema

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions