Design and Implement Scalable Data Models Using Delta Lake to Manage Large Datasets. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 6)

Questions 26–29

1. 26expert · hard

   A company has a Delta Lake table that stores customer orders. They need to retain data for 90 days for operational reporting, but they also need to keep the table performant. They run nightly jobs that update the table. They currently run VACUUM with a retention period of 7 days. What should they do to manage the table lifecycle?

   • AUse time travel to query only the last 90 days of data
   • BRun OPTIMIZE daily to compact files and retain all data
   • CRun VACUUM with a retention period of 90 days to keep all files
   • DDelete rows older than 90 days and then run VACUUM with a retention period of 7 days
   Reveal Solution Discussion Select an answer first
2. 27expert · hard

   A company has a Delta Lake table that stores web analytics data. The table is partitioned by `date`. Queries often filter on `page_url` and `user_id`. The team has noticed that queries are slow and want to improve performance. They are considering Z-ordering and partitioning. What should they do?

   • APartition by `page_url`
   • BPartition by `user_id`
   • CRun VACUUM to reduce the table size
   • DZ-order by `page_url` and `user_id`
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A data engineering team manages a large Delta Lake table that stores clickstream data. The table is partitioned by `date` and `hour`. Queries often filter on `session_id` and `campaign_id`. The team has noticed that queries are slow and want to improve performance. They are considering Z-ordering and partitioning. What should they do?

   • APartition by `session_id`
   • BPartition by `campaign_id`
   • CZ-order by `session_id` and `campaign_id`
   • DRun VACUUM to reduce the table size
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   A data engineer wants to improve the performance of queries that frequently filter on a specific column with high cardinality. Which Delta Lake optimization technique is most appropriate?

   • ADisabling statistics collection
   • BVACUUM with a short retention period
   • CZ-ordering on that column
   • DAdding more partitions
   Reveal Solution Discussion Select an answer first