DEA-C02 Data Governance Practice Question
Which governance tool allows an administrator to audit who accessed a specific table and when?
⚠ Common exam trap
Candidates often confuse ACCOUNT_USAGE views like ACCESS_HISTORY with INFORMATION_SCHEMA views, forgetting that ACCOUNT_USAGE has latency and records historical account-wide activity rather than current session metadata.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
ACCESS_HISTORY.
The ACCESS_HISTORY view within the SNOWFLAKE.ACCOUNT_USAGE schema is the definitive source for auditing data access. It captures comprehensive details, including the query ID, the user, the objects queried, and the columns accessed. This level of granularity is essential for compliance reporting and security monitoring, enabling administrators to identify potential data breaches or unauthorized access patterns across the entire account.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
QUERY_HISTORY.
Why it's wrong here
QUERY_HISTORY shows the text of the queries executed but lacks the column-level detail provided by ACCESS_HISTORY. While useful for general monitoring, it is insufficient for deep-dive governance audits that require understanding exactly which sensitive columns were accessed or viewed by a specific user or service account.
- ✓
ACCESS_HISTORY.
Why this is correct
ACCESS_HISTORY provides a detailed, audit-ready log of data access. It tracks which users accessed which tables, views, and columns. This is the standard tool for governance teams to verify compliance with data privacy regulations and ensure that only authorized roles are interacting with protected data assets.
- ✗
OBJECT_DEPENDENCIES.
Why it's wrong here
OBJECT_DEPENDENCIES shows the relationship between objects, such as which views depend on which tables. It does not record the history of who accessed those objects or when. While valuable for architectural understanding, it is not an audit or logging tool for user-level data access activities.
- ✗
The Security Dashboard.
Why it's wrong here
The Security Dashboard provides a high-level view of security settings and potential risks. It is not an audit log and does not allow for detailed, queryable access history for specific tables. Governance professionals must query the underlying ACCOUNT_USAGE views to perform deep-dive forensics and satisfy compliance requirements.
About these practice questions
Courseiva writes every DEA-C02 question from scratch — 229 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This DEA-C02 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C02 exam.