Microsoft
70-432 · Question #58
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…
The correct answer is B. You should define a primary key for the OrderSend table. See the full explanation below for the reasoning.
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,
How the community answered
(32 responses)- A9% (3)
- B72% (23)
- C3% (1)
- D16% (5)
Community Discussion
No community discussion yet for this question.