Snowpro Core · Free Practice Question Easy
Question 1
As an administrator, you are required to find all users that logged in to the system during the past 15 minutes. Which of the following options should you use?
- A Use the table functions provided in the INFORMATION_SCHEMA schema
- B Use the views in the ACCOUNT_USAGE schema
- C Use cloud provider logs to ascertain the users that recently logged in
- D Analyze the system logs to find out who logged in
Reveal correct answer
Correct answer: A
Explanation
Because there is a requirement to see the logins from the last 15 minutes, you must use the INFORMATION_SCHEMA, since it contains near real-time information. https://docs.snowflake.com/en/sql-reference/account-usage#differences-between-account-usage-and-information-schemaDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
