Big Data File Formats — Learn free

Self-check

Questions 1–10 of 10

1. In a row file format, what happens when a user requests data from a single column?
Question 1A. Only that column is read into memoryB. The column is read from an index without touching the rowsC. The whole row is extracted into memory and the requested column is displayedD. The request is rejected because row formats cannot serve single columnsE. The file is converted to columnar format first
2. In a columnar file format, what is extracted into memory when a user requests one column?
Question 2A. Only that column's dataB. Every column of every rowC. The first row of every columnD. The whole file, then filteredE. A random sample of rows
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?
Question 3A. 5 columns with 1 million rowsB. 5 columns with a sample of rowsC. 100 columns with 5 rowsD. Nothing until the query completesE. All 100 columns with 1 million rows
4. Which file format type is best for ETL/ELT processing?
Question 4A. Columnar file formatB. Row file formatC. Compressed image formatD. Text-only formatE. Binary-only format
5. Which file format type is best for extracting data for analysis?
Question 5A. Row file formatB. Log file formatC. Human-readable formatD. Columnar file formatE. Nested file format
6. Which of the commonly used big data file formats are human-readable, in ASCII or Unicode text?
Question 6A. CSV and JSONB. ORC and AvroC. Parquet and ORCD. Avro and ParquetE. JSON and Parquet
7. Which file format is described as very CPU-intensive?
Question 7A. CSVB. ParquetC. ORCD. JSONE. Avro
8. If a dataset requires nested data, which file formats are recommended?
Question 8A. CSV, ORC and ParquetB. JSON, Avro and ParquetC. CSV and JSON onlyD. ORC and Avro onlyE. CSV, Avro and ORC
9. Which formats are said to provide some degree of schema evolution?
Question 9A. CSV and JSONB. CSV onlyC. JSON onlyD. CSV, JSON and ORCE. ORC, Avro and Parquet
10. What are the two normal kinds of data usage that should guide the choice of a big data file format?
Question 10A. Backup and restoreB. Encryption and compressionC. ETL/ELT processing and data extractionD. Streaming and batchE. Storage and archiving