Question 790
A team reviews AI-suggested indexes but cannot explain the expected workload or reproduce the performance benefit. What should the SQL developer do next?
Explanation
Correct Answer
Suggestions are hypotheses until verified against the actual query and update workload.
Incorrect Answers
Create and maintain appropriate GitHub Copilot instruction files referencing the project's schema, naming and deployment conventions: create and maintain appropriate GitHub Copilot instruction files referencing the project's schema, naming and deployment conventions: repository-level instructions supply relevant context but still require review of generated changes; Require a representative benchmark and plan comparison before accepting AI-suggested indexes into a migration.
Supply the authorized schema and dependency context before evaluating the generated procedure in an isolated project: supply the authorized schema and dependency context before evaluating the generated procedure in an isolated project: context-poor generation may assume database objects that do not exist.
Use an eligible organization-approved model and confirm data-handling controls before submitting the query: use an eligible organization-approved model and confirm data-handling controls before submitting the query: model and tool configuration must respect enterprise policy rather than developer convenience.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests