Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
In a proof of concept involving the Olympics dataset, a data engineer filters the data to include only participants who have won at least one gold medal, reducing the delta table size to 50 MB. To optimize read speeds, the table is partitioned by the year column, resulting in partitions of about 2 MB each. Which of the following strategies would further enhance read performance?
In a proof of concept involving the Olympics dataset, a data engineer filters the data to include only participants who have won at least one gold medal, reducing the delta table size to 50 MB. To optimize read speeds, the table is partitioned by the year column, resulting in partitions of about 2 MB each. Which of the following strategies would further enhance read performance?
Real Exam
A
Switch the partitioning column to athlete_name to significantly reduce partition sizes.
9.9%
B
Given the table's small size (50 MB), removing partitioning would improve performance.
Comments
Loading comments...