Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
How would you model your data in Delta Lake to ensure fast and efficient queries for a reporting dashboard that handles time-sensitive data?
A
Normalize data across multiple Delta tables to minimize redundancy and save on storage costs.
B
Implement row-level security to filter data by time, thereby reducing query load times.
C
Denormalize data into wide tables and leverage Delta Lake's data skipping features on time columns.
D
Store all data in a single, large Delta table partitioned by time, such as by the hour of the day.