Big Data File Formats
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. In a row file format, what happens when a user requests data from a single column?
2. In a columnar file format, what is extracted into memory when a user requests one column?
3. A file has 100 columns and 1 million rows, and a user queries only 5 columns. What does a row file format load into memory?
4. Which file format type is best for ETL/ELT processing?
5. Which file format type is best for extracting data for analysis?
6. Which of the commonly used big data file formats are human-readable, in ASCII or Unicode text?
7. Which file format is described as very CPU-intensive?
8. If a dataset requires nested data, which file formats are recommended?
9. Which formats are said to provide some degree of schema evolution?
10. What are the two normal kinds of data usage that should guide the choice of a big data file format?