Question 810
Copilot proposes dropping a large unique index to improve insert throughput. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
AI performance advice must be checked for integrity and workload consequences. Reject or redesign advice that removes necessary uniqueness and benchmark safe alternatives. Writes improve only when integrity tests and read workloads continue to pass.
Incorrect Answers
That change leaves the underlying defect unresolved: Database constraints protect integrity under concurrency; performance advice cannot ignore them.
The proposed implementation creates the wrong boundary because Understand index purpose and dependencies before changing performance-sensitive integrity controls.
This step would not produce the required behavior: Balance DML wins against data integrity and representative read behavior before release. This alternative omits a necessary contract or control and leaves the tested failure path open.