Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?
Suggested Answer: B
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
16 comments · newest first
JO
Josphine
11 months ago
Really? I always thought ACCESS_HISTORY had that info!
MI
Misty
11 months ago
I agree, LOGIN_HISTORY is the right one.
PE
Pete
11 months ago
No way, QUERY HISTORY doesn't show IPs.
ST
Stevie
11 months ago
I thought it was SESSIONS at first.
KE
Kenneth
11 months ago
It's definitely LOGIN_HISTORY!
KE
Keneth
12 months ago
I thought QUERY_HISTORY was related to queries, not user connections. I’m leaning towards LOGIN_HISTORY too.
HO
Hortencia
12 months ago
I remember seeing something about IP addresses in SESSIONS, but I can't recall if that's the main view for logins.
JE
Jesusa
12 months ago
I feel like ACCESS_HISTORY might be the right answer, but I could be mixing it up with another question we practiced.
EL
Elza
1 year ago
I think it's LOGIN_HISTORY, but I'm not completely sure. I remember something about tracking user logins.
RE
Reita
1 year 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.
MA
Marvel
1 year 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.
DI
Dion
1 year 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.
DO
Doretha
1 year 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.
TA
Tarra
1 year 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.
ET
Ettie
1 year 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.
KI
Kimberlie
1 year 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.