A developer is using Microsoft Copilot in Fabric to generate SQL for a complex reporting query. The developer wants the AI to use a specific schema and avoid using SELECT *. What should the developer do in the chat session?

Connect an MCP server that contains the schema definition.

Use the /new command to start a fresh session and then ask the question.

Enable the GitHub Copilot tenant setting for the workspace.

Provide a detailed prompt that specifies the schema and explicitly forbids SELECT *.

A data team uses Microsoft Fabric and wants GitHub Copilot to suggest T-SQL code in their SQL analytics endpoint. The team lead is concerned about code quality and wants the suggestions to follow the organization's naming conventions and error-handling patterns. The Fabric admin has already enabled the tenant setting for GitHub Copilot. What should the team do next?

Configure the MCP server endpoint to point to the Fabric lakehouse.

Create a .github/copilot-instructions.md file in the repository and reference it in the chat session.

Ask the Fabric admin to enable the Microsoft Copilot tenant setting for the workspace.

Use the /clear command in the chat to reset the conversation context.

A developer is using GitHub Copilot Chat to generate SQL for a complex reporting query. The developer has an MCP server that provides access to the database schema. The developer wants the model to produce a deterministic query that follows a specific pattern. However, the model sometimes produces different queries for the same prompt. What should the developer do?

Disable the MCP server to reduce the number of variables in the prompt.

Increase the max tokens to allow the model to generate longer queries.

Set the model temperature to a low value and ensure the MCP server is active to provide consistent schema context.

Use a different model that is known for creativity.

What is the purpose of connecting to a Fabric lakehouse MCP server endpoint?

To store the AI assistant's chat logs

To create a backup of the lakehouse

To manage the lakehouse's storage capacity

To allow the AI assistant to query and analyze data stored in the lakehouse

A financial services company uses GitHub Copilot in Fabric to assist developers with SQL queries. The security team is concerned about sensitive data being exposed through AI suggestions. What should the developers do to minimize the risk of data leakage?

Disable the MCP server connections to prevent external data access.

Avoid including sensitive data values in prompts and review all AI-generated code before execution.

Enable the Microsoft Copilot tenant setting to add an extra security layer.

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

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 4

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

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 21–25

21application · medium
A developer is using Microsoft Copilot in Fabric to generate SQL for a complex reporting query. The developer wants the AI to use a specific schema and avoid using SELECT *. What should the developer do in the chat session?
Select an answer first
22application · medium
A data team uses Microsoft Fabric and wants GitHub Copilot to suggest T-SQL code in their SQL analytics endpoint. The team lead is concerned about code quality and wants the suggestions to follow the organization's naming conventions and error-handling patterns. The Fabric admin has already enabled the tenant setting for GitHub Copilot. What should the team do next?
Select an answer first
23expert · hard
A developer is using GitHub Copilot Chat to generate SQL for a complex reporting query. The developer has an MCP server that provides access to the database schema. The developer wants the model to produce a deterministic query that follows a specific pattern. However, the model sometimes produces different queries for the same prompt. What should the developer do?
Select an answer first
24foundation · easy
What is the purpose of connecting to a Fabric lakehouse MCP server endpoint?
Select an answer first
25application · medium
A financial services company uses GitHub Copilot in Fabric to assist developers with SQL queries. The security team is concerned about sensitive data being exposed through AI suggestions. What should the developers do to minimize the risk of data leakage?
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 5)

Questions 21–25

A developer is using Microsoft Copilot in Fabric to generate SQL for a complex reporting query. The developer wants the AI to use a specific schema and avoid using SELECT *. What should the developer do in the chat session?

What is the purpose of connecting to a Fabric lakehouse MCP server endpoint?

A financial services company uses GitHub Copilot in Fabric to assist developers with SQL queries. The security team is concerned about sensitive data being exposed through AI suggestions. What should the developers do to minimize the risk of data leakage?

Keep studying — Design and develop database solutions