COF-C02 · Question #54
Which data type can be used to store geospatial data in Snowflake?
The correct answer is D. Geography. Snowflake provides two dedicated geospatial data types: GEOGRAPHY and GEOMETRY. GEOGRAPHY (option D) represents Earth-surface-based spatial objects using the WGS 84 (latitude/longitude) coordinate system and is the primary, most widely used geospatial type in Snowflake for…
Question
Which data type can be used to store geospatial data in Snowflake?
Options
- AVariant
- BObject
- CGeometry
- DGeography
How the community answered
(49 responses)- A2% (1)
- C4% (2)
- D94% (46)
Explanation
Snowflake provides two dedicated geospatial data types: GEOGRAPHY and GEOMETRY. GEOGRAPHY (option D) represents Earth-surface-based spatial objects using the WGS 84 (latitude/longitude) coordinate system and is the primary, most widely used geospatial type in Snowflake for real-world location data. GEOMETRY (option C) uses a planar (Euclidean) coordinate system and is suited for local or projected coordinate spaces - both are valid geospatial types, but GEOGRAPHY is the canonical answer on certification exams. VARIANT (A) is a semi-structured type for JSON/Avro/XML, and OBJECT (B) is a key-value semi-structured type; neither is purpose-built for geospatial data.
Topics
Community Discussion
No community discussion yet for this question.