Program Manager Interview Questions

How dod you tackle this problem. I would say, you can have a wrapper and try to increase the timeout. Or try to download the data at a specific interval so you don't timeout. What was your approach?

One thing to make sure of is that you ask a lot of clarifying questions to eliminate any variables or unknowns you have. In this case, I had to determine what the network architecture was like - centralized or distributed (is network latency a concern?), what was the process flow? Could I resolve the issue by paginating the data coming back as opposed to displaying it all at once? Use what you know of human beings and their limitations. No one is going to be able to digest 1000s of records in one shot. Perhaps a summary with drill down would work? But you'll need to understand what the data is being used for before suggesting something like this (more clarifying questions) What about caching and reverse proxy? the effectiveness of that will depend on your network architecture, I presented several solutions, ranging from cheap and easy to complex and expensive. I actually gave the correct solution that the interviewer wanted (and the one they actually implemented in real life as this was an actual issue) but the interviewer kept me going to explore more and more ideas Pro Tip: Take notes!! the interviewer will give you a lot of information at once, don't try to memorize it all, write down all the salient points!

Can I know what was the solution the interviewer expected in this case?