A healthcare analytics company uses Microsoft Fabric to develop SQL solutions. They want to enable Microsoft Copilot in Fabric to assist with writing T-SQL queries, but they must ensure that patient data is not used to train the underlying model and that only authorized users can access the feature. What should the administrator do?

Enable the Copilot tenant setting and configure data boundaries to prevent out-of-scope data usage.

Assign users to the Fabric Admin role to grant them access to Copilot.

Enable the GitHub Copilot setting in the Fabric admin portal.

Create a custom MCP server to connect to the lakehouse and use that for AI assistance.

What is the purpose of configuring Model Context Protocol (MCP) tool options in a GitHub Copilot chat session?

To set the maximum token limit for responses

To change the color theme of the chat window

To enable Copilot to interact with external tools and services

To manage user authentication for GitHub

A development team uses GitHub Copilot in a Fabric SQL repository. They want Copilot to always suggest queries that use a specific date format and to avoid using deprecated functions. The team wants these rules to apply to every developer who works in the repository. What should they do?

Create a Model Context Protocol (MCP) server that injects the rules into every Copilot request.

Create a .github/copilot-instructions.md file in the repository root and commit it.

Ask each developer to configure the same settings in their local VS Code settings.json.

Add the rules to the README.md file so developers can read them and follow them manually.

A team uses GitHub Copilot in Fabric to develop SQL scripts. They want the AI to always include a comment header with the author and date, and to use a specific indentation style. Where should the team place the instruction file to ensure it applies to all developers?

In the user's home directory, so it applies to all repositories.

In the MCP server configuration file.

In the Fabric workspace settings as a global configuration.

In the repository root as .github/copilot-instructions.md.

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 4

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

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 26–30

26application · medium
A healthcare analytics company uses Microsoft Fabric to develop SQL solutions. They want to enable Microsoft Copilot in Fabric to assist with writing T-SQL queries, but they must ensure that patient data is not used to train the underlying model and that only authorized users can access the feature. What should the administrator do?
Select an answer first
27foundation · easy
What is the purpose of configuring Model Context Protocol (MCP) tool options in a GitHub Copilot chat session?
Select an answer first
28foundation · easy
Which Microsoft Fabric component must be activated to use Microsoft Copilot for AI-assisted SQL solution design?
Select an answer first
29application · medium
A development team uses GitHub Copilot in a Fabric SQL repository. They want Copilot to always suggest queries that use a specific date format and to avoid using deprecated functions. The team wants these rules to apply to every developer who works in the repository. What should they do?
Select an answer first
30application · medium
A team uses GitHub Copilot in Fabric to develop SQL scripts. They want the AI to always include a comment header with the author and date, and to use a specific indentation style. Where should the team place the instruction file to ensure it applies to all developers?
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 6)

Questions 26–30

What is the purpose of configuring Model Context Protocol (MCP) tool options in a GitHub Copilot chat session?

Which Microsoft Fabric component must be activated to use Microsoft Copilot for AI-assisted SQL solution design?

A development team uses GitHub Copilot in a Fabric SQL repository. They want Copilot to always suggest queries that use a specific date format and to avoid using deprecated functions. The team wants these rules to apply to every developer who works in the repository. What should they do?

A team uses GitHub Copilot in Fabric to develop SQL scripts. They want the AI to always include a comment header with the author and date, and to use a specific indentation style. Where should the team place the instruction file to ensure it applies to all developers?

Keep studying — Design and develop database solutions