Check · Graded

Module assessment

This checks that you can explain the key ideas and apply them safely. Complete and pass the SQL lab before you submit.

What you need to do

Answer every question.
Submit your answers.
Read your result and review any suggested sections.

You need at least 80% and a passed SQL lab. If you do not pass, you will get direct feedback and can try again.

Knowledge check · about 8 minutes

Answer every question

Choose the safest answer for each workplace situation. Your passed SQL lab is already saved to your account, so there is no lab work or certificate form on this page.

Pass mark: 80%0 of 3 answered

Question 1 of 3What evidence should an operator collect before acting on transactions, locks, and deadlocks?

A deployment DDL statement is blocking customer writes behind an idle transaction, and the operator must restore service safely.

waiting sessionsA broad configuration change without a baselineA restart before recording the reported symptoms

Question 2 of 3Which response best preserves a rollback path while the diagnosis is verified?

A deployment DDL statement is blocking customer writes behind an idle transaction, and the operator must restore service safely.

Apply every plausible change at the same timeMap waiters to the root blockerDiscard the evidence after the first improvement

Question 3 of 3What must be true before the practical objective can be considered complete?

A deployment DDL statement is blocking customer writes behind an idle transaction, and the operator must restore service safely.

The operator has changed a setting, regardless of outcomeThe dashboard no longer shows the original alert for one minuteThe root blocker is documented, the chosen intervention avoids unnecessary session loss, and blocked work resumes or has a clear escalation.

Answer every question to enable submission.