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.
