Which file format will be the best for the following requirements? 
-> columnar 
-> efficient and fast performance for queries

Answer options:

A.Parquet
B.Avro
C.CSV
D.JSON

Correct Answer: A
Parquet is a column-based file format, which gives better performance in queries and efficiency compared to similar file formats.
Option A is correct: It is a columnar file format. Compared to other file formats in the option, it has the best performance and efficiency.
Option B is incorrect: Avro is a row-based format.
Options C and D are incorrect: These formats are less efficient and not fast performing compared to Parquet.
Reference: To know more, please refer to the docs below: 

https://docs.databricks.com/data/data-sources/read-parquet.html