New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake COF-C02 Exam - Topic 6 Question 24 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 24
Topic #: 6
[All COF-C02 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

0/2000 characters
Josphine
3 months ago
Really? I always thought ACCESS_HISTORY had that info!
upvoted 0 times
...
Misty
3 months ago
I agree, LOGIN_HISTORY is the right one.
upvoted 0 times
...
Pete
3 months ago
No way, QUERY HISTORY doesn't show IPs.
upvoted 0 times
...
Stevie
4 months ago
I thought it was SESSIONS at first.
upvoted 0 times
...
Kenneth
4 months ago
It's definitely LOGIN_HISTORY!
upvoted 0 times
...
Keneth
4 months ago
I thought QUERY_HISTORY was related to queries, not user connections. I’m leaning towards LOGIN_HISTORY too.
upvoted 0 times
...
Hortencia
4 months ago
I remember seeing something about IP addresses in SESSIONS, but I can't recall if that's the main view for logins.
upvoted 0 times
...
Jesusa
4 months ago
I feel like ACCESS_HISTORY might be the right answer, but I could be mixing it up with another question we practiced.
upvoted 0 times
...
Elza
5 months ago
I think it's LOGIN_HISTORY, but I'm not completely sure. I remember something about tracking user logins.
upvoted 0 times
...
Reita
5 months ago
I think the answer is C. SESSIONS. That view should contain information about the user sessions, including the IP address used to connect. I'm fairly confident in this, but I'll double-check the documentation just to be sure.
upvoted 0 times
...
Marvel
5 months ago
Okay, let me see. The question is asking about which view shows the IP address used to connect to Snowflake. I'm leaning towards B. LOGIN_HISTORY, as that seems like the most relevant view for tracking login information.
upvoted 0 times
...
Dion
5 months ago
Hmm, I'm not sure about this one. I'll have to think it through carefully. Maybe I should review the Snowflake documentation on account usage views to see which one is most relevant.
upvoted 0 times
...
Doretha
5 months ago
I think the answer is C. SESSIONS seems like the most likely view to contain information about the IP address used to connect to Snowflake.
upvoted 0 times
...
Tarra
5 months ago
I'm a bit confused on this one. I know there are a lot of different views in SNOWFLAKE.ACCOUNT_USAGE, and I'm not sure which one specifically tracks the IP address used for connections. I'll have to do some research to figure this out.
upvoted 0 times
...
Ettie
5 months ago
I'm pretty sure the answer is C - exhibits that can't be authenticated won't be admitted regardless of relevance. That's a key rule in evidence law.
upvoted 0 times
...
Kimberlie
5 months ago
I'm a bit confused by this question. None of the options seem to clearly describe what Setup Assistant is. I'll have to guess on this one, but I'm not feeling very confident about my answer.
upvoted 0 times
...

Save Cancel