Design and Implement SQL Solutions by Using AI-assisted Tools DP-800 Practice Questions (Page 9)

Questions 41–44

1. 41expert · hard

   A developer has configured an MCP server that connects to a SQL Server database. The MCP server exposes several tools, including one that executes arbitrary SQL. The developer wants to allow Copilot to run SELECT queries but prevent any data modification. The developer also wants the model to prefer using the MCP tool over generating SQL from memory. What should the developer do?

   • AKeep the arbitrary SQL tool but add an instruction file that tells Copilot not to use it for modifications.
   • BUse a read-write connection but set the model temperature to zero to make it more conservative.
   • CDisable the MCP server and rely on Copilot's built-in SQL knowledge to generate queries.
   • DModify the MCP server to expose only a read-only tool that executes SELECT statements, and select that tool as active in the chat session.
   Reveal Solution Discussion Select an answer first
2. 42foundation · easy

   Where should a GitHub Copilot instruction file be placed to affect all repositories in an organization?

   • AIn a central configuration repository referenced by the organization
   • BIn the user's home directory
   • CIn the root of each repository
   • DIn the .github directory of each repository
   Reveal Solution Discussion Select an answer first
4. 43expert · hard

   A government agency is enabling GitHub Copilot for its SQL developers. The agency has strict data classification rules: development data must not contain classified information. The agency also wants to allow Copilot to access a Fabric lakehouse that contains only unclassified data. However, the MCP server that connects to the lakehouse also has access to a classified database. What should the agency do?

   • AConfigure the MCP server to connect only to the unclassified lakehouse and ensure the classified database is not accessible from the MCP server.
   • BDisable GitHub Copilot for the agency and use manual SQL development only.
   • CUse a read-only connection to the classified database so Copilot can see the schema but not the data.
   • DEnable GitHub Copilot and rely on the developers to avoid asking questions about classified data.
   Reveal Solution Discussion Select an answer first
5. 44expert · hard

   A developer is using GitHub Copilot Chat with an MCP server that connects to a Fabric lakehouse. The MCP server requires authentication via a personal access token (PAT). The developer notices that after a few hours, Copilot stops using the MCP tool and returns generic responses. What is the most likely cause and solution?

   • AThe Fabric lakehouse has been deleted; the developer should recreate the lakehouse.
   • BThe MCP server has reached a rate limit; the developer should wait a few hours and try again.
   • CThe model's temperature setting has drifted; the developer should reset it to the default.
   • DThe PAT has expired or been revoked; the developer should refresh the authentication in the MCP server configuration.
   Reveal Solution Discussion Select an answer first