SnowPro Core Certification — Question 620

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

Answer options

• A. CSV
• B. JSON
• C. ORC
• D. Parquet

Correct answer: D

Explanation

The correct answer is D, Parquet, as it is designed to handle complex data types and retains precision for floating-point numbers. In contrast, CSV (A) and JSON (B) may not maintain the same level of precision for floating-point numbers due to their simplistic nature. ORC (C) also supports precision but is not as widely used as Parquet for this specific need.