A team wants GitHub Copilot to generate SQL that follows their organization's naming conventions (e.g., all tables prefixed with 'tbl_') and to always include error handling in stored procedures. They want these rules to be applied automatically in every Copilot session for their repository. What should they create?

A README.md file that documents the conventions for developers.

A .editorconfig file that specifies naming rules.

A Model Context Protocol (MCP) server that injects the conventions into every prompt.

A .github/copilot-instructions.md file at the repository root.

A developer wants to use GitHub Copilot Chat to query both a Microsoft SQL Server database and a Fabric lakehouse in the same session. They have configured two MCP servers. When they ask a question that requires data from both sources, Copilot only uses one of the tools. What should the developer do?

Combine the two MCP servers into a single server that exposes both data sources.

Ensure both MCP servers are selected as active tools in the chat session.

Increase the max tokens setting to allow the model to generate a longer response.

Ask the question twice, once for each data source, and manually combine the results.

In a GitHub Copilot chat session, what does configuring model options allow you to do?

Select which AI model to use for generating responses

Set the temperature of the chat interface

Control the number of chat participants

Define the database schema for the session

A security auditor is reviewing the use of GitHub Copilot in Fabric. The auditor wants to ensure that AI-generated SQL does not inadvertently expose sensitive data through MCP server connections. What is the most effective control?

Enable the Microsoft Copilot tenant setting to add a security layer.

Restrict MCP server permissions to read-only and limit the data sources that can be accessed.

Disable all MCP servers to prevent external data access.

Use a copilot-instructions.md file to instruct the AI to never output sensitive data.

A developer wants to use GitHub Copilot Chat to query a Microsoft SQL Server database directly from the chat. They have set up an MCP server that exposes SQL Server as a tool. However, when they type a natural-language request, Copilot does not seem to use the tool. What should the developer check first?

Reinstall the GitHub Copilot extension in VS Code to refresh the MCP server configuration.

Verify that the MCP server is listed as an active tool in the chat session and that the connection is authenticated.

Increase the max tokens setting in the chat session to allow the model to generate longer SQL queries.

Check that the SQL Server database is in the same Azure region as the Fabric workspace.

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 4

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

Part of the Design and develop database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 44 practice questions to prepare you well beyond it. (estimate)

44questions here

9free pages

7concepts

35–40%of the exam

Questions 11–15

11application · medium
A team wants GitHub Copilot to generate SQL that follows their organization's naming conventions (e.g., all tables prefixed with 'tbl_') and to always include error handling in stored procedures. They want these rules to be applied automatically in every Copilot session for their repository. What should they create?
Select an answer first
12application · medium
A developer wants to use GitHub Copilot Chat to query both a Microsoft SQL Server database and a Fabric lakehouse in the same session. They have configured two MCP servers. When they ask a question that requires data from both sources, Copilot only uses one of the tools. What should the developer do?
Select an answer first
13foundation · easy
In a GitHub Copilot chat session, what does configuring model options allow you to do?
Select an answer first
14expert · hard
A security auditor is reviewing the use of GitHub Copilot in Fabric. The auditor wants to ensure that AI-generated SQL does not inadvertently expose sensitive data through MCP server connections. What is the most effective control?
Select an answer first
15application · medium
A developer wants to use GitHub Copilot Chat to query a Microsoft SQL Server database directly from the chat. They have set up an MCP server that exposes SQL Server as a tool. However, when they type a natural-language request, Copilot does not seem to use the tool. What should the developer check first?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-800

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.

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

Questions 11–15

In a GitHub Copilot chat session, what does configuring model options allow you to do?

A security auditor is reviewing the use of GitHub Copilot in Fabric. The auditor wants to ensure that AI-generated SQL does not inadvertently expose sensitive data through MCP server connections. What is the most effective control?

Keep studying — Design and develop database solutions