You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will contain a table that will store customer data as XML data. The data
supports an application that cannot be altered. You plan to prevent the following types of
errors in the XML data. ·NULL values in the Customer Name field ·Non-numeric values in
the Customer Telephone field. ·Invalid values in the Gender field You need to implement the
plan without modifying the application. What should you do?
A.
Use the FileStream data type.
B.
Change the XML data type to Typed XML.
C.
Use the HierarchyID data type to validate data.
D.
Save the XML data in a standard table format. Specify the correct data types,
constraints, and NOT NULL parameters in the standard table.