Question 27
Domain 4: Assembling and Deploying ApplicationsWhich index type automatically stays aligned with an underlying Delta table as the table changes?
Correct answer: C
Explanation
A Delta Sync index stays aligned because it is built to “automatically” track changes in the underlying Delta table. As the table updates, the index is refreshed from the Delta source, so it remains synchronized without manual reindexing.
Why each option is right or wrong
A. Direct Vector Access index
Direct Vector Access is a different index access pattern, not the auto-synced Delta-table index.
B. SQL warehouse cache
SQL warehouse cache speeds query access; it does not maintain a Delta-table-aligned vector index.
C. Delta Sync index
Delta Sync indexes are the Databricks vector index type designed to remain synchronized with a source Delta table as rows are inserted, updated, or deleted, so no manual rebuild is needed after table changes. In the Databricks Vector Search docs, a Delta Sync index is explicitly backed by a Delta table and is kept current by automatic synchronization, unlike a direct-access index which is not tied to ongoing table refreshes.
D. MLflow model registry
MLflow model registry stores model versions and metadata, not search indexes for Delta tables.