You need to update the CreateMonthlyTotalsReports() method to use database transactions.
Which code segment should you use?
A.
SqlConnection.BeginTransaction(IsolationLevel.ReadCommitted);
B.
SqlConnection.BeginTransaction(IsolationLevel.ReadUnconwited);
C.
SqlConnection.BeginTransaction(IsolationLevel.Chaos);
D.
SqlConnection.BeginTransaction(IsolationLevel.Serializable);
Explanation:
D
There is a missing requirement:
“The Create MonthlyTotalsReport() method must lock the data and prevent others from updating or inserting new rows until complete.”
Correct answer D
+1
Correct answer D