Courts finished retention-approved cleanup of obsolete bronze PDF path files and need to reclaim storage. Which command fits?
Select an answer to reveal the explanation.
Short Explanation
After records retention says those old PDF paths can go, VACUUM is the dumpster run that actually frees your storage. OPTIMIZE after cleanup still only compacts your retained files, and ANALYZE after cleanup just refreshes your planner stats, so neither one deletes your obsolete files. Changing your retention setting just changes how long you'll keep history, but it won't reclaim your space either.
Full Explanation
After courts finish retention-approved cleanup of obsolete bronze PDF path files and need to reclaim storage, they should run VACUUM to remove unreferenced Delta data files and free space. VACUUM is the storage-reclamation step that follows retention policy approval; without it, obsolete files can linger and continue billing municipal storage even after logical cleanup. OPTIMIZE after retention-approved cleanup to reclaim storage for obsolete bronze files fails because OPTIMIZE rewrites and compacts retained data files for better query layout, but it does not remove unreferenced obsolete files or reclaim storage freed by retention-approved cleanup. ANALYZE after retention-approved cleanup to reclaim storage for obsolete bronze files fails because ANALYZE only updates statistics used by the query planner; it does not delete obsolete bronze files or reduce the storage footprint. SET retention after retention-approved cleanup to reclaim storage for obsolete bronze files fails because setting retention only changes how long transaction history is preserved for audit recovery, not physical removal of unreferenced data files, so it does not reclaim storage from obsolete bronze files. Exam caveat: DP-750 separates logical cleanup and retention approval from VACUUM’s physical reclaim—both matter, and VACUUM is the reclaim command. Operational check: confirm retention approval, ensure the table’s retention duration setting is respected, run VACUUM on the bronze path, and verify storage metrics drop for obsolete PDF data files.
Prefer to study offline? Printable PDF study book + test engine ($7.50, unofficial). These questions stay free here.