Exam SnowPro Advanced Architect topic 1 question 12 discussion

Key word here : way to find recent and ongoing login attempts . So can't be the B answer, as there is lag (2 or 3 hours) in the account_usage view. Answer is A.

Selected Answer: A If TIME_RANGE_END is not specified, the function returns the most recent login events. If the time range does not fall within the last 7 days, an error is returned. select * from table(information_schema.login_history_by_user()) order by event_timestamp; select * from table(information_schema.login_history(TIME_RANGE_START => dateadd('hours',-1,current_timestamp()),current_timestamp())) order by event_timestamp;

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3#step-3-configure-security

Answer is A and is validated

LOGIN_HISTORY is not in the information schema it's part of ACCOUNT_USAGE https://docs.snowflake.com/en/sql-reference/account-usage/login_history