Database DesignIntermediateDraft

Indexes and Performance Assessment

This assessment verifies the Indexes and Performance module. Passing it contributes up to 9 points in the 36-44 score band.

Questions

3

Limit

45m

Pass

85%

Score

+9

Question 1scenarioIntermediate

40 pts

Indexes and Performance

A production team is applying indexes and performance 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

Indexes and Performance review judgment

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

Question 3multiple-choiceIntermediate

25 pts

Indexes and Performance decision quality

Which answer best demonstrates professional judgment for indexes and performance?