COF-C03 Account Management and Data Governance Practice Question
A data administrator wants to ensure that all data access is audited. Where can they find a list of all tables accessed by a specific user?
⚠ Common exam trap
Candidates often suggest looking at QUERY_HISTORY, which only shows the text of the query, not the specific underlying objects or columns accessed by that query.
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, introduced to enhance Snowflake's governance capabilities, provides a comprehensive log of every object access event. It records which columns were queried and which tables were accessed by specific users. This tool is essential for compliance, allowing administrators to audit who accessed sensitive data and when, fulfilling regulatory requirements like GDPR or HIPAA that demand strict tracking of data usage.
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
While QUERY_HISTORY shows which queries were run, it does not provide the granular object-level details that ACCESS_HISTORY provides. It would be difficult to parse query strings to identify every table accessed. ACCESS_HISTORY is explicitly designed for this purpose and provides structured metadata on table access patterns.
- ✓
ACCESS_HISTORY.
Why this is correct
The ACCESS_HISTORY view contains a detailed record of all objects touched by every query. This is the primary source of truth for auditing data access patterns. It provides clear, structured information about which users accessed which tables, views, and columns, making it easy to generate audit reports.
- ✗
INFORMATION_SCHEMA.TABLES.
Why it's wrong here
The TABLES view in the INFORMATION_SCHEMA provides metadata about the structure of tables (e.g., column names, data types) but does not contain any historical audit information. It is designed for schema discovery, not for tracking the access history or usage patterns of the users in the system.
- ✗
LOGIN_HISTORY.
Why it's wrong here
LOGIN_HISTORY tracks when and how users connect to the Snowflake account. It does not contain any information about the queries they execute or the tables they access once a session is established. It is strictly for monitoring authentication, not for auditing data access activities.
About these practice questions
One of 280 original COF-C03 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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 COF-C03 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 COF-C03 exam.