You maintain a SQL Server 2008 instance that contains a database named OrderEntry. The
OrderEntry database contains a table named OrderDelivery.
You add a column named DeliveryPoint to the OrderDelivery table. The DeliveryPoint
column is of the Geography data type. The OrderDelivery table does not contain indexes.
You need to create a spatial index on the DeliveryPoint column.
What should you do first?
A.
Define a primary key for the OrderDelivery table.
B.
Create a clustered index for the OrderDelivery table.
C.
Ensure that the DeliveryPoint column does not allow NULL values.
D.
Copy the OrderDelivery data to a temporary table and truncate the existing OrderDelivery
table.