A development team wants to ensure that GitHub Copilot in Fabric consistently generates T-SQL code that uses a specific date format and includes error handling with TRY...CATCH. The team has a shared repository. What is the most effective way to enforce these patterns across all developers?

Create a copilot-instructions.md file in the repository root with the required patterns.

Ask each developer to manually type the patterns in every chat prompt.

Enable the Microsoft Copilot tenant setting for the workspace.

Configure an MCP server that returns the patterns when queried.

A developer needs to connect GitHub Copilot in Fabric to a Fabric lakehouse to query data. The lakehouse is in the same Fabric workspace. What is the simplest way to enable this connection?

Configure an MCP server with the lakehouse endpoint.

Enable the GitHub Copilot tenant setting for the workspace.

Use the lakehouse as a built-in data source in the Copilot chat session.

Create a copilot-instructions.md file that references the lakehouse.

A developer is using Copilot in Fabric chat to generate SQL queries. They have connected an MCP server that provides access to a SQL Server database. The developer wants the AI to prefer using indexed columns in WHERE clauses and to explain its reasoning. What should the developer configure in the chat session?

Disable the MCP server and rely on the model's general knowledge of SQL Server indexing.

Set the model to 'creative' mode to encourage diverse query generation.

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

Select the MCP server as an active tool and set the model temperature to a low value.

What is required to connect to a Microsoft SQL Server MCP server endpoint?

A valid connection string and authentication credentials

A healthcare organization is enabling GitHub Copilot for its SQL developers. The compliance team is concerned that AI suggestions might inadvertently include protected health information (PHI) from the development database. The organization wants to minimize this risk while still benefiting from AI assistance. What should they do?

Use a development database with synthetic or de-identified data and add an instruction file that forbids referencing real PHI.

Connect the production database to the MCP server so Copilot has accurate data to work with.

Disable GitHub Copilot for all developers and require manual SQL writing only.

Enable GitHub Copilot and rely on its built-in content filter to block PHI from suggestions.

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 4

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

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 16–20

16application · medium
A development team wants to ensure that GitHub Copilot in Fabric consistently generates T-SQL code that uses a specific date format and includes error handling with TRY...CATCH. The team has a shared repository. What is the most effective way to enforce these patterns across all developers?
Select an answer first
17application · medium
A developer needs to connect GitHub Copilot in Fabric to a Fabric lakehouse to query data. The lakehouse is in the same Fabric workspace. What is the simplest way to enable this connection?
Select an answer first
18application · medium
A developer is using Copilot in Fabric chat to generate SQL queries. They have connected an MCP server that provides access to a SQL Server database. The developer wants the AI to prefer using indexed columns in WHERE clauses and to explain its reasoning. What should the developer configure in the chat session?
Select an answer first
19foundation · easy
What is required to connect to a Microsoft SQL Server MCP server endpoint?
Select an answer first
20application · medium
A healthcare organization is enabling GitHub Copilot for its SQL developers. The compliance team is concerned that AI suggestions might inadvertently include protected health information (PHI) from the development database. The organization wants to minimize this risk while still benefiting from AI assistance. 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.

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

Questions 16–20

A development team wants to ensure that GitHub Copilot in Fabric consistently generates T-SQL code that uses a specific date format and includes error handling with TRY...CATCH. The team has a shared repository. What is the most effective way to enforce these patterns across all developers?

A developer needs to connect GitHub Copilot in Fabric to a Fabric lakehouse to query data. The lakehouse is in the same Fabric workspace. What is the simplest way to enable this connection?

What is required to connect to a Microsoft SQL Server MCP server endpoint?

Keep studying — Design and develop database solutions