Q41 PostgreSQL Domain 2 · 25–30% of exam Priority · Real Exam

Which approach keeps embeddings synchronised when source text is updated?

  1. A A trigger or application-side pipeline that recomputes the embedding on UPDATE (correct answer)
  2. B A foreign key constraint
  3. C A unique index on the vector column
  4. D Setting the vector column to GENERATED

Shortcut: Embeddings are derived data. A trigger enqueuing a re-embed job, or explicit application logic on write, keeps the vector consistent with the text it represents.