Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 627

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

    Correct Answer: D

    When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9). This means the values are truncated to 15 digits of precision and 9 digits after the decimal point.

Discussion
HarpreetwalOption: D

D Correct: https://docs.snowflake.com/en/user-guide/data-unload-considerations

nexerSnowOption: D

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9). The values are not truncated when unloading floating-point number columns to Parquet files.

HeetecOption: D

d correct

MultiCloudIronManOption: D

correct

Kelvin_YuOption: D

https://docs.snowflake.com/en/user-guide/data-unload-considerations#:~:text=When%20floating%2Dpoint%20number%20columns%20are%20unloaded%20to%20CSV%20or%20JSON%20files%2C%20Snowflake%20truncates%20the%20values%20to%20approximately%20(15%2C9).