Microsoft Exam Questions

Which data type should you use?

You are designing a database that contains a data definition language (DDL) trigger. The
DDL trigger will provide the maximum amount of data available when any attempt is made
to change the database schema. You need to design a table to meet the following
requirements: ·Accept the EVENTDATA information that is provided by the trigger ·Support
the searching and retrieval of nodes and values ·Minimize development time Which data
type should you use?

A.
XML

B.
nvarchar(max)

C.
varchar(max)

D.
varbinary