Interview Questions

1. Design schema for orders, products, and users.

   behavioral
2. Write query to get top 5 selling products last week.

   behavioral
3. Difference between OLTP and OLAP.

   behavioral
4. What is Apache Kafka? Why is it used?

   behavioral
5. Implement map-reduce to count word frequency.

   behavioral
6. Explain partitioning vs sharding in databases.

   behavioral
7. Describe ETL pipeline components.

   behavioral
8. Python: Convert nested JSON to flat table.

   behavioral
9. Explain eventual consistency in NoSQL DBs.

   behavioral
10. What are star and snowflake schemas?

    behavioral