Which AWS service supports vector embeddings storage and queries?

AIF-C01 By islever Editorial Last updated

Short answer

B Amazon Aurora PostgreSQL

Question

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?
  1. Amazon Athena
  2. Amazon Aurora PostgreSQL Correct Answer
  3. Amazon Redshift
  4. Amazon EMR

Key Takeaways

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.

Common mistake: 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.

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 vector data type
  • Perform approximate nearest neighbor (ANN) searches using IVFFlat or HNSW indexes
  • Combine vector similarity queries with traditional SQL queries in a single transaction
The community comments consistently highlight pgvector as the key differentiator that makes Aurora PostgreSQL the ideal choice.

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

These links open the official vendor documentation in a new tab.

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.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. 26b8fe1 👍 1 Answered B
    Amazon Aurora PostgreSQL Amazon Aurora PostgreSQL supports vector storage and queries, making it suitable for storing embeddings from a generative AI model as vectors in the database. It integrates with extensions like pgvector to efficiently handle high-dimensional vector data.
  2. aws_Tamilan 👍 1 Answered B
    Amazon Aurora PostgreSQL is the best choice for a database service to store and query embeddings from generative AI models, as it supports vector storage and similarity searches through the pgvector extension.
  3. may2021_r 👍 1 Answered B
    The correct answer is B. Amazon Aurora PostgreSQL supports vector data types and can efficiently store and query embeddings.
  4. Jessiii 👍 1 Answered B
    Supports pgvector, a popular extension for storing and querying vector embeddings.

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

How to use a custom trained model in Amazon Bedrock?

S-grade

How to Increase Image Specificity in Amazon Bedrock Stable Diffusion?

S-grade

How to Quickly Deploy and Consume Foundation Models in a VPC on AWS?

S-grade

Which AWS Service Sends Email Notifications When ISV Compliance Reports Are Available?

S-grade

Practice All AIF-C01 Questions

Access 100 questions with complete answers and detailed explanations.

View Full AIF-C01 Practice Test →

← Back to AIF-C01 Study Guide