A security analyst is reviewing ACCESS_HISTORY for signs of unauthorized access. They notice that a user accessed a table but the query failed with a permission error. They want to confirm whether the user actually saw any data. Which column in ACCESS_HISTORY would help determine if the access was successful?

Join with QUERY_HISTORY on QUERY_ID to check the EXECUTION_STATUS

A security analyst wants to identify users who accessed a sensitive table outside of normal business hours. Which approach using ACCESS_HISTORY is most appropriate?

Filter ACCESS_HISTORY for the sensitive table and check the ACCESSED_AT timestamps for unusual hours

Check LOGIN_HISTORY for users who logged in outside business hours

Query QUERY_HISTORY for all queries and look for those with high execution time

Review WAREHOUSE_METERING_HISTORY for credit usage spikes

A security engineer is investigating a potential data exfiltration incident. They need to identify which users accessed a sensitive table outside of normal business hours (9 AM–5 PM) in the last month. Which columns from ACCESS_HISTORY should they use to filter the results?

ACCESSED_AT and OBJECTS_ACCESSED

Snowflake SnowPro Advanced:Security Engineer

Domain 3Objective 3

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

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

21questions here

5free pages

7concepts

Questions 6–10

6expert · hard
A security analyst is reviewing ACCESS_HISTORY for signs of unauthorized access. They notice that a user accessed a table but the query failed with a permission error. They want to confirm whether the user actually saw any data. Which column in ACCESS_HISTORY would help determine if the access was successful?
Select an answer first
7foundation · easy
To find which objects were accessed by a specific query, which column in ACCESS_HISTORY should you examine?
Select an answer first
8foundation · easy
A security analyst wants to identify users who accessed a sensitive table outside of normal business hours. Which approach using ACCESS_HISTORY is most appropriate?
Select an answer first
9application · easy
A database administrator wants to review the history of all queries run by a specific user in the last 24 hours, including the SQL text and the warehouse used. Which account usage view should they query?
Select an answer first
10application · medium
A security engineer is investigating a potential data exfiltration incident. They need to identify which users accessed a sensitive table outside of normal business hours (9 AM–5 PM) in the last month. Which columns from ACCESS_HISTORY should they use to filter the results?
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 2)

Questions 6–10

To find which objects were accessed by a specific query, which column in ACCESS_HISTORY should you examine?

A security analyst wants to identify users who accessed a sensitive table outside of normal business hours. Which approach using ACCESS_HISTORY is most appropriate?

A database administrator wants to review the history of all queries run by a specific user in the last 24 hours, including the SQL text and the warehouse used. Which account usage view should they query?

A security engineer is investigating a potential data exfiltration incident. They need to identify which users accessed a sensitive table outside of normal business hours (9 AM–5 PM) in the last month. Which columns from ACCESS_HISTORY should they use to filter the results?

Keep studying — Security Auditing and Compliance