Databricks-DE-Assoc Governance and Security Practice Question
A data engineer needs to ensure that all queries against a Unity Catalog table are logged for audit purposes. The logs must include the user identity, the query text, and the timestamp. Which Databricks feature should be enabled to capture this information?
⚠ Common exam trap
Many exam-takers confuse query history, which is user-facing and limited, with audit logs, which are comprehensive and intended for security auditing.
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 are the Databricks feature designed to capture detailed activity logs, including query text, user identity, and timestamps. They are essential for security auditing and compliance. Enabling audit logs and configuring delivery to a central system meets the requirement to log all queries against Unity Catalog tables.
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 in Databricks SQL stores recently executed queries for each user, but it is primarily for user convenience and debugging. It does not provide a centralized, tamper-evident audit trail and may not retain all queries or include the necessary details for compliance. It is not the appropriate feature for comprehensive audit logging.
- ✗
Unity Catalog data lineage
Why it's wrong here
Data lineage in Unity Catalog tracks the flow of data across tables and columns, showing dependencies and transformations. It does not record individual query executions, user identities, or timestamps. While useful for understanding data provenance, it is not an audit logging mechanism and cannot provide the required query-level audit trail.
- ✗
Delta Live Tables event log
Why it's wrong here
The Delta Live Tables event log records events related to pipeline execution, such as data quality expectations and pipeline updates. It does not capture ad-hoc queries against Unity Catalog tables. Therefore, it cannot fulfill the requirement of logging all queries for audit purposes.
- ✓
Audit logs
Why this is correct
Audit logs in Databricks capture detailed information about user activities, including query text, user identity, and timestamps. They are designed for security and compliance auditing. Enabling audit logs and delivering them to a central location satisfies the requirement to log all queries against Unity Catalog tables. This is the correct feature to use.
About these practice questions
Courseiva writes every Databricks-DE-Assoc question from scratch — 276 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 Databricks exam blueprint
This Databricks-DE-Assoc 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-Assoc exam.