Microsoft 70-469 New Updated Exam Questions Download From Braindump2go Freely(1-15)

QUESTION 1
You use SQL Server 2014 to maintain the data used by applications at your company.
You want to execute two statements.
You need to guarantee that either both statements succeed, or both statements fail together as a batch.
Which code should you use?

clip_image001_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb

 

A.    Option A
B.    Option B
C.    Option C
D.    Option D
E.    Option E

Answer: D
Explanation:
Structure should be:
BEGIN TRY
BEGIN TRANSACTION
..
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
END CATCH.
TRY…CATCH (Transact-SQL)

 

Read more