You have multiple stored procedures inside a transaction. You need to ensure that all the data modified by the transaction is rolled back if a stored procedure causes a deadlock or times out. What should you do?
A.
Use the NOLOCK option.
B.
Execute the DBCC UPDATEUSAGE statement.
C.
Use the max worker threads option.
D.
Use a table-valued parameter.
E.
Set SET ALLOW_SNAPSHOT_ISOLATION to ON.
F.
Set SET XACT_ABORT to ON.
G.
Execute the ALTER TABLE T1 SET (LOCK_ESCALATION = AUTO); statement.
Suggested Answer:F🗳️
When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-xact-abort-transact-sql?view=sql-server-2017
This section is not available anymore. Please use the main Exam Page.70-762 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
lh2607
Highly Voted 4 years, 5 months ago