PrepAway - Latest Free Exam Questions & Answers

You need to create a spatial index on the DeliveryPoint column

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply