What is the primary purpose of the account usage views in Snowflake?

To store the actual data loaded into the account

To manage user roles and permissions within the account

To configure and manage data warehouses in the account

To provide a comprehensive set of views for monitoring and auditing account activity, including queries, logins, and storage

A security auditor needs to produce a report that shows, for each user, the number of distinct tables accessed and the number of failed login attempts in the last 30 days. They plan to combine ACCESS_HISTORY and LOGIN_HISTORY. What is the most efficient way to generate this report?

Query only LOGIN_HISTORY and infer access patterns from login activity.

Query ACCESS_HISTORY to count distinct objects per user, query LOGIN_HISTORY to count failed logins per user, then join the results on USER_NAME.

Use a UNION of ACCESS_HISTORY and LOGIN_HISTORY and then group by USER_NAME.

Join ACCESS_HISTORY and LOGIN_HISTORY directly on USER_NAME and then aggregate.

A data engineer needs to find all queries that accessed the view ANALYTICS.DAILY_SALES in the last day. They want to include the query text for each access. Which query would correctly retrieve this information?

SELECT QUERY_ID, QUERY_TEXT FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE OBJECTS_ACCESSED:"objectName" = 'ANALYTICS.DAILY_SALES';

SELECT ah.QUERY_ID, qh.QUERY_TEXT FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY ah JOIN SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY qh ON ah.QUERY_ID = qh.QUERY_ID WHERE ah.OBJECTS_ACCESSED:"objectName" = 'ANALYTICS.DAILY_SALES' AND ah.ACCESSED_AT >= DATEADD(day, -1, CURRENT_TIMESTAMP());

SELECT QUERY_ID, QUERY_TEXT FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE QUERY_TEXT LIKE '%DAILY_SALES%';

SELECT QUERY_ID, QUERY_TEXT FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY WHERE OBJECTS_ACCESSED:"objectName" = 'ANALYTICS.DAILY_SALES';

Snowflake SnowPro Advanced:Security Engineer

Domain 3Objective 3

Use ACCESS_HISTORY and Account Usage Views SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 4)

Part of the Security Auditing and Compliance domain, which makes up ~22% of our current practice bank.

21questions here

5free pages

7concepts

Questions 16–20

16foundation · easy
What is the primary purpose of the account usage views in Snowflake?
Select an answer first
17expert · hard
A security auditor needs to produce a report that shows, for each user, the number of distinct tables accessed and the number of failed login attempts in the last 30 days. They plan to combine ACCESS_HISTORY and LOGIN_HISTORY. What is the most efficient way to generate this report?
Select an answer first
18application · hard
A data engineer needs to find all queries that accessed the view ANALYTICS.DAILY_SALES in the last day. They want to include the query text for each access. Which query would correctly retrieve this information?
Select an answer first
19foundation · easy
Which schema contains the account usage views in Snowflake?
Select an answer first
20application · easy
A cloud administrator wants to monitor the total storage used by the account over the past month to forecast costs. Which account usage view should they query?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-SECURITY-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-SECURITY-ENGINEER” is a trademark of its owner, used for identification only.

Use ACCESS_HISTORY and Account Usage Views SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 4)

Questions 16–20

What is the primary purpose of the account usage views in Snowflake?

A security auditor needs to produce a report that shows, for each user, the number of distinct tables accessed and the number of failed login attempts in the last 30 days. They plan to combine ACCESS_HISTORY and LOGIN_HISTORY. What is the most efficient way to generate this report?

A data engineer needs to find all queries that accessed the view ANALYTICS.DAILY_SALES in the last day. They want to include the query text for each access. Which query would correctly retrieve this information?

Which schema contains the account usage views in Snowflake?

A cloud administrator wants to monitor the total storage used by the account over the past month to forecast costs. Which account usage view should they query?

Keep studying — Security Auditing and Compliance