DP-800 practice question 3 of 15

You have a Microsoft SQL Server 2025 instance that contains a database named SalesDB SalesDB supports a Retrieval Augmented Generation (RAG) pattern…

Full set: 61 questions
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 AlApplicationUser 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.
Answer options
A: Grant the control permission on SalesDB to AlApplicationUser.
B: Create a database audit specification on SalesDB owned by AlApplicationUser.
C: Grant the execute permission on the external model project to AlApplicationUser. Correct answer
D: Create an external model project by using ONNX runtime and local paths. Correct answer
E: Create an external model project that points to a Microsoft Foundry REST endpoint.
Correct Answer:
C. Grant the execute permission on the external model project to AlApplicationUser.; D. Create an external model project by using ONNX runtime and local paths.
Explanation

Because the SQL Server 2025 instance has no outbound connectivity, you must host the embedding model locally. Creating an external model project that references an ONNX file stored on local paths (D) places the model inside the database environment. EXECUTE permission on that external model project must then be granted (C) so that only AlApplicationUser can invoke AIGENERATEEMBEDDINGS, limiting model use to the authorised account.

Why Incorrect

A. CONTROL gives far broader rights than needed and is not specific to model execution.
B. Auditing records activity but does not prevent unauthorised execution.
E. A Foundry REST endpoint requires outbound network access, which the server does not have.

References

1. SQL Server 2025 (preview) – “CREATE EXTERNAL MODEL (Transact-SQL)” documentation, sections “LOCALFILE” and “ONNXRUNTIME” (Microsoft Learn, 2024).

2. SQL Server 2025 – “GRANT (Model)” syntax: GRANT EXECUTE ON MODEL::modelname TO username (Microsoft Learn, 2024).

3. SQL Server 2025 – “Using external models without network connectivity” white-paper, p. 4 (“local path deployment with ONNX runtime”).

Scroll to Top