A security team wants to detect if any user has accessed a table that they should not have access to, based on a list of sensitive tables. They have a list of table names in a separate table called SENSITIVE_TABLES. Which query would identify accesses to these sensitive tables from ACCESS_HISTORY?

SELECT USER_NAME, ACCESSED_AT FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY WHERE QUERY_TEXT LIKE '%SENSITIVE_TABLES%';

SELECT USER_NAME, ACCESSED_AT FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY WHERE OBJECTS_ACCESSED IN (SELECT TABLE_NAME FROM SENSITIVE_TABLES);

SELECT USER_NAME, ACCESSED_AT FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY WHERE OBJECTS_ACCESSED:"objectName" IN (SELECT TABLE_NAME FROM SENSITIVE_TABLES);

SELECT ah.USER_NAME, ah.ACCESSED_AT, st.TABLE_NAME FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY ah, LATERAL FLATTEN(input => ah.OBJECTS_ACCESSED) obj, SENSITIVE_TABLES st WHERE obj.value:"objectName" = st.TABLE_NAME;

What is the primary purpose of the ACCESS_HISTORY view in Snowflake?

To provide a real-time dashboard of current warehouse usage and credit consumption

To record which users accessed which objects, and how, for security and compliance auditing

To track all SQL statements executed in the account and their performance metrics

To store a log of all login attempts and authentication failures in the account

Snowflake SnowPro Advanced:Security Engineer

Domain 3Objective 3

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

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

21questions here

5free pages

7concepts

Questions 1–5

1application · hard
A security team wants to detect if any user has accessed a table that they should not have access to, based on a list of sensitive tables. They have a list of table names in a separate table called SENSITIVE_TABLES. Which query would identify accesses to these sensitive tables from ACCESS_HISTORY?
Select an answer first
2foundation · easy
What is the primary purpose of the ACCESS_HISTORY view in Snowflake?
Select an answer first
3foundation · easy
Which account usage view would you query to retrieve information about successful and failed login attempts?
Select an answer first
4foundation · easy
Which column in ACCESS_HISTORY indicates the time when the data access event occurred?
Select an answer first
5application · medium
A Snowflake account is on the Enterprise edition. A security team needs to audit data access for the past 6 months. They plan to query ACCESS_HISTORY. What is the maximum retention period they can rely on for this data?
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 1)

Questions 1–5

A security team wants to detect if any user has accessed a table that they should not have access to, based on a list of sensitive tables. They have a list of table names in a separate table called SENSITIVE_TABLES. Which query would identify accesses to these sensitive tables from ACCESS_HISTORY?

What is the primary purpose of the ACCESS_HISTORY view in Snowflake?

Which account usage view would you query to retrieve information about successful and failed login attempts?

Which column in ACCESS_HISTORY indicates the time when the data access event occurred?

A Snowflake account is on the Enterprise edition. A security team needs to audit data access for the past 6 months. They plan to query ACCESS_HISTORY. What is the maximum retention period they can rely on for this data?

Keep studying — Security Auditing and Compliance