
Answer-first summary for fast verification
Answer: DOUBLE
The question asks for a data type that can store floating-point numbers without losing precision. In Snowflake, DOUBLE is a synonym for FLOAT and is specifically designed for floating-point numbers with double precision (64-bit), which provides higher precision than FLOAT (32-bit) and avoids the precision limitations of INTEGER (which only stores whole numbers) and BINARY (which stores binary data). The community discussion, with 100% consensus and upvoted comments referencing Snowflake documentation, confirms that DOUBLE is the correct choice for floating-point numbers without precision loss.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.