070-464 試験問題を無料オンラインアクセス

You need to implement a change to usp_ExportOpenings that meets the integration requirements.
What should you modify in usp_ExportOpenings? (Each correct answer presents part of the solution. Choose all that apply?)

• A.To line 10, add FOR XML AUTO.
• B.To line 10, add FOR XML RAW.
• C.To the end of line 04, add [Opening].
• D.To line 10, add FOR XMLEXPLICIT.
• E.To the end of line 05, add [Opening! title].
• F.To the end of line 06, add [Opening!salary!ELEMENT].
• G.To the end of line 04, add [Opening!ELEMENT].
• H.To the end of line 05, add [Opening!title!ELEMENT].
• I.To the end of line 06, add [Opening! salary].

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the following specifications:
Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time.
Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the storage requirements for the tables. Which options should you recommend? To answer, drag the appropriate options to the correct column in the answer area.

正解：

Explanation:
http://msdn.microsoft.com/en-us/library/cc280604.aspx
http://msdn.microsoft.com/en-us/library/ms186241.aspx

You need to ensure that a new execution plan is used by usp_GetOrdersByProduct each time the stored procedure runs.
What should you do?

• A.Execute sp_help 'usp_GetOrdersByProduct'.
• B.Add WITH RECOMPILE to line 03 in usp_GetOrdersByProduct.
• C.Add WITH (FORCESEEK) to line 07 in usp_GetOrdersByProduct.
• D.Execute sp_recompile 'usp_GetOrdersByProduct'.

You need to recommend a solution to ensure that SQL1 supports the auditing requirements of usp_UpdateEmployeeName.
What should you include in the recommendation?

• A.Change tracking
• B.Change data capture
• C.Transactional replication
• D.The Distributed Transaction Coordinator (DTC)

You need to implement a solution that addresses the performance issues of the usp_GetOrdersByProduct stored procedure.
Which statement should you execute?

• A.Option C
• B.Option A
• C.Option D
• D.Option B