A regional marketplace named RiverTrade is creating a virtual support agent. The agent must fetch the live status of a specific order by order ID and it must also answer general product questions by r

Question

Options

• ACloud Spanner for order status and Cloud Bigtable for product descriptions
• BBigQuery for both order status and product descriptions
• CCloud SQL for order status and AlloyDB for PostgreSQL for the product description knowledge
• DCloud Storage for order status and BigQuery for product descriptions

• A
  12% (3)
• B
  8% (2)
• C
  76% (19)
• D
  4% (1)

Explanation

Cloud SQL is a managed relational database that is well suited for transactional workloads and fast point reads by primary key, which matches the need to fetch a live order status by order ID. It delivers ACID guarantees and predictable latency for single row lookups in a regional setup, which is a common pattern for e commerce order tables. AlloyDB for PostgreSQL is an excellent fit for a retrieval augmented knowledge base built from tens of thousands of product descriptions. It supports PostgreSQL extensions such as pgvector and offers AlloyDB AI features, so it can store embeddings and perform high quality vector similarity searches and can also use native full text search. This lets the agent retrieve the most relevant passages quickly and serve them to the language model.

No community discussion yet for this question.