AI0-001 AI Infrastructure and Technologies Practice Question
A startup is building a recommendation system that requires low-latency similarity search over millions of product embeddings. They need a vector database that offers high performance and has a managed cloud option. Which TWO databases are best suited for this requirement?
⚠ Common exam trap
CompTIA often tests the distinction between general-purpose databases with vector extensions (like pgvector) and purpose-built vector databases (like Weaviate and Pinecone), where candidates mistakenly assume any database with vector support is suitable for production-scale low-latency workloads.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Weaviate
Weaviate and Pinecone are both purpose-built vector databases that natively support high-performance approximate nearest neighbor (ANN) search using algorithms like HNSW (Weaviate) or proprietary indexing (Pinecone). They offer managed cloud services with automatic scaling, making them ideal for low-latency similarity search over millions of product embeddings without requiring manual infrastructure management.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Chroma
Why it's wrong here
Chroma is open-source; managed cloud is less mature.
- ✓
Weaviate
Why this is correct
Weaviate offers a managed cloud service with vector search.
- ✗
pgvector (PostgreSQL extension)
Why it's wrong here
pgvector requires self-hosting and management, not a managed cloud service.
- ✗
Amazon DynamoDB
Why it's wrong here
DynamoDB is a key-value/NoSQL database, not optimized for vector similarity search.
- ✓
Pinecone
Why this is correct
Fully managed, high-performance vector search.
About these practice questions
One of 754 original AI0-001 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI0-001 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI0-001 exam.