SnowPro Core Certification — Question 526

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?

Answer options

• A. ACCESS_HYSTORY
• B. LOGIN_HYSTORY
• C. SESSIONS
• D. QUERY_HISTORY

Correct answer: B

Explanation

The correct answer is B, LOGIN_HYSTORY, because it specifically logs user login events including the IP addresses. ACCESS_HYSTORY tracks access to data, SESSIONS records session details but not necessarily IPs, and QUERY_HISTORY focuses on executed queries rather than login details.