70-433 · Question #56
You are creating a table that stores the GPS location of customers. You need to ensure that the table allows you to identify customers within a specified sales boundary and to calculate the distance…
The correct answer is B. geography. The GEOGRAPHY data type is used to store ellipsoidal (round-earth) data. It is used to store latitude and longitude coordinates that represent points, lines, and polygons on the earth's surface. For example, GPS data that represents the lay of the land is one example of data…
Question
You are creating a table that stores the GPS location of customers. You need to ensure that the table allows you to identify customers within a specified sales boundary and to calculate the distance between a customer and the nearest store. Which data type should you use?
Options
- Ageometry
- Bgeography
- Cnvarchar(max)
- Dvarbinary(max) FILESTREAM
How the community answered
(35 responses)- A3% (1)
- B77% (27)
- C6% (2)
- D14% (5)
Explanation
The GEOGRAPHY data type is used to store ellipsoidal (round-earth) data. It is used to store latitude and longitude coordinates that represent points, lines, and polygons on the earth's surface. For example, GPS data that represents the lay of the land is one example of data that can be stored in the GEOGRAPHY data type.
Topics
Community Discussion
No community discussion yet for this question.