Databricks-DE-Pro Data Governance Practice Question
A data engineer needs to audit which users have accessed a Unity Catalog table containing sensitive data. They want to see a record of all queries that read from the table over the past 30 days. Which Unity Catalog feature should they use?
⚠ Common exam trap
The trap here is assuming data lineage tracks user access, but it only tracks data flow, not individual queries.
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
✓
Audit logs
Audit logs in Unity Catalog record all access and query activities, including the user, timestamp, and the tables accessed. They are essential for security auditing and compliance. Data lineage, information schema, and Delta transaction logs serve different purposes and do not provide a record of user access.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Delta transaction log
Why it's wrong here
The Delta transaction log records changes to the table (inserts, updates, deletes) and metadata operations, but it does not track read access by users. It is used for time travel and data versioning, not for auditing user queries. It cannot answer who accessed the table.
- ✗
Data lineage
Why it's wrong here
Data lineage shows the flow of data between tables and columns, including upstream and downstream dependencies, but it does not record individual user access events or query history. It is useful for impact analysis, not for auditing who accessed a table.
- ✗
Information schema
Why it's wrong here
The information schema provides metadata about tables, columns, and privileges, but it does not contain a history of data access events. Querying information_schema.tables or .columns will not reveal who read the table. It is used for discovery and permission auditing, not access auditing.
- ✓
Audit logs
Why this is correct
Audit logs capture detailed information about user activities, including queries executed against Unity Catalog tables. They record who accessed what data and when, making them the correct choice for auditing access to sensitive tables. Audit logs are stored in the metastore's storage location and can be queried for analysis.
About these practice questions
One of 267 original Databricks-DE-Pro 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 Databricks exam blueprint
This Databricks-DE-Pro practice question is part of Courseiva's free Databricks 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 Databricks-DE-Pro exam.