Home » Microsoft » MB6-886 » Which data type should you use for the column?
You are a database developer on an instance of SQL Server 2008. You are creating a tracking application. You want to create a column in one of your tables that stores GPS latitude and longitude coordinates.
Which data type should you use for the column?
A. xml
B. table
C. geometry
D. geography
Correct Answer: D
Explanation/Reference:
The geography data type represents data in a round-earth coordinate system. The geography data type is used to represent data as GPS latitude and longitude coordinates.
You should not use the xml data type because this data type is used to store XML data, such as XML documents or XML document fragments.
You should not use the table data type because this data type is used to store rows of data from a result set. The table data type can be processed later as needed, much like a temporary table. You can also pass table-valued parameters into stored procedures and functions for processing.
You should not use the geometry data type. The geometry data type represents data in a Euclidean, or flat, coordinate system.