Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Given a dataset of weather readings from various stations, which includes columns like station_id, temperature, humidity, and timestamp. 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._
A
Partition by station_id, z-order by timestamp, apply bloom filters on temperature._
B
Partition by temperature, z-order by station_id, apply bloom filters on humidity._
C
Partition by timestamp, z-order by temperature, apply bloom filters on station_id._
D
Partition by humidity, z-order by timestamp, apply bloom filters on temperature.