AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Microsoft- 70-461





Question ID 15070

You develop a Microsoft SQL Server 2012 database.
You need to create and call a stored procedure that meets the following requirements:
✑ Accepts a single input parameter for CustomerID.
✑ Returns a single integer to the calling application.
Which Transact-SQL statement or statements should you use? (Each correct answer
presents part of the solution. Choose all that apply.)

Option A

CREATE PROCEDURE dbo.GetCustomerRating @CustomerID INT, @CustomerRating INT OUTPUT AS SET NOCOUNT ON SELECT @CustomerRating = CustomerOrders/CustomerValue FROM Customers WHERE CustomerID = @CustomerID RETURN GO

Option B

EXECUTE dbo.GetCustomerRating 1745

Option C

DECLARE @CustomerRatingByCustomer INT DECLARE @Result INT EXECUTE @Result = dbo.GetCustomerRating 1745, @CustomerRatingByCustomer

Option D

CREATE PROCEDURE dbo.GetCustomerRating @CustomerID INT, @CustomerRating INT OUTPUT AS SET NOCOUNT ON SELECT @Result = CustomerOrders/CustomerValue FROM Customers WHERE CustomerID = @CustomerID RETURN @Result GO

Option E

 DECLARE @CustomerRatingByCustomer INT EXECUTE dbo.GetCustomerRating @CustomerID = 1745, @CustomerRating = @CustomerRatingByCustomer OUTPUT

Option F

CREATE PROCEDURE dbo.GetCustomerRating @CustomerID INT AS DECLARE @Result INT SET NOCOUNT ON SELECT @Result = CustomerOrders/CustomerValue FROM Customers WHERE CustomerID = @CustomerID RETURNS @Result GO

Correct Answer A,E
Explanation


Question ID 15071

You have three tables that contain data for vendors, customers, and agents. You create a
view that is used to look up telephone numbers for these companies.
The view has the following definition:

You need to ensure that users can update only the phone numbers by using this view.
What should you do?

Option A

Alter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.

Option B

Drop the view. Re-create the view by using the SCHEMABINDING clause, and then create an index on the view. 

Option C

Create an AFTER UPDATE trigger on the view.

Option D

 Create an INSTEAD OF UPDATE trigger on the view.

Correct Answer D
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms187956.aspx

Send email to admin@getfreedumps for new dumps request!!!