What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance to manage and maintain its databases. The SQL Server 2008 instance contains a
database named CK_DB that has a table named CK_Tbl. You then add a Geography data type
column named CK_Colmn to CK_Tbl. The Domain.com management also wants CK_Colmn to
make allowance for the development of a spatial index.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance to manage and maintain its databases. The SQL Server 2008 instance contains a
database named CK_DB that has a table named CK_Tbl. You then add a Geography data type
column named CK_Colmn to CK_Tbl. The Domain.com management also wants CK_Colmn to
make allowance for the development of a spatial index.

What should you do?

A.
You should consider creating a clustered index for CK_Tbl.

B.
You should consider creating a primary key for CK_Tbl.

C.
You should consider creating a default index for CK_Tbl.

D.
You should consider creating a secondary key for CK_Tbl.



Leave a Reply 0

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