Question 100
A reviewer needs a focused diagnosis and proof of resolution for: A Copilot-generated search endpoint interpolates a user-supplied filter directly into SQL. Which check-to-acceptance pair addresses that specific condition?
Explanation
Correct Answer
The read-only check (review the query construction and run a negative test using harmless SQL metacharacter input) isolates the relevant issue, and the acceptance evidence (the negative test is interpreted as data rather than changing SQL structure) shows that its corresponding fix worked.
Incorrect Answers
This diagnostic and result belong to a different incident: A generated dependency update chooses an abandoned package with a misleadingly similar name. For 'A Copilot-generated search endpoint interpolates a user-supplied filter directly into SQL', examine review the query construction and run a negative test using harmless SQL metacharacter input and confirm that the negative test is interpreted as data rather than changing SQL structure.
This diagnostic and result belong to a different incident: An agent proposes to skip CI checks so a release can meet a deadline. For 'A Copilot-generated search endpoint interpolates a user-supplied filter directly into SQL', examine review the query construction and run a negative test using harmless SQL metacharacter input and confirm that the negative test is interpreted as data rather than changing SQL structure.
This diagnostic and result belong to a different incident: Two Copilot responses suggest different cache invalidation approaches for the same incident. For 'A Copilot-generated search endpoint interpolates a user-supplied filter directly into SQL', examine review the query construction and run a negative test using harmless SQL metacharacter input and confirm that the negative test is interpreted as data rather than changing SQL structure.



GitHub Copilot Practice Tests