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 index design and access paths?

A customer lookup is timing out during a write-heavy campaign, and a proposed multicolumn index must be justified before rollout.

A broad configuration change without a baselinequery predicates and orderingA restart before recording the reported symptoms

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

A customer lookup is timing out during a write-heavy campaign, and a proposed multicolumn index must be justified before rollout.

Apply every plausible change at the same timeDiscard the evidence after the first improvementEstablish the workload and baseline plan

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

A customer lookup is timing out during a write-heavy campaign, and a proposed multicolumn index must be justified before rollout.

The chosen index serves the demonstrated predicate and order, with a documented cost to writes and storage.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.