This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Which function should you use to perform exact nearest neighbor (k-NN) search on vector embeddings in SQL Server 2025?
AI_GENERATE_EMBEDDINGS
VECTOR_SEARCH
VECTOR_DISTANCE
What is the primary purpose of Retrieval Augmented Generation (RAG) in SQL Server 2025?
To replace large language models with database queries
To dynamically retrieve relevant information from the database and provide it as context to AI models
To store large language models directly in SQL Server tables
Which authentication method eliminates the need to store API keys when connecting SQL Server 2025 to Azure OpenAI?
Managed identities with SQL Server enabled by Azure Arc
Database-scoped credentials with HTTPEndpointHeaders
HTTPEndpointHeaders
Windows Authentication
What is the recommended approach when implementing safety guardrails for AI-generated SQL queries in conversational interfaces?
Execute all queries in a separate database to prevent data loss
Allow all generated queries to execute without validation
Validate generated SQL to ensure only read-only operations are permitted
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?