Answer-first summary for fast verification
Answer: Given the table's small size (50 MB), removing partitioning would improve performance.
Correct Adding partitions to a small delta table, such as the 50 MB one described, can actually decrease performance. Since the table is already small, removing partitions would enable faster reads, as the overhead of managing partitions outweighs the benefits for tables of this size. More Info: Adding partitions to a Delta table
Author: LeetQuiz Editorial Team
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?
A
Switch the partitioning column to athlete_name to significantly reduce partition sizes.
B
Given the table's small size (50 MB), removing partitioning would improve performance.
C
Storing the data in CSV format would facilitate faster reads.
D
Querying the table as an admin would increase query speeds.
E
Partition the table on both year and athlete_name columns for better performance.
No comments yet.