The correct answer is A. JSON .
When unloading floating-point or high-precision numeric values, users must consider whether the target file format can preserve the values as needed. JSON stores values in a textual semi-structured representation and can preserve numeric values without forcing them into a fixed Parquet numeric precision representation.
Why A is correct:
For values that exceed a precision/scale such as (15,9) and must be preserved during unloading, JSON is the safest option among the listed choices because it can represent the values textually in the output.
Why the other options are incorrect:
B. PARQUET has limitations for certain numeric precision/scale representations during unload. Snowflake documentation notes precision-related considerations for Parquet unloads.
C. AVRO is a semi-structured file format, but it is not the best documented answer for preserving float values beyond this precision scenario.
D. ORC is not the best answer for this Snowflake unload precision scenario.
Official Snowflake documentation reference:
Snowflake documentation for unloading data explains that file format choice can affect how numeric values are represented and preserved. JSON is commonly used when preserving semi-structured or text-based representations is required.
[Reference: Snowflake Documentation — Unloading data; Snowflake Documentation — File format considerations; SnowPro Core Study Guide — Data Loading and Unloading., ========================]
