Home / Data Engineer Associate / Objective 6.4

Domain 6: Troubleshooting, Monitoring, and Optimization · 10% of the exam · Full exam outline

6.4 Understand the features of Liquid Clustering and predictive optimization.

Practice questions

Question 1medium

A schema has predictive optimization enabled. Its managed table orders_m shows automatic OPTIMIZE and VACUUM operations in its history, but the external table orders_x in the same schema never does. What explains the difference?

Included in Master: master every domain.See plans
Question 2easy

An engineer runs ALTER TABLE events CLUSTER BY (device_id, event_type) on a liquid-clustered table that was previously clustered on other keys. What happens to the data already in the table?

Included in Master: master every domain.See plans