Exam 70-461 topic 1 question 17 discussion

Actual exam question from Microsoft's 70-461

Question #: 17
Topic #: 1

You develop a Microsoft SQL Server 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 two Transact-SQL statements should you use? Each correct answer presents part of the solution.

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
B. EXECUTE dbo.GetCustomerRating 1745
C. DECLARE @CustomerRatingByCustomer INT DECLARE @Result INT EXECUTE @Result = dbo.GetCustomerRating 1745, @CustomerRatingByCustomer
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
E. DECLARE @CustomerRatingByCustomer INT EXECUTE dbo.GetCustomerRating @CustomerID = 1745, @CustomerRating = @CustomerRatingByCustomer OUTPUT
F. CREATE PROCEDURE dbo.GetCustomerRating @CustomerID INT AS DECLARE @Result INT SET NOCOUNT ON SELECT @Result = CustomerOrders/CustomerValue FROM Customers WHERE CustomerID = @CustomerID

Show Suggested Answer

Suggested Answer: AE 🗳️

by designsfactory at April 4, 2025, 11:05 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Exam 70-461 All Questions

View all questions & answers for the 70-461 exam

Exam 70-461 topic 1 question 17 discussion

Comments

SY0-701