Exam 70-761 topic 1 question 109 discussion

there is no order in the query so no guarantee what returned record is in top so answer is no

We depend on the shortest distance not on the same city. Answer should B

the ^ symbol being used here is just wrong...i thought answer to question was No as soon as i saw the ^ symbol

Can anybody illuminate on the role of operator ^ used in this question. ^ is used as exclusive OR but it is used on bitmasks like integer type values. It does not have any meaning on geography type variables

I think there should be YES. Example: drop table [TSQLV4].[HR].[customers] create table [TSQLV4].[HR].[customers] ( customerid int identity (1,1), Deliverylocation geography ) set identity_insert [TSQLV4].[HR].[customers] on insert into [TSQLV4].[HR].[customers] (customerid) values (1),(2),(3) UPDATE [TSQLV4].[HR].[customers] SET Deliverylocation = geography::Point( 40.854078, -73.869043 ,4326 ) where customerid =1 -- bronx zoo, closest to wsq, far to airport UPDATE [TSQLV4].[HR].[customers] SET Deliverylocation = geography::Point( 40.730581, -73.997732 ,4326 ) where customerid =2 --washigton square park closest to airport UPDATE [TSQLV4].[HR].[customers] SET Deliverylocation = geography::Point( 40.657440, -73.776462,4326 ) where customerid =3 -- airport jfk declare @id int = 3 select top 1 b.customerid, a.Deliverylocation.STDistance(b.deliverylocation) as dist from [TSQLV4].[HR].[customers] as a cross join [TSQLV4].[HR].[customers] as b where a.customerid = @id and a.customerid <> b.customerid order by dist