DA0-002 Materialized view Practice Question
Exhibit
Refer to the exhibit. Error log: ``` 2025-03-15 10:23:45 ERROR: ORA-12034: materialized view log on "SCHEMA"."SALES" is newer than last refresh 2025-03-15 10:23:45 INFO: Refresh of materialized view "SALES_MV" failed ```
A data analyst sees this error in the ETL logs. What is the most likely cause?
⚠ Common exam trap
CompTIA Data+ often tests the distinction between incremental (fast) and full refreshes. Candidates may confuse a source modification with a dropped table or permission issue, but the error message specifically points to a change in the underlying data after the last refresh, not to structural or permission problems.
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
✓
The underlying data source was modified after the last refresh
The error indicates that the materialized view's underlying data has changed since its last refresh. Materialized views rely on change tracking (e.g., logs or timestamps) to perform incremental refreshes. If the source data was modified after the last refresh, the view cannot be incrementally refreshed—a full refresh is required instead. This mismatch between the view's snapshot and the source data is a common cause of refresh failures in ETL processes.
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 underlying data source was modified after the last refresh
Why this is correct
The log is newer, indicating changes that need a full refresh.
- ✗
The source table was dropped
Why it's wrong here
Dropping would cause a different error.
- ✗
The analyst does not have permission to refresh the view
Why it's wrong here
The error is about log timing, not permissions.
- ✗
There is a network connection timeout
Why it's wrong here
Connection timeout would show a timeout error.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 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 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.