Does REFRESH TABLE Identify Delta Table Maintenance?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Customer. When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table. You need to identify whether maintenance tasks were performed on Customer. Solution: You run the following Spark SQL statement: REFRESH TABLE customer - Does this meet the goal?
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
This question tests the purpose of Spark SQL commands on Delta tables, with the common trap of confusing a metadata cache refresh with maintenance history tracking.
Running REFRESH TABLE on a Delta table only updates cached metadata and does not reveal if maintenance tasks like OPTIMIZE or VACUUM were performed. This page establishes that REFRESH TABLE fails to meet the goal of identifying maintenance history.
Choosing Yes because REFRESH TABLE sounds like it updates or maintains the table, when it actually provides no historical insight into past maintenance operations.
Community Discussion (4 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The correct answer is No because theREFRESH TABLE statement is designed solely to invalidate and refresh cached data and metadata for a table. It does not output any historical or operational records regarding whether maintenance tasks such as OPTIMIZE or VACUUM have been executed on the Delta table.Why the Other Options Are Wrong
Option A (Yes) is incorrect because it assumesREFRESH TABLE provides diagnostic or historical information about table maintenance. To actually identify if maintenance was performed, you must inspect the Delta transaction log, for example by using the DESCRIBE HISTORY command.Community Comment Notes
The community correctly agrees thatREFRESH TABLE does not meet the goal. As one user noted, the command "is used to refresh the metadata of a table" and "does not give any historical information about maintenance operations." Official Reference
Exam Strategy
When asked about identifying maintenance history on a Delta table, look for commands that expose the Delta log or transaction history, such as DESCRIBE HISTORY. Do not confuse commands that update metadata caches with those that report on past operations.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →