Exam DP-800 Topic 2 Question 83 Discussion
Actual exam question for Microsoft's DP-800 exam
Question #: 83
Topic #: 2
Question #: 83
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.
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.
Suggested Answer: C,E Vote an answer
To implement a Retrieval Augmented Generation (RAG) pattern in an isolated SQL Server 2025 instance, you can use the new native vector capabilities to generate, store, and query embeddings without needing outbound internet access.
[E] 1. Enable External REST Endpoints
Because your instance is isolated, you must first enable the configuration that allows SQL Server to communicate with your internal Microsoft Foundry (or local) endpoint.
EXEC sp_configure 'external rest endpoint enabled', 1;
RECONFIGURE;
2. Create the External Model Project
Register your Microsoft Foundry REST endpoint as an external model. This allows SQL Server to treat the internal service as a registered provider for generating embeddings.
[C] 3. Grant Permission to a Specific User
To restrict embedding generation to a single specific database user, grant the EXECUTE permission on the newly created external model.
-- Granting EXECUTE only to the specific user 'AppUser'
GRANT EXECUTE ON EXTERNAL MODEL::[MyFoundryEmbeddingModel] TO [AppUser]; Use code with caution.
4. Generate and Store Embeddings
Use the AI_GENERATE_EMBEDDINGS function to process text into vectors and store them in a table with the new VECTOR data type.
Reference:
https://www.red-gate.com/simple-talk/databases/sql-server/sql-server-2025-create-external- model-and-ai_generate_embeddings-commands-explained/
[E] 1. Enable External REST Endpoints
Because your instance is isolated, you must first enable the configuration that allows SQL Server to communicate with your internal Microsoft Foundry (or local) endpoint.
EXEC sp_configure 'external rest endpoint enabled', 1;
RECONFIGURE;
2. Create the External Model Project
Register your Microsoft Foundry REST endpoint as an external model. This allows SQL Server to treat the internal service as a registered provider for generating embeddings.
[C] 3. Grant Permission to a Specific User
To restrict embedding generation to a single specific database user, grant the EXECUTE permission on the newly created external model.
-- Granting EXECUTE only to the specific user 'AppUser'
GRANT EXECUTE ON EXTERNAL MODEL::[MyFoundryEmbeddingModel] TO [AppUser]; Use code with caution.
4. Generate and Store Embeddings
Use the AI_GENERATE_EMBEDDINGS function to process text into vectors and store them in a table with the new VECTOR data type.
Reference:
https://www.red-gate.com/simple-talk/databases/sql-server/sql-server-2025-create-external- model-and-ai_generate_embeddings-commands-explained/
by Morton at Oct 14, 2026, 02:15 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).