
Explanation:
The LOGIN_HISTORY view in ACCOUNT_USAGE is the correct answer because it specifically tracks login attempts, including both successful and failed logins, with detailed information such as user name, client IP, and authentication result. This view maintains data for up to 365 days, making it suitable for reviewing the past 30 days. The community discussion shows 100% consensus on option B, with references to Snowflake documentation confirming this view's purpose. Other options are less suitable: USERS view shows user metadata but not login history; ACCESS_HISTORY tracks data access, not logins; SESSIONS view shows active sessions but not historical failed login attempts.
How can a user locate and examine the failed login history for a specific user over the last 30 days?
A
The USERS view in ACCOUNT_USAGE
B
The LOGIN_HISTORY view in ACCOUNT_USAGE
C
The ACCESS_HISTORY view in ACCOUNT_USAGE
D
The SESSIONS view in ACCOUNT_USAGE
No comments yet.