How do you suspend and resume Automatic Clustering for a clustered table ?

• A. ALTER TABLE ... SUSPEND / RESUME AUTOMATIC
• B. ALTER TABLE ... SUSPEND
• C. ALTER CLUSTER ... SUSPEND
• D. ALTER TABLE ... SUSPEND / RESUME RECLUSTER

Answer: (D)

Automatic Clustering can be paused and restarted on a clustered table using explicit table-level commands that target the automatic clustering feature. To pause it, run a statement like ALTER TABLE your_table SUSPEND AUTOMATIC; to resume, run ALTER TABLE your_table RESUME AUTOMATIC;. These commands simply control the background clustering workload for that table.

The RECLUSTER option is for manually running a clustering pass on the existing data and is separate from suspending or resuming the automatic clustering process.