Data Modeling interview questions

12 Data Modeling questions from the Firebase bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.

Free to start: the 2-minute IT readiness check — six questions and a result.

Take the free IT readiness check

or take a mock interview set up for this area

1. What is Denormalization?

Junior
  1. A.a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  2. B.the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range
  3. C.the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  4. D.duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access

Answer + AI explanation with Pro

2. Which term means: "duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access"?

Junior
  1. A.Hotspotting
  2. B.Collection group query
  3. C.Document size limit
  4. D.Denormalization

Answer + AI explanation with Pro

3. Which statement is correct?

Junior
  1. A.Denormalization — a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  2. B.Denormalization — the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range
  3. C.Denormalization — the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  4. D.Denormalization — duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access

Answer + AI explanation with Pro

4. What is Document size limit?

Mid
  1. A.the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  2. B.duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access
  3. C.a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  4. D.the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range

Answer + AI explanation with Pro

5. Which term means: "the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections"?

Mid
  1. A.Denormalization
  2. B.Hotspotting
  3. C.Document size limit
  4. D.Collection group query

Answer + AI explanation with Pro

6. Which statement is correct?

Mid
  1. A.Document size limit — the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  2. B.Document size limit — a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  3. C.Document size limit — duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access
  4. D.Document size limit — the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range

Answer + AI explanation with Pro

7. What is Collection group query?

Mid
  1. A.a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  2. B.the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  3. C.duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access
  4. D.the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range

Answer + AI explanation with Pro

8. Which term means: "a search that spans every subcollection sharing the same name across the whole database, regardless of parent"?

Mid
  1. A.Hotspotting
  2. B.Denormalization
  3. C.Collection group query
  4. D.Document size limit

Answer + AI explanation with Pro

9. Which statement is correct?

Mid
  1. A.Collection group query — a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  2. B.Collection group query — the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range
  3. C.Collection group query — the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  4. D.Collection group query — duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access

Answer + AI explanation with Pro

10. What is Hotspotting?

Senior
  1. A.the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  2. B.the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range
  3. C.a search that spans every subcollection sharing the same name across the whole database, regardless of parent
  4. D.duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access

Answer + AI explanation with Pro

11. Which term means: "the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range"?

Senior
  1. A.Collection group query
  2. B.Denormalization
  3. C.Document size limit
  4. D.Hotspotting

Answer + AI explanation with Pro

12. Which statement is correct?

Senior
  1. A.Hotspotting — the throughput problem caused by monotonically increasing keys or sequential timestamps concentrating writes on one storage range
  2. B.Hotspotting — the hard ceiling of about one megabyte per record, which pushes large or growing lists into subcollections
  3. C.Hotspotting — duplicating data across documents to avoid joins, trading storage and write complexity for fast single-read access
  4. D.Hotspotting — a search that spans every subcollection sharing the same name across the whole database, regardless of parent

Answer + AI explanation with Pro

Free to start

Start with a free readiness check

Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every Data Modeling question come with Pro.

Take the free IT readiness check

or take a mock interview set up for this area

24,000+ questions & coding problemsSoftware & IT16,274 questionsGovernment jobs26 examsAptitudenew questions every timeAI practice interviewwith feedback65 topics to practiseMechanical1,149 questionsGATE ME9 papersEngineering Mathematics381 questions2-minute checkfreeDSA Problems1,422Civil1,005 questionsGATE CE9 papersCS Fundamentals1,209 questionsYour scores6 skillsSystem Design25Electrical / EEE1,047 questionsGATE EE9 papersRun your codeC++ · Java · PythonLow-Level Design144Electronics & Comm.975 questionsGATE EC9 papersAI help on every questionFull-Stack6,282Chemical1,005 questionsGATE CH9 papersAI whiteboardsystem designWork abroadEurope · remote · transfersESE ME1 paperGATE practice papers2019–2026ESE CE1 paperDate alertsbefore the last dateESE EE1 paperBehavioural courseHR round practiceESE ET1 paperResume optimizerProSSC JE ME1 paperApplication trackerSSC JE CE1 paperCompany-wise prepSSC JE EE1 paperRole roadmapsRRB JE1 subjectPriced in ₹UPI · cardsISRO SC1 paperGATE CS9 papersIBPS SO IT1 paperUGC NET CS1 paperSSC CGL26 papersIBPS PO26 papersRRB NTPC26 papersSSC CHSL26 papersIBPS Clerk26 papersSBI Clerk26 papersRRB Group D26 papersSSC CPO26 papersSSC GD26 papers