Microsoft
70-451 · Question #29
70-451 Question #29: Real Exam Question with Answer & Explanation
The correct answer is B. Change the XML data type to Typed XML.. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the FileStream data type.
- BChange the XML data type to Typed XML.
- CUse the HierarchyID data type to validate data.
- DSave the XML data in a standard table format. Specify the correct data types, constraints,
Community Discussion
No community discussion yet for this question.