Database DesignIntermediateDraft

Transactions and Isolation Assessment

This assessment verifies the Transactions and Isolation module. Passing it contributes up to 8 points in the 45-52 score band.

Questions

3

Limit

45m

Pass

85%

Score

+8

Question 1scenarioIntermediate

40 pts

Transactions and Isolation

A production team is applying transactions and isolation under changing requirements. Identify the key constraint, choose a defensible approach, and explain what would fail if the wrong trade-off is made.

Question 2code-reviewIntermediate

35 pts

Transactions and Isolation review judgment

Review a proposed implementation related to transactions and isolation. Find the hidden risk, explain why it matters, and propose a safer alternative.

Question 3multiple-choiceIntermediate

25 pts

Transactions and Isolation decision quality

Which answer best demonstrates professional judgment for transactions and isolation?