Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
In a cricket match, every ball bowled is recorded in a delta table, including the bowler's name, batter's name, and runs scored, via manual INSERT statements. After 350 matches, read queries on this table are slower than on other tables of similar size. What efficient technique can the data engineer employ to address this issue?
In a cricket match, every ball bowled is recorded in a delta table, including the bowler's name, batter's name, and runs scored, via manual INSERT statements. After 350 matches, read queries on this table are slower than on other tables of similar size. What efficient technique can the data engineer employ to address this issue?
Real Exam
A
Convert the data to CSV format to enhance read speed.
1.2%
B
Implement the OPTIMIZE command on the delta table to consolidate smaller files into larger ones.
Comments
Loading comments...