Understanding Snowflake Data Types

What is the purpose of explicit casting in Snowflake?

• To convert a VARCHAR to a TIMESTAMP using the TIME_SLICE() function

• To automatically convert data types when necessary

• To handle date and time information

• To represent spatial features on the Earth's surface

Which of the following data types in Snowflake are synonymous with NUMBER?

• INT, INTEGER, BIGINT, SMALLINT, TINYINT, BYTEINT

• FLOAT, FLOAT4, FLOAT8, DOUBLE, DOUBLE PRECISION, REAL

• DATE, TIME, TIMESTAMP

• GEOGRAPHY, GEOMETRY

What is the default precision and scale for the NUMBER data type in Snowflake?

• (38,0)

• (10,2)

• (20,5)

• (15,3)

Which Snowflake data type is ideal for storing longitude and latitude coordinates?

• GEOGRAPHY

• GEOMETRY

• NUMBER

• VARCHAR

What is the main difference between GEOGRAPHY and GEOMETRY data types in Snowflake?

• GEOGRAPHY models the Earth as a sphere, while GEOMETRY uses a planar coordinate system

• GEOGRAPHY supports 3D coordinates, while GEOMETRY supports 2D coordinates

• GEOGRAPHY is used for numerical data, while GEOMETRY is used for text data

• GEOGRAPHY is for temporal data, while GEOMETRY is for spatial data

A repository of data that's controlled by one department or business unit and isolated from the rest of an organisation, much like grass and grain in a farm silo are closed off from outside elements is a

Organise these options into the right categories

Groups:

(a) numeric

,

(b) text

,

(c) temporal

,

(d) geospatial

• temperature

• addresses

• name

• time

• date

• age

• weight

• code

• income

• region

• eye colour

• coordinates

• year

• address

• email

• duration

Which point is located at 120°, 60°?