When ingesting data into watsonx.data for analytics; which target file format is recommended for new tables to maximize query performance?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Parquet with Iceberg table management is the recommended combination for analytical workloads: Parquet provides efficient columnar storage and compression; Iceberg adds ACID transactions; partition pruning; and time travel.
Full explanation below image
Full Explanation
Parquet with Iceberg table management is the recommended combination for analytical workloads: Parquet provides efficient columnar storage and compression; Iceberg adds ACID transactions; partition pruning; and time travel. The incorrect options ("CSV because it is human-readable and widely supported", "JSON because it supports nested structures without schema definition", "Avro because it is the only format supported by both Kafka and Presto") are distractors that don't fully capture the concept described.