DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ96

VerifiedImplement AI capabilities in database solutions

You have an Azure SQL database containing a table named Tickets_Embeddings. Tickets_Embeddings has a VECTOR(1536) column.

Embeddings are created by using text-embedding-ada-002 and the /openai/v1/embeddings endpoint.

After reviewing the current environment, the following changes are requested:

  • The AI architect recommends changing to text-embedding-3-small.
  • The security team requires authentication using Microsoft Entra managed identities only. API keys must not be stored in an application.

Which two actions should you include in the solution? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Choose two
Explanation

Embeddings generated by text-embedding-ada-002 and text-embedding-3-small are not interchangeable, even when both use 1,536 dimensions, so all stored embeddings must be regenerated. Managed-identity-only access requires an Azure OpenAI endpoint that accepts Microsoft Entra bearer-token authentication instead of an API key. text-embedding-3-small supports up to 1,536 dimensions, so the existing vector-column dimension can remain unchanged.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!