Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which of the following statements will return a report of all Snowflake logins, including the date and user, from the last 90 days?
A
SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;
B
SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())
C
FROM ACCOUNT_USAGE.ACCESS_HISTORY;
D
FROM ACCOUNT_USAGE.LOGIN_HISTORY;
