フリー問題

問題文

A telecommunications team runs OPTIMIZE nightly and their storage bill keeps growing. What explains this, and what should they add?

選択肢

1. The growth comes from the transaction log, which should be truncated manually.
2. OPTIMIZE writes new files while the old ones remain for time travel, so VACUUM must also be run to remove files that are no longer referenced and are past the retention threshold.
3. The growth comes from deletion vectors, which mark rows as removed without rewriting files, so they should be disabled to keep the file count from growing.
4. OPTIMIZE duplicates the data by design because it writes new files while the old ones remain, so it should be run less often to keep the total from growing. No further operation needs to be added.