You are modifying a database that is used as a backend for a web site. The web site developers want
to include positional data that can be used by the web site users to determine store locations
information that is stored in the Stores table of the database. You are asked to add a column to the
Stores table. What data type should you use?
A.
varchar
B.
nvarchar
C.
geography
D.
GPS
Explanation:
The geography data type is used to hold spatial data. Geography is a .NET common language runtime
(CLR) data type that can store
ellipsoidal (round-earth) data such as GPS latitude and longitude coordinates.
The geometry data type is a planar spatial data type that is implemented as a common language
runtime (CLR) data type in SQL Server. This
type represents data in a Euclidean (flat) coordinate system.