Q31 PostgreSQL Domain 2 · 25–30% of exam

An app needs to store both the raw text and its embedding in PostgreSQL. What is the recommended table design?

  1. A Separate tables for text and vectors joined by ID
  2. B Single table with text column (text), embedding column (vector(1536)), and metadata jsonb (correct answer)
  3. C Store embeddings in a separate Azure Blob Storage
  4. D Use Cosmos DB for vectors only

Shortcut: Storing text, embedding, and metadata in a single table simplifies queries and enables efficient hybrid search. The vector column type stores the embedding natively with index support.