Question 240 An assistant proposes a new query using an unfamiliar SQL function. Which implementation is the best fit? Use pull-request review for AI-assisted schema changes Use grounded workspace context before relying on Copilot schema suggestions Validate AI-generated SQL in a nonproduction test database Limit MCP tool credentials to least privilege Explanation Correct Answer C:This implementation detects incorrect joins, DDL and resource usage before deployment. Incorrect Answers A:This choice obtains tracked review and branch protection before integration. This does not meet the need for a method that detects incorrect joins, DDL and resource usage before deployment. B:This alternative reduces hallucinated tables and obsolete column names. This does not meet the need for a method that detects incorrect joins, DDL and resource usage before deployment. D:This alternative confines damage from malformed agent calls or prompt injection. This does not meet the need for a method that detects incorrect joins, DDL and resource usage before deployment.
Question 241 A generated SQL prompt includes confidential customer rows copied from production traces. What is the most appropriate next design step? Use an approved MCP server endpoint for structured SQL tool access Review sensitive schema and data before allowing an AI coding assistant to access repository context Use approved GitHub Copilot organization policies for developer access Use repository-level Copilot instruction files to encode project conventions Explanation Correct Answer B:This implementation reduces accidental exposure of regulated information to an external assistant. Incorrect Answers A:This option provides tool-mediated operations under explicit permissions rather than raw credential sharing. This does not meet the need for a method that reduces accidental exposure of regulated information to an external assistant. C:That technique enforces centralized enablement and allowed models/features. This does not meet the need for a method that reduces accidental exposure of regulated information to an external assistant. D:This alternative gives code generation stable repository-specific context. This does not meet the need for a method that reduces accidental exposure of regulated information to an external assistant.
Question 242 An assistant that suggests indexes must not be able to delete production tables. What should the SQL developer implement? Require parameterized queries from AI-generated application code Limit MCP tool credentials to least privilege Validate AI-generated SQL in a nonproduction test database Keep secret values out of prompts and checked-in instruction files Explanation Correct Answer B:Limit MCP tool credentials to least privilege fits because it confines damage from malformed agent calls or prompt injection. That addresses the stated technical constraint. Incorrect Answers A:This choice prevents injection when input is untrusted. This does not meet the need for a method that confines damage from malformed agent calls or prompt injection. C:This choice detects incorrect joins, DDL and resource usage before deployment. This does not meet the need for a method that confines damage from malformed agent calls or prompt injection. D:This option prevents credential disclosure and repository leakage. This does not meet the need for a method that confines damage from malformed agent calls or prompt injection.
Question 243 A Copilot response proposes dynamic SQL with unescaped user input. Which approach would you recommend? Treat suggested AI-generated DDL as untrusted until validated Use approved GitHub Copilot organization policies for developer access Review sensitive schema and data before allowing an AI coding assistant to access repository context Use repository-level Copilot instruction files to encode project conventions Explanation Correct Answer A:Treat suggested AI-generated DDL as untrusted until validated fits because it requires human review, tests and security checks before use. That addresses the stated technical constraint. Incorrect Answers B:This choice enforces centralized enablement and allowed models/features. This does not meet the need for a method that requires human review, tests and security checks before use. C:That technique reduces accidental exposure of regulated information to an external assistant. This does not meet the need for a method that requires human review, tests and security checks before use. D:This choice gives code generation stable repository-specific context. This does not meet the need for a method that requires human review, tests and security checks before use.
Question 244 Copilot offers a search endpoint that interpolates raw customer names into SQL text. Which approach would you recommend? Validate AI-generated SQL in a nonproduction test database Limit MCP tool credentials to least privilege Require parameterized queries from AI-generated application code Use grounded workspace context before relying on Copilot schema suggestions Explanation Correct Answer C:This implementation prevents injection when input is untrusted. Incorrect Answers A:This choice detects incorrect joins, DDL and resource usage before deployment. This does not meet the need for a method that prevents injection when input is untrusted. B:This choice confines damage from malformed agent calls or prompt injection. This does not meet the need for a method that prevents injection when input is untrusted. D:This choice reduces hallucinated tables and obsolete column names. This does not meet the need for a method that prevents injection when input is untrusted.
Question 245 A Copilot-assisted procedure change is ready for merge but lacks an approved reviewer. What should the SQL developer implement? Limit MCP tool credentials to least privilege Validate AI-generated SQL in a nonproduction test database Require parameterized queries from AI-generated application code Use pull-request review for AI-assisted schema changes Explanation Correct Answer D:This approach obtains tracked review and branch protection before integration. Incorrect Answers A:This choice confines damage from malformed agent calls or prompt injection. This does not meet the need for a method that obtains tracked review and branch protection before integration. B:This alternative detects incorrect joins, DDL and resource usage before deployment. This does not meet the need for a method that obtains tracked review and branch protection before integration. C:This option prevents injection when input is untrusted. This does not meet the need for a method that obtains tracked review and branch protection before integration.
Question 246 A Fabric development assistant must call an approved lakehouse tool without passing personal database passwords. Which implementation is the best fit? Use an approved MCP server endpoint for structured SQL tool access Review sensitive schema and data before allowing an AI coding assistant to access repository context Verify the selected AI model and connector permissions in chat configuration Treat suggested AI-generated DDL as untrusted until validated Explanation Correct Answer A:This implementation provides tool-mediated operations under explicit permissions rather than raw credential sharing. Incorrect Answers B:This option reduces accidental exposure of regulated information to an external assistant. This does not meet the need for a method that provides tool-mediated operations under explicit permissions rather than raw credential sharing. C:This alternative prevents unapproved model choice or excessive tool access. This does not meet the need for a method that provides tool-mediated operations under explicit permissions rather than raw credential sharing. D:This choice requires human review, tests and security checks before use. This does not meet the need for a method that provides tool-mediated operations under explicit permissions rather than raw credential sharing.
Question 247 A SQL connection string with a client secret is about to be pasted into an assistant chat. What should the engineer choose? Keep secret values out of prompts and checked-in instruction files Use pull-request review for AI-assisted schema changes Require parameterized queries from AI-generated application code Use grounded workspace context before relying on Copilot schema suggestions Explanation Correct Answer A:Keep secret values out of prompts and checked-in instruction files fits because it prevents credential disclosure and repository leakage. That addresses the stated technical constraint. Incorrect Answers B:This choice obtains tracked review and branch protection before integration. This does not meet the need for a method that prevents credential disclosure and repository leakage. C:That technique prevents injection when input is untrusted. This does not meet the need for a method that prevents credential disclosure and repository leakage. D:That technique reduces hallucinated tables and obsolete column names. This does not meet the need for a method that prevents credential disclosure and repository leakage.
Question 248 SQL suggestions omit required schema qualification despite written repository standards. Which approach would you recommend? Verify the selected AI model and connector permissions in chat configuration Treat suggested AI-generated DDL as untrusted until validated Use an approved MCP server endpoint for structured SQL tool access Use repository-level Copilot instruction files to encode project conventions Explanation Correct Answer D:This implementation fits because it gives code generation stable repository-specific context. That addresses the stated technical constraint. Incorrect Answers A:This alternative prevents unapproved model choice or excessive tool access. This does not meet the need for a method that gives code generation stable repository-specific context. B:This choice requires human review, tests and security checks before use. This does not meet the need for a method that gives code generation stable repository-specific context. C:This alternative provides tool-mediated operations under explicit permissions rather than raw credential sharing. This does not meet the need for a method that gives code generation stable repository-specific context.
Question 249 A team wants to connect an MCP tool but the endpoint grants write access beyond the task. What should the SQL developer implement? Use repository-level Copilot instruction files to encode project conventions Review sensitive schema and data before allowing an AI coding assistant to access repository context Verify the selected AI model and connector permissions in chat configuration Use approved GitHub Copilot organization policies for developer access Explanation Correct Answer C:Verify the selected AI model and connector permissions in chat configuration fits because it prevents unapproved model choice or excessive tool access. That addresses the stated technical constraint. Incorrect Answers A:That technique gives code generation stable repository-specific context. This does not meet the need for a method that prevents unapproved model choice or excessive tool access. B:This choice reduces accidental exposure of regulated information to an external assistant. This does not meet the need for a method that prevents unapproved model choice or excessive tool access. D:This choice enforces centralized enablement and allowed models/features. This does not meet the need for a method that prevents unapproved model choice or excessive tool access.
Question 250 A new team wants to select supported Copilot features without bypassing organization restrictions. Which change most directly meets the requirement? Use repository-level Copilot instruction files to encode project conventions Treat suggested AI-generated DDL as untrusted until validated Review sensitive schema and data before allowing an AI coding assistant to access repository context Use approved GitHub Copilot organization policies for developer access Explanation Correct Answer D:This choice enforces centralized enablement and allowed models/features. Incorrect Answers A:This choice gives code generation stable repository-specific context. This does not meet the need for a method that enforces centralized enablement and allowed models/features. B:This alternative requires human review, tests and security checks before use. This does not meet the need for a method that enforces centralized enablement and allowed models/features. C:This alternative reduces accidental exposure of regulated information to an external assistant. This does not meet the need for a method that enforces centralized enablement and allowed models/features.