Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance to manage and maintain its databases.
The SQL Server 2008 instance includes a database that has a table, named ABC_Tbl. You then
configure ABC_Tbl to include a Geography data type column, named ABC_Colmn.
You have been instructed to devise a solution that makes allowance for ABC_Colmn to include a
spatial index.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance to manage and maintain its databases.
The SQL Server 2008 instance includes a database that has a table, named ABC_Tbl. You then
configure ABC_Tbl to include a Geography data type column, named ABC_Colmn.
You have been instructed to devise a solution that makes allowance for ABC_Colmn to include a
spatial index.
Which of the following actions should you take?

A.
You should consider configuring ABC_Colmn with a primary key.

B.
You should consider configuring ABC_Tbl with a primary key.

C.
You should consider configuring ABC_Tbl with a clustered index.

D.
You should consider configuring ABC_Colmn with a clustered index.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *