Questions that have appeared at Snowflake for an Engineering (Case Study) interview.

1. Data Warehousing

Question: How would you design a data warehouse for a large scale organization? What factors would you consider during its design?

Question: Can you describe a situation where you had to deal with a large amount of data and how you ensured its integrity and security?

Question: How would you approach the challenge of data redundancy and inconsistency in a data warehousing scenario?

2. System Design

Question: How would you design a system to handle high data load during peak hours? What strategies would you use to ensure system availability and performance?

Question: How would you design a system to handle real-time data processing?

Question: Can you discuss a time when you had to make a trade-off between system complexity and performance? How did you make the decision?

3. Data Migration

Question: Describe a situation where you had to migrate data from one system to another. What steps did you take to ensure minimal downtime and data loss?

Question: How would you approach the challenge of migrating a large amount of data to the cloud?

4. Troubleshooting

Question: Describe a situation where you had to troubleshoot a complex issue in a system you were responsible for. How did you approach the problem?

Question: How would you approach diagnosing and fixing a performance issue in a large distributed system?