Microsoft
70-432 · Question #58
70-432 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
Question
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named OrderIn in the instance. The OrderIn database contains a table which is named OrdeSend. A column named SendSite which is of the Geography data type has been added to the OrdeSend. The OrderSend table contains no indexes. On the SentSite point, you have to create a spatial index. What should you do first?
Options
- AYou must make sure that the SendSite column does not allow NULL values.
- BYou should define a primary key for the OrderSend table
- CFor the OrderSend table, you should create a clustered index
- DFirst, you should copy the OrderSend data to a temporary table,
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.