A data analyst uses Microsoft Copilot in Fabric to generate SQL queries. They need to query data from a Fabric lakehouse and also from an on-premises SQL Server. The on-premises SQL Server is not publicly accessible. What should the analyst configure to allow Copilot to access both data sources?

Create two MCP servers: one for the lakehouse and one for the SQL Server, both using public endpoints.

Use a copilot-instructions.md file to embed the connection strings for both sources.

Enable the GitHub Copilot tenant setting to allow external connections.

Connect the lakehouse as a built-in data source and set up an MCP server for the on-premises SQL Server via a gateway.

A developer wants to use GitHub Copilot in Fabric to query data from an external SQL Server instance that is not part of the Fabric environment. The developer has the connection string and credentials. What should the developer configure in the Copilot chat session?

Use the /clear command to reset the session and then paste the connection string.

Ask the admin to enable the Microsoft Copilot tenant setting.

Create a copilot-instructions.md file that includes the connection string.

Enable the MCP server option and add the SQL Server endpoint as an MCP server.

What is the purpose of configuring model options in a Copilot in Fabric chat session?

To adjust the AI model's response style and accuracy for the task

To enable or disable the chat history

To specify which database to connect to

To change the language of the user interface

What is a key security implication of using AI-assisted tools in SQL development?

AI tools eliminate the need for code reviews.

AI tools may inadvertently introduce vulnerabilities or expose sensitive data in prompts.

AI tools automatically enforce all database security policies.

AI tools are only a security risk if used on production databases.

A large enterprise is rolling out GitHub Copilot to its SQL development teams. The security team has identified that Copilot suggestions sometimes include internal server names and connection strings from the codebase. The team wants to reduce this risk without disabling Copilot entirely. They also need to maintain developer productivity. What should they do?

Rely on GitHub's secret scanning to automatically remove secrets from Copilot suggestions.

Add an instruction file that forbids including server names and connection strings, and use environment variables for connection strings in the codebase.

Disable GitHub Copilot for the repository and require developers to use a different AI tool that has better filtering.

Configure a Model Context Protocol (MCP) server to redact server names from all Copilot output.

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 4

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

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 36–40

36application · medium
A data analyst uses Microsoft Copilot in Fabric to generate SQL queries. They need to query data from a Fabric lakehouse and also from an on-premises SQL Server. The on-premises SQL Server is not publicly accessible. What should the analyst configure to allow Copilot to access both data sources?
Select an answer first
37application · medium
A developer wants to use GitHub Copilot in Fabric to query data from an external SQL Server instance that is not part of the Fabric environment. The developer has the connection string and credentials. What should the developer configure in the Copilot chat session?
Select an answer first
38foundation · easy
What is the purpose of configuring model options in a Copilot in Fabric chat session?
Select an answer first
39foundation · easy
What is a key security implication of using AI-assisted tools in SQL development?
Select an answer first
40expert · hard
A large enterprise is rolling out GitHub Copilot to its SQL development teams. The security team has identified that Copilot suggestions sometimes include internal server names and connection strings from the codebase. The team wants to reduce this risk without disabling Copilot entirely. They also need to maintain developer productivity. What should they do?
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.