Which statement about vector columns is correct?

AA vector column can be a primary key if the dimension count is below 768

BA vector column can have a standard B-tree index directly on it

CA vector column can't be used for primary keys, foreign keys, check constraints, or default constraints

DA vector column must always use float16

More Implement AI capabilities in database solutions Questions

50 questions

Full Microsoft Certified: SQL AI Developer Associate Practice Test

All topics covered

All Microsoft Certified: SQL AI Developer Associate Questions

Browse by topic

Related Questions

A developer defines a vector column in SQL Server 2025. What is the maximum supported dimension coun...

easy

Which `CHUNK_TYPE` value is currently accepted by `AI_GENERATE_CHUNKS`?...

easy

A database is running at compatibility level 160. What happens when a developer tries to use `AI_GEN...

easy

Before a query can call `AI_GENERATE_EMBEDDINGS`, which database object must already exist?...

medium

What is the default base type used by the `VECTOR` data type when none is specified?...

medium

View all Implement AI capabilities in database solutions questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.