Online Access Free 70-464 Practice Test

You create a view by using the following code:

Several months after you create the view, users report that the view has started to return unexpected results.
You discover that the design of Table2 was modified since you created the view.
You need to ensure that the view returns the correct results.
Which code segment should you run?

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

You run the following code:

You need to ensure that the root node of the XML data stored in the Details column is <Order_Details>.
What should you implement?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.An XML index
• B.A user-defined data type
• C.A data manipulation language (DML) trigger
• D.An XML schema collection
• E.A Data Definition Language (DDL) trigger

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 execute the following code:

You need to select the task that has an IsFinished value of true from the Project that has an Id value of 1.
Which code segment should you use?

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

You need to implement a solution that solves the performance issues of
usp_GetOrdersAndItems.
Which statements should you execute?

• A.CREATE INDEX IX_Orders_Active ON Orders(DeliveryDate, Amount) WHERE ShipDate IS NULL
• B.CREATE INDEX IX_Orders_Active ON Orders(ShipDate, DeliveryDate)
  INCLUDE( Amount)
• C.CREATE INDEX IX_Orders_Active ON Orders(DeliveryDate) INCLUDE(Amount) WHERE ShipDate IS NULL
• D.CREATE INDEX IX_Orders_Active ON Orders(ShipDate, DeliveryDate, Amount)