When unloading data, which file format preserves the data values for floating-point number columns?

The correct answer is D. Parquet. Parquet is the file format that preserves full precision for floating-point number columns when unloading data from Snowflake. CSV is a text-based format and can lose floating-point precision due to decimal representation limitations. JSON similarly uses text and may round…

Data Loading and Unloading

Question

Options

AAvro
BCSV
CJSON
DParquet

How the community answered

(42 responses)

B
2% (1)
C
2% (1)
D
95% (40)

Explanation

Parquet is the file format that preserves full precision for floating-point number columns when unloading data from Snowflake. CSV is a text-based format and can lose floating-point precision due to decimal representation limitations. JSON similarly uses text and may round floating-point values. Avro uses binary encoding but does not guarantee the same floating-point fidelity as Parquet, which stores numbers in their native binary IEEE 754 representation.

Topics

#Data Unloading#File Formats#Floating-point Precision#Parquet

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice