Microsoft
70-433 · Question #104
70-433 Question #104: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #104. The question stem and answer options stay visible for context.
Question
You have a table named Orders. You have been tasked to modify your company's main database to remove all inactive order rows. You are developing a stored procedure that will enable you to delete these rows. You have written the following code segment to accomplish this task. (Line numbers are included for reference only.) 01 BEGIN TRY 02 DECLARE @RowCount INT = 1000 03 WHILE @RowCount = 1000 04 BEGIN 05 DELETE TOP (1000) FROM Orders WHERE Status = 'Inactive'; 06 SET @RowCount = @@ROWCOUNT 07 ... 08 END 09 END TRY 10 BEGIN CATCH 11 PRINT ERROR_MESSAGE() 12 END CATCH You need to insert a Transact-SQL statement that will notify you immediately after each batch of rows is deleted. Which Transact-SQL statement should you insert at line 07?
Options
- ARAISERROR ('Deleted %i rows', 6, 1, @RowCount)
- BRAISERROR ('Deleted %i rows', 16, 1, @RowCount)
- CRAISERROR ('Deleted %i rows', 10, 1, @RowCount) WITH NOWAIT
- DRAISERROR ('Deleted %i rows', 11, 1, @RowCount) WITH NOWAIT
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.