Câu 17: DP-800: Developing AI-Enabled Database Solutions

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.

1. A. Grant the CONTROL permission on SalesDB to AIApplicationUser.
2. B. Create a database audit specification on SalesDB owned by AIApplicationUser.
3. C. Grant the EXECUTE permission on the external model project to AIApplicationUser. — đáp án hiện tại
4. D. Create an external model project by using ONNX runtime and local paths.
5. E. Create an external model project that points to a Microsoft Foundry REST endpoint. — đáp án hiện tại