SnowPro Core Certification — Question 1130

How can the ACCESS_HISTORY view in the ACCOUNT_USAGE schema be used to review the data governance settings for an account? (Choose two.)

Answer options

• A. Identify queries run by a particular user.
• B. Identify access to the roles given to a user.
• C. Identify SQL statements that failed to run.
• D. Identify objects that were modified by a query.
• E. Identify object dependencies.

Correct answer: A, D

Explanation

The correct answers, A and D, are relevant because the ACCESS_HISTORY view tracks which queries were executed by users and which objects were modified as a result. Options B, C, and E do not relate to the governance settings; B focuses on role access, C on failed queries, and E on dependencies, which are outside the scope of what ACCESS_HISTORY provides.