Kvíz spojený s průvodcem · Střední úroveň

Parquet and Columnar Formats for ML Data Quiz

Understand Parquet’s column chunks, row groups, compression, and pruning, then test performance against the actual ML workload.

Související vodicí cestyParquet And Columnar Formats For ML
Otázka 1 z 8

How is data organized in a Parquet file?

Náhled každé otázky8 otázky

Odpovědi a vysvětlení se zobrazují, jak budete v kvízu.

  1. How is data organized in a Parquet file?
    • Only as comma-separated text lines
    • As one unstructured binary blob
    • As one database row per file
    • Into row groups containing column chunks, which contain pages
  2. Why can columnar storage help a query that reads only a few fields?
    • Every row is stored as a separate file
    • A reader may fetch selected columns without reading every column’s data
    • It automatically removes all null values
    • It guarantees a faster model
  3. What role can Parquet statistics or page indexes play?
    • They provide a full database index for every query
    • They guarantee zero I/O
    • They may help compatible readers skip pages or row groups that cannot match a filter
    • They store model weights
  4. What does a row group contain?
    • A column chunk for each column in that logical row partition
    • Only metadata with no data
    • One row only
    • A separate model checkpoint
  5. When might Parquet be less suitable than another storage design?
    • For any machine-learning workload
    • When data contain numeric values
    • When data are larger than a spreadsheet
    • For workloads dominated by tiny random row lookups or frequent single-row updates
  6. Why benchmark on the target engine and storage system?
    • All Parquet readers behave identically
    • Compression never affects performance
    • Feature support and performance depend on reader, layout, and workload
    • Benchmarks are unrelated to data format
  7. What can improve statistics-based pruning?
    • Randomizing every row across all files
    • Organizing data so common filter columns have useful value ranges
    • Removing column metadata
    • Increasing CSV quoting
  8. Does Parquet alone provide table transactions and dataset version history?
    • No; those require surrounding table-management or catalog features
    • Yes, every Parquet file has ACID transactions
    • Yes, it stores every prior dataset version forever
    • No, because Parquet cannot store schemas