Exam 70-461 topic 1 question 195 discussion

Actual exam question from Microsoft's 70-461

Question #: 195
Topic #: 1

You develop a database application for Microsoft SQL Server and Microsoft Azure SQL Database.
You need to raise an exception and transfer execution to a CATCH block.
You need to ensure that the exception returns output in the following format:
Msg 51000, Level 16, State 1, Line 1
The record does not exist.
Which Transact-SQL statement should you run?

A. DECLARE @Message NVARCHAR(2048); SELECT @Message = FORMATMESSAGE('The record does not exist.'); THROW 51000 , 1 , @Message
B. THROW 51000 , 'The record does not exist.' , 1
C. THROW ERROR_MESSAGE ('The record does not exist.'), 1
D. THROW 51000 , FORMATMESSAGE('The record does not exist.') , 1

Show Suggested Answer

Suggested Answer: B 🗳️
The following example shows how to use the THROW statement to raise an exception.
THROW 51000, 'The record does not exist.', 1;
Here is the result set.
Msg 51000, Level 16, State 1, Line 1
The record does not exist.
References:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/throw-transact-sql?view=sql-server-2017

by Dimples205 at Oct. 7, 2020, 4:54 p.m.

Comments

Submit Cancel

Dimples205

4 years, 8 months ago

I say its A. According to the book, for THROW; "The message parameter does not allow formatting, but you can use FORMATMESSAGE with a variable to get the same effect."

upvoted 1 times

...