Iceberg

Which of the following statements is true about Iceberg metadata management?

• Iceberg metadata is stored in Hive metastore only
• Iceberg requires a separate database to manage metadata
• Iceberg uses manifest and metadata files for tracking snapshots and table state
• Iceberg does not support schema evolution

Which of the following storage formats is best suited for Iceberg tables?

• JSON
• Parquet
• TXT
• Avro

Why is Parquet considered an efficient storage format for analytical queries?

• It stores data in a row-wise format
• It does not support compression
• It stores data in a columnar format, allowing for efficient scans and It also maintains metadata at footer level for data pruning
• It can only be used with Hive

Which type of workload benefits the most from columnar storage formats like Parquet in Trino?

• OLTP (Online Transaction Processing)
• OLAP (Online Analytical Processing)
• High-frequency trading
• Log file storage

How do manifest files improve query performance in Trino when reading Iceberg tables?

• By storing query results for reuse
• By reducing the number of files read by tracking relevant data files
• By compressing the entire dataset
• By creating multiple copies of data files

Which of the following is a key advantage of Iceberg over Hive for managing large datasets?

• Iceberg supports time travel, schema evolution more efficiently
• Hive performs better for analytical queries
• Iceberg requires the use of Hadoop
• Hive automatically optimizes table formats

What is a significant limitation of Hive compared to Iceberg when it comes to managing metadata?

• Hive stores metadata in metastore, which can become a bottleneck
• Hive metadata is stored in Parquet files
• Hive does not support metadata management
• Iceberg requires an external metadata database

How does Iceberg handle DELETE operations differently from Hive?

• Iceberg maintains delete markers without modifying original data files
• Hive allows row-level DELETE operations without rewriting data
• Iceberg does not support DELETE operations
• Hive and Iceberg handle DELETE operations the same way

How does Iceberg store table metadata compared to Hive?

• Iceberg stores metadata in Hive Metastore, while Hive stores metadata in the filesystem
• Iceberg uses a metadata tree structure with snapshots and manifest files, while Hive relies on the metastore
• Both Iceberg and Hive store metadata in JSON files
• Hive stores metadata in PostgreSQL, while Iceberg does not use a metadata store

Which metadata component in Iceberg tracks all changes made to the table over time?

• Manifest files
• Manifest list
• Metadata JSON file
• Hive Metastore