Online Access Free 70-464 Practice Test

You have a database that uses the following management views:
Sys.dm_os_volume_stats
Sys.dm_db_partition_stats
Sys.dm_db_file_space_usage
Sys.fulltext_indexes
You plan to migrate the database to Microsoft SQL Azure.
You need to identify which view can be used in SQL Azure.
Which view should you identify?

• A.sys.fulltext_indexes
• B.sys.dm_db_file_space_usage
• C.sys.dm_os_volume_stats
• D.sys.dm_db_partition_stats

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_recompile usp.GetOrdersByProduct'.
• B.Add WITH RECOMPILE to line 64 in usp.GetOrdersByProduct.
• C.Add WITH (FORCESEEK) to line 69 in usp.GetOrdersByProduct.
• D.Execute sp_help usp_GetOrdersByProduct\

You need to implement a solution that addresses the bulk insert requirements.
What should you add to line 08 in usp_ImportOrderDetails?

• A.BATCHSIZE=1000.
• B.LASTROW=0.
• C.LASTROW = 1000.
• D.BATCHSIZE=0.

You need to build a stored procedure that amortizes the invoice amount. Which code segment should you use to create the stored procedure? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Correct Answer:

1 - EXEC sp_configure 'clr enabled','1';
2 - RECONFIGURE;
3 - CREATE ASSEMBLY TaxCalc FROM 'C:\temp\TreyTax.DLL'
4 - CREATE PROCEDURE Accounting.Amortize(@total decimal(8,2), @period int) RETURNS decimal(8,2) AS EXTERNAL NAME TaxCalc TreyResearch.Amortize; Explanation:
http://msdn.microsoft.com/en-us/library/ms131089.aspx
http://msdn.microsoft.com/en-us/library/ms131048.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx

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 data capture
• B.The Distributed Transaction Coordinator (DTC)
• C.Change tracking
• D.Transactional replication