🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Databases at Scale: all 10 questions

Quiz: Databases at Scale · Question 6 of 10

Before sharding a slow database, what should you try first?

Before sharding a slow database, what should you try first?

  1. A.Switch to NoSQL immediately
  2. B.Buy a second data centre
  3. C.Add the right indexes, fix slow queries, add a cache and use connection pooling
  4. D.Delete old users
Answer & explanation

Correct answer: Add the right indexes, fix slow queries, add a cache and use connection pooling

Cheap wins often solve the problem without the cost of sharding.

Can you get the rest right without peeking?

Take the timed Quiz: Databases at Scale quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →