Questions that have appeared at google for an engineering (Case Study) interview.

1. System Design

Question: How would you design a system for a service like YouTube or Google Maps? What specific considerations would you make and why?

Question: How would you design a distributed system that needs to handle a large volume of requests per second while maintaining low latency?

Question: Explain how would you design a scalable web crawling service that respects robots.txt and fetches updated pages frequently?

2. Database Design

Question: How would you design a database schema for a large e-commerce site like Amazon.com? What would be the key tables and relationships?

Question: How would you optimize a database that's too slow due to high read and write requests?

Question: How would you design a database for a global social network like Facebook, considering the diverse needs for user data, posts, and friend relationships?

3. Scalability and Performance

Question: Let’s say Google Photos wants to launch a new feature that allows users to search for images based on the objects present in the image. How would you ensure this feature scales for millions of users?

Question: How would you handle a sudden spike in traffic on a popular product during a major event like Black Friday?

Question: Discuss a situation where you improved the performance of a system. What was the problem and how did you go about solving it?

4. Security

Question: Imagine you are tasked with improving the security of Google's user data. What steps would you take to ensure the data is secure?

Question: How would you approach securing an API that allows third-party applications to access and modify user data?

5. Networking

Question: If Google’s search page is not loading for a user, how would you troubleshoot the problem?

Question: How would you design a network infrastructure for a new Google office?