Answer: The LOGIN_HISTORY view in ACCOUNT_USAGE

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.

Author: LeetQuiz Editorial Team