Option A is correct. The
VECTOR
data type supports elements of 32-bit integers (
INT
) or 32-bit floating-point numbers (
FLOAT
), and its dimension can be a positive integer value with a maximum of 4096. Option B is correct. The syntax for specifying a VECTOR type is VECTOR(,
. The example

demonstrates this structure. Option C is incorrect. Direct vector comparisons (e.g.,

) are byte-wise lexicographic and do not produce the expected results for number comparisons; therefore, dedicated vector similarity functions should be used. Option D is incorrect. Vectors are explicitly not supported in VARIANT columns. Option E is correct. SQL examples in the documentation demonstrate explicit casting of array literals to the VECTOR data type, such as

, when used with vector similarity functions.