DA0-002 Data Governance Practice Question
Exhibit
Refer to the exhibit. ``` 2024-11-20 10:23:45 [ACCESS_DENIED] user: analyst_john, query: SELECT email FROM customers WHERE id=123, reason: insufficient permissions on column 'email' ```
A data analyst reports being unable to run the query shown in the exhibit. The data governance team reviews the access control policy. Which of the following is the most likely explanation for the denied 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
✓
Column-level security is preventing access to the email column
The log explicitly states 'insufficient permissions on column email', indicating column-level security. Option A is wrong because the log does not mention table-level privilege issues. Option B is wrong because the role status is not indicated in the log. Option D is wrong because the query syntax is correct.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The user does not have SELECT privilege on the customers table
Why it's wrong here
The log indicates column-level denial, not table-level.
- ✗
The database administrator revoked the analyst role
Why it's wrong here
There is no evidence of role revocation.
- ✓
Column-level security is preventing access to the email column
Why this is correct
The log specifically mentions insufficient permissions on the email column.
- ✗
The query syntax is incorrect
Why it's wrong here
The query syntax is valid.
Go deeper
Related to this question
About these practice questions
One of 986 original DA0-002 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.