Identify the Benefits of Using Liquid Clustering over Partitioning and ZOrder. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 5)

Questions 21–23

1. 21foundation · easy

   What is a common drawback of static partitioning when a table is partitioned by a column with many distinct values?

   • AIt automatically balances data across partitions, ensuring uniform file sizes without any manual intervention.
   • BIt leads to over-partitioning, creating many small files that degrade query performance and increase metadata overhead.
   • CIt prevents the use of predicate pushdown, forcing full table scans for all queries.
   • DIt causes data skew, where some partitions contain significantly more data than others, but this is always beneficial for query pruning.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A financial services firm maintains a Delta table of transaction records. They currently use Z-ORDER on account_id after each daily batch. However, they notice that query performance degrades throughout the day as new transactions are inserted, and they must run OPTIMIZE multiple times per day. They want a solution that maintains data layout automatically between batches. What should they do?

   • ARun OPTIMIZE with Z-ORDER more frequently, such as every hour.
   • BUse a streaming merge to update the Z-ORDER index continuously.
   • CSwitch to liquid clustering on account_id.
   • DPartition the table by account_id.
   Reveal Solution Discussion Select an answer first
3. 23application · medium

   A data engineering team is designing a new Delta table for a social media analytics platform. The table will store user engagement events, and queries will filter by user_id (high cardinality) and event_type (low cardinality). The data will be appended continuously. They want to minimize maintenance overhead while ensuring good query performance. Which configuration should they choose?

   • AUse Z-ORDER on both user_id and event_type without partitioning.
   • BPartition by user_id and event_type.
   • CPartition by event_type and Z-ORDER on user_id.
   • DEnable liquid clustering on user_id and event_type.
   Reveal Solution Discussion Select an answer first