SnowPro Core Certification — Question 616

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

Answer options

• A. (12,2)
• B. (10,4)
• C. (14,8)
• D. (15,9)

Correct answer: D

Explanation

The correct answer is D, as Snowflake truncates floating-point values to approximately 15 significant digits and 9 decimal places when unloading to CSV or JSON. Options A, B, and C represent truncation formats that do not accurately reflect Snowflake's handling of floating-point data in these file formats.