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

Questions 1–5

1. 1expert · hard

   A developer is using GitHub Copilot in Fabric and needs to query data from an external SQL Server that is behind a firewall. The developer has configured an MCP server with the SQL Server endpoint, but the connection fails. What is the most likely cause?

   • AThe Microsoft Copilot tenant setting is disabled.
   • BThe MCP server is not enabled in the Copilot chat session.
   • CThe firewall is blocking the connection from the MCP server to the SQL Server.
   • DThe copilot-instructions.md file is missing the connection string.
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A developer is using GitHub Copilot in Fabric and has configured an MCP server to access a SQL Server database. The developer wants the AI to only use a specific set of stored procedures and not generate ad-hoc queries. What is the best way to enforce this?

   • AEnable the Microsoft Copilot tenant setting to restrict query generation.
   • BConfigure the MCP server to expose only the allowed stored procedures as tools.
   • CCreate a copilot-instructions.md file that instructs the AI to only use stored procedures.
   • DUse the /clear command to reset the session and then ask the AI to only use stored procedures.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A developer wants to use GitHub Copilot in Fabric to run a stored procedure on an external SQL Server. The developer has configured an MCP server for the SQL Server. What must the developer do in the chat session to execute the stored procedure?

   • ACreate a copilot-instructions.md file that includes the EXEC statement.
   • BAsk Copilot to call the MCP tool that executes the stored procedure.
   • CPaste the stored procedure code into the chat and ask for a review.
   • DEnable the Microsoft Copilot tenant setting to allow external execution.
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A multinational company uses Microsoft Copilot in Fabric to assist with SQL development. They must comply with data residency requirements that prohibit data from leaving a specific geographic region. The Copilot service is currently using a model endpoint outside that region. What should the administrator do?

   • ACreate a copilot-instructions.md file that instructs the AI to not process data outside the region.
   • BConfigure the Copilot tenant setting to use a model endpoint within the required region.
   • CUse an MCP server to route all queries through a local gateway.
   • DDisable Microsoft Copilot and use GitHub Copilot instead, which is region-agnostic.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A developer wants to use GitHub Copilot Chat to query a Fabric lakehouse. They have configured an MCP server that connects to the lakehouse. In the chat session, they can see the MCP server listed, but when they ask a question about the data, Copilot responds with generic advice instead of querying the lakehouse. What should the developer do?

   • ASelect the MCP server as an active tool in the chat session and ensure the connection is authenticated.
   • BIncrease the temperature setting to make the model more likely to try the tool.
   • CRecreate the MCP server with a different name and reconnect.
   • DAsk Copilot to 'use the MCP server' in the prompt every time.
   Reveal Solution Discussion Select an answer first