Question 880
Copilot proposes dropping a large unique index to improve insert throughput. Initial testing shows: Writes improve only when integrity tests and read workloads continue to pass. Which limitation should the team still consider?
Explanation
Correct Answer
Plan cost savings can hide data corruption risk from lost constraints. AI performance advice must be checked for integrity and workload consequences.
Incorrect Answers
That residual-risk statement assumes an invalid guarantee: Database constraints protect integrity under concurrency; performance advice cannot ignore them.
This limitation misstates what the feature provides: Understand index purpose and dependencies before changing performance-sensitive integrity controls.
This is not the governing limitation because Balance DML wins against data integrity and representative read behavior before release. That assertion removes or misidentifies the relevant residual risk and does not follow from the feature semantics.