Microsoft · DP-800
AI-assisted tools
DP-800 · Lesson 8 of 20 · 47:49
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: what AI assistants send and how to use them safely, GitHub Copilot in SSMS and Visual Studio Code, Copilot in Fabric, choosing models, MCP servers for SQL, and instruction and prompt files. Includes three original practice questions.
Preview the topics
- A developer wants Copilot’s help with a connection error, and plans to paste the full connection string, password included, into the chat. What should the developer do instead?
- In Visual Studio Code, a developer added a SQL MCP server, but Copilot never calls its tools during the chat. What should the developer check first?
- The team wants every developer’s suggestions in the repository to use schema prefixes, explicit column lists, and the team’s error-handling pattern, without repeating them in each prompt. What should they add?