Which file format will keep floating-point numbers from being truncated when data is unloaded?

The correct answer is D. Parquet. Parquet is a binary columnar file format that stores floating-point numbers using their exact IEEE 754 binary representation, preserving full precision without truncation. CSV is a text-based format and will convert floating-point values to decimal strings, which can lose…

Data Loading and Unloading

Question

Options

ACSV
BJSON
CORC
DParquet

How the community answered

(24 responses)

A
4% (1)
C
4% (1)
D
92% (22)

Explanation

Parquet is a binary columnar file format that stores floating-point numbers using their exact IEEE 754 binary representation, preserving full precision without truncation. CSV is a text-based format and will convert floating-point values to decimal strings, which can lose precision depending on the number of digits written. JSON also stores numbers as text and suffers from the same truncation issue. ORC is another binary columnar format, but Snowflake's UNLOAD documentation specifically highlights Parquet as the recommended format for preserving floating-point fidelity. When precision of numeric data matters in an unload scenario, Parquet is the correct choice.

Topics

#File Formats#Data Unloading#Floating-Point Numbers#Data Integrity

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice