DP-800: Developing AI-Enabled Database Solutions

Question

You have a Microsoft SQL Server 2025 instance containing a database named SalesDB. SalesDB supports a Retrieval Augmented Generation (RAG) pattern for internal support tickets. The SQL Server instance has no outbound network connectivity.

You plan to generate embeddings within 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 use the model to generate embeddings.

Which two actions should you take? Each correct answer represents part of the solution.

NOTE: Each correct selection is worth one point.

Choose two

Explanation

SQL Server 2025 can run text-embedding inference locally by creating an external model configured for ONNX Runtime with local model and runtime paths, which does not require outbound connectivity. Use of an external model in AI functions requires EXECUTE permission on that external model; granting this permission to AIApplicationUser authorizes that account to generate embeddings while avoiding broad database control permissions.

Learn more

CREATE EXTERNAL MODEL (Transact-SQL) - SQL Server

DP-800: Developing AI-Enabled Database Solutions

AstroTutor

Notes

Readiness

QuestionQ37

Community Discussion