Which two data types can you configure for the CustAddress column to perform the required task?

You are responsible for managing an instance of SQL Server 2008 named SQL1 . SQL1 contains a databasenamed Customers.
The Customers database contains a table named CustDetails . You want to create a spatialindex on a column named CustAddress.
Which two data types can you configure for the CustAddress column to perform the required task? (Choose two.Each correct answer represents a complete solution.)

A.
sql_variant

B.
geography

C.
ntext

D.
geometry

E.
table

Explanation:

You can configure the CustAddress column as a geography or geometry data type. SQL Server 2008 providessupport for spatial data, which identifies geographic locations and shapes. You can create a spatial index on acolumn of a table that contains spatial data. SQL Server 2008 allows you to create spatial indexes only oncolumns that have the geography or geometry data type. The geography data type represents data in a round-earth coordinate system, such as latitude and longitude coordinates. The geometry data type represents data ina Euclidean or flat coordinate system. To be able to create a spatial index on a table, you must ensure that thetable has a primary key. To create spatial indexes, you can either use the CREATE SPATIAL INDEX Transact-SQL statement or SQL Server Management Studio. You cannot create a spatial index on columns of the sql_variant , ntext , and table data types. The sql_variant data type enables a single column, variable, or parameter to store values of different data types. The ntext datatype is a variable-length data type that is used for storing large non-Unicode and Unicode character and binarydata. The table data type is a special data type that allows you to store a result set for processing at a later time.

Objective:
Performing Data Management Tasks

Sub-Objective:
Maintain indexes.

References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Development > Designing andImplementing Spatial Storage (Database Engine) > Working with Spatial Indexes (Database Engine) >Restrictions on Spatial Indexes
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Development > Designing andImplementing Spatial Storage (Database Engine) > Working with Spatial Indexes (Database Engine) > SpatialIndexing Overview