Does REFRESH TABLE Identify Delta Table Maintenance?

DP-600 By islever Editorial Last updated

Maintain the analytics development lifecycle

Short answer

B Running REFRESH TABLE only refreshes cached metadata and does not identify if maintenance tasks were performed.

Question

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?
  1. Yes
  2. No Correct Answer

Key Takeaways

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.

Common mistake: Choosing Yes because REFRESH TABLE sounds like it updates or maintains the table, when it actually provides no historical insight into past maintenance operations.

Expert Analysis

Why the Answer Is Correct

The correct answer is No because the REFRESH 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 assumes REFRESH 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 that REFRESH 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."

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.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 3 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 3

  1. 282b85d 👍 6 Answered B
    No, running REFRESH TABLE customer does not meet the goal of identifying whether maintenance tasks were performed on the Delta table. This Spark SQL command is used to refresh the metadata of a table. It ensures that the latest schema and data are available for queries but does not give any historical information about maintenance operations.
  2. stilferx 👍 1 Answered B
    IMHO, NOOO
  3. dp600 👍 1 Answered B
    correct

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Fabric Deployment Pipeline Folder Structure Behavior

S-grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-grade

Displaying All Rows in Power BI Python Visuals

S-grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide