Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Discuss the importance of choosing the right file format for storing data in a data lake. How do different file formats like Parquet, ORC, and Avro impact query performance and storage efficiency?
Discuss the importance of choosing the right file format for storing data in a data lake. How do different file formats like Parquet, ORC, and Avro impact query performance and storage efficiency?
Simulated
A
Parquet and ORC are columnar formats that are highly efficient for read-heavy workloads and support advanced optimizations like predicate pushdown and column pruning.
93.2%
B
Avro is the best choice for all scenarios due to its compact size and efficient serialization, which makes it superior for both storage and query performance.
Comments
Loading comments...