Bird
0
0

You want to design a system that uses Elasticsearch for fast search but also needs complex transactions and joins. What is a good approach?

hard🚀 Application Q8 of 15
Elasticsearch - Basics and Architecture
You want to design a system that uses Elasticsearch for fast search but also needs complex transactions and joins. What is a good approach?
AUse only a relational database and ignore Elasticsearch.
BUse only Elasticsearch and try to implement joins manually.
CUse Elasticsearch for search and a relational database for transactions, syncing data between them.
DUse Elasticsearch with SQL JOIN queries directly.
Step-by-Step Solution
Solution:
  1. Step 1: Recognize strengths of each system

    Elasticsearch is great for search; relational DBs handle transactions and joins well.
  2. Step 2: Combine systems effectively

    Use Elasticsearch for search and relational DB for transactions, syncing data as needed.
  3. Final Answer:

    Use Elasticsearch for search and a relational database for transactions, syncing data between them. -> Option C
  4. Quick Check:

    Best system design = C [OK]
Quick Trick: Combine Elasticsearch and relational DB for best of both [OK]
Common Mistakes:
MISTAKES
  • Trying to do complex joins only in Elasticsearch
  • Ignoring relational DB strengths
  • Expecting Elasticsearch to handle transactions

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Elasticsearch Quizzes