Data Modeling interview questions

12 real Data Modeling questions from the Firebase bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

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
Reveal the answer + AI explanation — free account

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice Data Modeling free