Which data type can be used for floating-point numbers without losing precision?

The correct answer is D. DOUBLE. DOUBLE (also aliased as FLOAT or REAL in Snowflake) is a 64-bit IEEE 754 double-precision floating-point type, offering approximately 15–17 significant decimal digits of precision. Among the choices provided, it is the only type designed to represent fractional/floating-point…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

ABINARY
BVARIANT
CINTEGER
DDOUBLE

How the community answered

(43 responses)

A
5% (2)
B
2% (1)
C
2% (1)
D
91% (39)

Explanation

DOUBLE (also aliased as FLOAT or REAL in Snowflake) is a 64-bit IEEE 754 double-precision floating-point type, offering approximately 15–17 significant decimal digits of precision. Among the choices provided, it is the only type designed to represent fractional/floating-point values. BINARY stores raw byte sequences, VARIANT stores semi-structured data (JSON/XML/Avro), and INTEGER stores only whole numbers without any fractional component. While true arbitrary-precision decimal storage would use NUMERIC/NUMBER/DECIMAL types, DOUBLE is the correct answer here given the available options and is Snowflake's highest-precision floating-point type.

Topics

#Data types#Floating-point#Precision#DOUBLE data type

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice