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 website users to determine store locations information that is
stored in the Stores table of the database. You areasked 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 latitudeand 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.