Understand the Features of Liquid Clustering and Predictive Optimization. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A data engineer wants to enable predictive optimization for a specific Delta table in their Databricks workspace. What is the correct way to do this?

   • ASet the table property `delta.autoOptimize = true`.
   • BRun `ALTER TABLE table_name ENABLE predictive_optimization`.
   • CRun `OPTIMIZE table_name ENABLE predictive_optimization`.
   • DUse the Databricks UI to enable predictive optimization globally for all tables.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is the primary purpose of Liquid Clustering in Delta Lake?

   • ATo automatically rewrite all data files to a fixed size for optimal storage
   • BTo improve query performance by organizing data files according to clustering keys, enabling better data skipping
   • CTo replace partitioning entirely, eliminating the need for any data layout strategy
   • DTo encrypt data at rest using Delta Lake's built-in encryption features
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is a key benefit of using Liquid Clustering and predictive optimization together?

   • AThey automatically scale compute resources based on query load
   • BThey provide real-time data replication across regions
   • CThey eliminate the need for any manual table maintenance
   • DThey improve query performance and reduce storage costs by maintaining an optimal data layout automatically
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A data engineer is creating a new Delta table that will be used for reporting. The table will be populated by a streaming job that appends data continuously. The queries will filter on `store_id` and `sale_date`. The engineer wants to enable Liquid Clustering during table creation. What should they do?

   • ACreate the table without clustering and then run `ALTER TABLE ... CLUSTER BY`.
   • BCreate the table and then run `OPTIMIZE ... CLUSTER BY`.
   • CInclude `CLUSTER BY (store_id, sale_date)` in the CREATE TABLE statement.
   • DUse `PARTITIONED BY (store_id, sale_date)` in the CREATE TABLE statement.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A company has enabled predictive optimization on a Delta table. After a few weeks, they notice that the table's query performance has improved, but they are unsure if the improvement is due to predictive optimization or other changes. What is the best way to attribute the performance improvement to predictive optimization?

   • ACheck the table's clustering keys and file count.
   • BReview the table's history and metrics to see when maintenance tasks were run and correlate with query performance.
   • CRun a benchmark query and compare with a similar table without predictive optimization.
   • DDisable predictive optimization and see if performance degrades.
   Reveal Solution Discussion Select an answer first