DEA-C02 Data Governance Practice Question
A data engineer needs to ensure that all queries against a table containing sensitive data are logged for compliance purposes. Which Snowflake feature should the engineer use to capture the query text and the user who executed it?
⚠ Common exam trap
Candidates often confuse Access History with Query History, assuming that Access History logs full query text when it only tracks column-level access.
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
✓
Query History in the ACCOUNT_USAGE schema.
Query History in ACCOUNT_USAGE is the correct feature to log query text and user information for compliance. It provides a complete record of all queries executed in the account. Access History is for column-level access, Login History is for authentication events, and Warehouse Metering History is for cost tracking. Only Query History captures the necessary details.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Login History in the ACCOUNT_USAGE schema.
Why it's wrong here
Login History records authentication events such as successful and failed logins, but it does not capture the queries executed by users. It is useful for security auditing of access attempts, but it does not provide the query text or the specific queries run against a table, so it fails to meet the requirement.
- ✗
Access History in the ACCOUNT_USAGE schema.
Why it's wrong here
Access History records which columns were read by a query, but it does not capture the full query text or the user who executed it. It is focused on data access auditing at the column level, not on query logging. Therefore, it does not meet the requirement to log query text and user information.
- ✓
Query History in the ACCOUNT_USAGE schema.
Why this is correct
Query History in the ACCOUNT_USAGE schema captures detailed information about every query executed, including the query text, the user who ran it, and the execution time. This is the standard Snowflake feature for auditing query activity and meets the requirement to log queries against the sensitive table.
- ✗
Warehouse Metering History in the ACCOUNT_USAGE schema.
Why it's wrong here
Warehouse Metering History provides information about warehouse usage and credit consumption, not about individual queries or users. It is used for cost management and performance monitoring, not for auditing query text or user activity. Thus, it is not suitable for this compliance requirement.
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.