Given a dataset of sensor readings from IoT devices, which includes columns like device_id, reading_type, timestamp, and value. Describe how you would apply Delta Lake optimizations such as partitioning, z-ordering, and bloom filters to this dataset to enhance query performance. Consider the typical query patterns and the size of the dataset.

Simulated

Partition by device_id, z-order by timestamp, apply bloom filters on reading_type.

47.9%

Partition by reading_type, z-order by device_id, apply bloom filters on timestamp.

17.9%

Partition by timestamp, z-order by reading_type, apply bloom filters on device_id.

24.6%

Partition by value, z-order by timestamp, apply bloom filters on device_id._

9.6%

Databricks Certified Data Engineer - Professional