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?

Question

Ibrahim SACCA · Accepted Answer

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;

Ibrahim SACCA · Answer

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;

Ibrahim SACCA · Answer

SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())

Ibrahim SACCA · Answer

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 164 - COF-R02 discussion

Suggested answer: D

0 comments