← Back to exam page

Free DP-800 – Microsoft DP-800 Practice Test Question

Loading demo links...

Showing 1–2 of 2 questions

Question 1 (Topic 1)

Your team is developing an Azure SQL dataset solution from a locally cloned GitHub repository by using Microsoft Visual Studio Code and GitHub Copilot Chat. You need to disable the GitHub Copilot repository-level instructions for yourself without affecting other users. What should you do?

Select an option, then click Submit answer.

  • ○ From Visual Studio Code, modify your GitHub Copilot Chat user settings.
  • ○ Add a --debug flag when you start the GitHub Copilot Chat extension.
  • ○ Delete .github/copilot-instructions.md.
Question 2 (Topic 2)

You have a Microsoft SQL Server 2025 instance that contains a database named SalesDB. SalesDB supports a Retrieval Augmented Generation (RAG) pattern for internal support tickets. The SQL Server instance runs without any outbound network connectivity. You plan to generate embeddings inside the SQL Server instance and store them in a table for vector similarity queries. You need to ensure that only a database user account named AIApplicationUser can run embedding generation by using the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Select an option, then click Submit answer.

  • ○ Grant the CONTROL permission on SalesDB to AIApplicationUser.
  • ○ Create a database audit specification on SalesDB owned by AIApplicationUser.
  • ○ Grant the EXECUTE permission on the external model project to AIApplicationUser.
  • ○ Create an external model project by using ONNX runtime and local paths.
  • ○ Create an external model project that points to a Microsoft Foundry REST endpoint.