9. Data Modeling and Architecture Flashcards
1
Q
What are the principles of good data modeling?
A
2
Q
How do you design a schema for a time-series database?
A
3
Q
Explain the CAP theorem and its significance in distributed systems.
A
4
Q
How would you design a system for ingesting IoT data at scale?
A
5
Q
What are the trade-offs between consistency
A
availability
6
Q
What is the difference between normalized and dimensional data models?
A
7
Q
How do you perform data deduplication at scale?
A
8
Q
What is schema evolution
A
and how do you handle it?
9
Q
How do you choose between SQL and NoSQL for a given use case?
A
10
Q
Explain the role of sharding and replication in distributed databases.
A
