Answer: Geography, Geometry

The question asks which data type can be used to store geospatial data in Snowflake. According to Snowflake documentation and the community discussion, Snowflake provides two data types for geospatial data: GEOGRAPHY and GEOMETRY. The GEOGRAPHY data type models Earth as a perfect sphere and is generally recommended for storing geospatial data like longitude/latitude coordinates. The GEOMETRY data type represents features in a planar coordinate system but was in preview status during the time of this discussion, making GEOGRAPHY the more established and reliable choice. The community discussion shows strong consensus for D (GEOGRAPHY) with 65% support, and several comments reference official documentation confirming both C and D are valid, but D is preferred for general geospatial use cases. Options A (Variant) and B (Object) are not specifically designed for geospatial data and are less suitable.

Author: LeetQuiz Editorial Team