CERTIFIED-MACHINE-LEARNING-PROFESSIONAL · Question #20
A machine learning engineering team has written predictions computed in a batch job to a Delta table for querying. However, the team has noticed that the querying is running slowly. The team has alrea
Sign in or unlock CERTIFIED-MACHINE-LEARNING-PROFESSIONAL to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
A machine learning engineering team has written predictions computed in a batch job to a Delta table for querying. However, the team has noticed that the querying is running slowly. The team has already tuned the size of the data files. Upon investigating, the team has concluded that the rows meeting the query condition are sparsely located throughout each of the data files. Based on the scenario, which of the following optimization techniques could speed up the query by colocating similar records while considering values in multiple columns?
Options
- AZ-Ordering
- BBin-packing
- CWrite as a Parquet file
- DData skipping
- ETuning the file size
Unlock CERTIFIED-MACHINE-LEARNING-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-MACHINE-LEARNING-PROFESSIONAL questions. Unlock CERTIFIED-MACHINE-LEARNING-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.