Which data type should you use to replace the text data types in the application?

You are the database administrator for your company. You upgrade a SQL Server 2000 computer named SQL1 to SQL Server 2008.
You configure the SQLServer:Deprecated Features performance object to monitor the useof features that have been deprecated in SQL Server 2008.
During the monitoring process, you discover that the text , ntext , and image data types are being used in an application on SQL1.
You want to modify the data types in the application to ensure that these data types are not encountered by the SQLServer:Deprecated Features performance object.
Which data type should you use to replace the text data types in the application?

A.
char

B.
nchar

C.
varchar

D.
varchar(max)

Explanation:

You should use the varchar(max) data type to replace the text data types. Several features have beendeprecated in SQL Server 2008. The use of these deprecated features can be monitored by using the SQLServer:Deprecated Features performance object and trace events. When you configure the SQLServer:Deprecated Features performance object on an instance of SQL Server 2008, the use of text , ntext ,or image data types is also monitored by SQL Server. Because these data types are no longer supported, youshould modify the application to replace these data types. You can use the nvarchar(max) data type to replace ntext data types, and you can use the varbinary(max) data type can to replace image
data types. You should not use the char , nchar , or varchar data types to replace the text data types in the application. The char , nchar , and varchar data types do not support large amounts of data. Therefore, it is recommended thatyou use the varchar(max) , nvarchar(max) , and varbinary(max) data types instead of the text , ntext , and image data types.

Objective:
Optimizing SQL Server Performance

Sub-Objective:
Use Performance Studio.

References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > MonitoringResource Usage (System Monitor) > Using SQL Server Objects > SQL Server, Deprecated Features Object MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started > Initial Installation > Upgrading to SQLServer 2008 > Backward Compatibility > SQL Server Database Engine Backward Compatibility > DeprecatedDatabase Engine Features in SQL Server 2008