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 connections, configuration, and memory?

A web application begins rejecting requests after its pool fans out idle sessions, while the database host has limited memory headroom.

A broad configuration change without a baselineconnection statesA restart before recording the reported symptoms

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

A web application begins rejecting requests after its pool fans out idle sessions, while the database host has limited memory headroom.

Apply every plausible change at the same timeDiscard the evidence after the first improvementMeasure active and idle connection demand

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

A web application begins rejecting requests after its pool fans out idle sessions, while the database host has limited memory headroom.

Authorised workload connections recover, the leak or pool behaviour is addressed, and the memory trade-off is recorded.The operator has changed a setting, regardless of outcomeThe dashboard no longer shows the original alert for one minute

Answer every question to enable submission.