Intermediate
Big Data & Data Engineering
Q72 / 100
Why is it generally recommended to avoid SELECT * in large-scale analytical queries?
Correct! Well done.
Incorrect.
The correct answer is A) It forces reading all columns even from columnar storage, increasing I/O and query cost unnecessarily
A
Correct Answer
It forces reading all columns even from columnar storage, increasing I/O and query cost unnecessarily
Explanation
In columnar formats, selecting only needed columns lets the engine skip reading irrelevant column data, reducing I/O, cost, and query time significantly.
Progress
72/100