Microsoft
70-465 · Question #3
Drag and Drop Question You are planning to deploy a database to Windows Azure SQL Database. You need to design a stored procedure to update rows. The stored procedure must meet the following requireme
Sign in or unlock 70-465 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Submitted by tyler.j· Mar 5, 2026Design and implement database solutions for Azure SQL Database
Question
Drag and Drop Question You are planning to deploy a database to Windows Azure SQL Database. You need to design a stored procedure to update rows. The stored procedure must meet the following requirements: - If more than one row is updated, an error must be raised to the application and the update must be discarded. - The stored procedure must be designed to maximize concurrency. What should you include in the design? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:
Exhibit
Answer Area
Drag items
Raise an error in a catch block.Commit the transaction in a finally block.Read the @@ROWCOUNT system variable.Perform the update in a try block.Raise an error and roll back the transaction if the row count is less than 1.Issue a SELECT statement to count the number of rows.Set the isolation level to serializable.Begin an explicit transaction.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 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.
Topics
#Stored Procedures#Transactions#Error Handling#Concurrency