最新MCTS 70-451（killtest提供）

aliload123

VUE/Prometric 考试号: 70-451

考题: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

MCTS 70-451考试题库由我们专业IT认证讲师及产品专家精心打造，包括了当前最新的全真70-451考试试题，全部附有正确答案。

所有购买我们“70-451题库”的客户，都将获得一年免费更新的售后服务，确保客户能一次性通过考试。

1. 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.

Answer: B

2. You need to design a method for storing large XML-formatted data. The design must meet the following requirements:

Minimize the page I/O Minimize the response time for data manipulation language (DML) queries

What should you do?

A. Store the XML data by using the filestream data type.

B. Store the XML data by using the nvarchar(max) data type.

C. Create columns based on XML elements. Shred the XML data into the individual columns.

D. Create columns based on Extensible Stylesheet Language Transformations (XSLT). Store the XML data by using the XML data type.

Answer: C

3. You are a database developer. You plan to design a database solution by using SQL Server 2008. A stored procedure uses the INSERT, UPDATE, and DELETE statements separately to load data into a table.

You need to rewrite the stored procedure to use a single statement to load the data.

What should you do?

A. Write a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT MATCHED BY TARGET clause.

B. Write a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT MATCHED BY SOURCE clause.

C. Write a MERGE statement by using a WHEN MATCHED clause, a WHEN NOT MATCHED BY TARGET clause, and a WHEN NOT MATCHED BY SOURCE clause.

D. Write a MERGE statement by using a WHEN MATCHED clause and two WHEN NOT MATCHED BY SOURCE clauses.

Answer: C

70-451题库根据考试厂商的动态变化而更新，在厂家每次对70-451考题做出修改或变题后，我们会在第一时间更新MCTS题库。确保考题的覆盖率始终都在96%以上。70-451RO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008.

免费PDF版本Demo下载