nerdexam
SnowflakeSnowflake

COF-C02 · Question #54

COF-C02 Question #54: Real Exam Question with Answer & Explanation

The correct answer is D: Geography. 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 stori

Snowflake Cloud Data Platform Features and Architecture

Question

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

Options

  • AVariant
  • BObject
  • CGeometry
  • DGeography

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

Topics

#Data types#Geospatial data#GEOGRAPHY data type

Community Discussion

No community discussion yet for this question.

Full COF-C02 PracticeBrowse All COF-C02 Questions