Implement AI capabilities in database solutions Questions
Practice questions for Implement AI capabilities in database solutions topic in Microsoft Certified: SQL AI Developer Associate. 50 questions covering this domain.
What is the default base type used by the `VECTOR` data type when none is specified?
A database is running at compatibility level 160. What happens when a developer tries to use `AI_GENERATE_CHUNKS`?
A developer wants overlapping fixed-size chunks for retrieval preparation. Which `OVERLAP` value is valid for `AI_GENERATE_CHUNKS`?
Which permission is required to execute `sp_invoke_external_rest_endpoint`?
Which statement about vector columns is correct?
A developer is updating code to the latest vector index syntax. Which change is required?
Which `CHUNK_TYPE` value is currently accepted by `AI_GENERATE_CHUNKS`?
A query uses the latest vector index implementation and calls `VECTOR_SEARCH`. Which ordering is allowed in the outer query?
Before a query can call `AI_GENERATE_EMBEDDINGS`, which database object must already exist?
A DBA creates an external model for embeddings. Another user needs to call `AI_GENERATE_EMBEDDINGS` against that model. Which additional permission mu...
An external model defines the `dimensions` parameter as `1536`, but one query needs a different dimension size for that call. What happens if the quer...
A developer defines a vector column in SQL Server 2025. What is the maximum supported dimension count for the `VECTOR` data type?
A vector index on a `VECTOR(1536)` column on a 50M-row table degrades insert throughput. Which trade-off is documented for SQL Server / Azure SQL vect...
Which T-SQL function computes the distance between two `VECTOR` values for similarity search?
A developer must call `sp_invoke_external_rest_endpoint` with a JSON payload that exceeds the default response timeout. Which parameter should they ad...
A developer creates an external model for chat completions. Which `MODEL_TYPE` value should they specify?
A vector search needs to include a relational filter (e.g., `Region = 'EU'`) along with similarity ranking. Which pattern is documented?
A RAG application stores embeddings of large documents and needs to retrieve the top-K most similar chunks for a user question. Which complete pipelin...
Which distance metric is commonly used for embeddings produced by Azure OpenAI text embedding models in SQL vector queries?
Which `AI_GENERATE_CHUNKS` parameter sets the maximum size of each fixed chunk?
Sign in to see all 50 questions
Create a free account to browse all questions — completely free during our launch phase.