Which AWS service supports vector embeddings storage and queries?
A company is implementing intelligent agents to provide conversational search experiences for its customers. The company needs a database service that will support storage and queries of embeddings from a generative AI model as vectors in the database. Which AWS service will meet these requirements?
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The question tests knowledge of pgvector support in AWS relational databases, where Aurora PostgreSQL is the only listed option that natively supports vector embeddings.
Amazon Aurora PostgreSQL supports vector storage and similarity searches via the pgvector extension, making it the correct choice for storing and querying embeddings from generative AI models. The community unanimously agrees on this answer.
Candidates may choose Amazon Redshift or Amazon EMR, thinking they are better suited for big data or analytics workloads, but neither provides native pgvector-style vector embedding support like Aurora PostgreSQL.
Community Discussion (4 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Understanding Vector Embeddings in AWS
When building conversational search experiences powered by generative AI, the underlying database must be able to store high-dimensional vector embeddings and perform similarity searches (e.g., cosine similarity, L2 distance). This is a core requirement for Retrieval-Augmented Generation (RAG) architectures.
Why Amazon Aurora PostgreSQL is Correct
Amazon Aurora PostgreSQL supports the pgvector extension, which is specifically designed for storing, indexing, and querying vector embeddings directly within the relational database. This allows developers to:
- Store embeddings as a native
vectordata type - Perform approximate nearest neighbor (ANN) searches using IVFFlat or HNSW indexes
- Combine vector similarity queries with traditional SQL queries in a single transaction
Why the Other Options Are Incorrect
- Amazon Athena (A): A serverless query service for analyzing data in Amazon S3 using standard SQL. It does not support vector data types or embedding storage.
- Amazon Redshift (C): A data warehousing service optimized for analytical queries on large datasets. While Redshift has recently introduced some vector capabilities, it is not the primary or best-suited service for operational embedding storage and real-time similarity search in this context.
- Amazon EMR (D): A managed big data framework (Spark, Hadoop) for processing large-scale data. It is a compute service, not a database service designed for vector embedding storage and querying.
Community Consensus
All community voters selected B, and multiple comments specifically reference the pgvector extension as the deciding factor. This reinforces that Aurora PostgreSQL is the expected answer on the exam.
Official Reference
Exam Strategy
When a question mentions 'vector embeddings' or 'similarity search,' immediately look for database services that support pgvector (Aurora PostgreSQL) or purpose-built vector databases like Amazon OpenSearch with k-NN. Eliminate analytics-only or compute-only services.
Related Analysis
Practice All AIF-C01 Questions
Access 100 questions with complete answers and detailed explanations.
View Full AIF-C01 Practice Test →