Which data type can be used to store geospatial data in Snowflake?

Which data type can be used to store geospatial data in Snowflake?
A . Variant
B . Object
C . Geometry
D . Geography

View Answer

Answer: D

Explanation:

Snowflake supports two geospatial data types: GEOGRAPHY and GEOMETRY. The GEOGRAPHY data type is used to store geospatial data that models the Earth as a perfect sphere, which is suitable for global geospatial data. This data type follows the WGS 84 standard and is used for storing points, lines, and polygons on the Earth’s surface. The GEOMETRY data type, on the other hand, represents features in a planar (Euclidean, Cartesian) coordinate system and is typically used for local spatial reference systems. Since the question specifically asks about geospatial data, which commonly refers to Earth-related spatial data, the correct answer is GEOGRAPHY3.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide