Interview Questions

Vishnu G. - "This is a classic strategic dilemma, but the answer for Walmart, given its core business model and strengths, is quite clear: Invest in boosting dish soap production. Here's why: Proven Success: Dish soap is Walmart's top product with strong, established sales. Scaling leverages existing, efficient supply chains and customer demand. Core Competency: Walmart excels at high-volume, low-margin household goods. This aligns perfectly with their business model and customer base. **L"See full answer

Jyoti V. - "Over-fitting of a model occurs when model fails to generalize to any new data and has high variance withing training data whereas in under fitting model isn't able to uncover the underlying pattern in the training data and high bias. Tree based model like decision tree and random forest are likely to overfit whereas linear models like linear regression and logistic regression tends to under fit. There are many reasons why a Random forest can overfits easily 1. Model has grown to its full depth a"See full answer

Piyush D. - "Honestly, In addition to having the right expertise and skills required for this job, I am really looking forward to being part of this organisation’s journey. I am really confident that I will really exceed your expectations in achieving both mine and the company’s goals. I have worked with different teams in different capacities, managed a team of engineers successfully from very early part of my career and that has made me a very easy person to work with. I get things done easily. I am passio"See full answer

Glados - "First, why are we building the system? What are the requirements we must meet - Do customers care about data being read/written from a single set of tables or multiple tables, do they care about cost allocation, do they need backups/storage to happen slow or fast, do they foresee a lot of data movement from one table to another? Based on this, there are a few options using some common design choices. Shared disk, or Shared nothing. Both have pros and cons. Based on latency, performance, and cos"See full answer

Satyajit G. - "It might not be a good idea to predict stock prices only based on reddit comments. You could create a signal from reddit comments that can indicate "social media interest" and feed it into a ML system (along with other features) that predicts prices. Collecting good data to train the model and evaluating it correctly are going to be huge challenges."See full answer

Sumit P. - "CQs: Swiggy? → instamart or food delivery → consider both Why do we want to increase AOV right now? Is it not at the desired level or exploration? → let’s say exploration Swiggy is a public company → goal is profit Biggest bite in profit is delivery cost hence delivery cost/unit revenue should be minimised Delivery cost = (fixed base cost + distance * x) * probability of spoil cases Can be done by Lowering delivery cost → seems challenging "See full answer

Claudia S. - "What is a "cache controller"? With no more details it's difficult to tell what this question is about."See full answer

Gk K. - " can we use blomfilters to check existing usernames? and if both are creating at a time, like both are choosing some abcd , here system checks whether user with that name exists or not. so while checking , it will add an entry on redis (example) with this name as key and obtain lock using some distributed lock. , it will lock on that name. (like seat booking in bookmyshow) with some TTL value. so this check will happen once user enters his interest username and also while submit .. 2 times che"See full answer

Bhavna S. - " with youngsuccrate as( select strftime('%m', postdate) AS postmonth, round(sum(issuccessfulpost)*1.0/count(issuccessfulpost),2)as yascrate from post where userid in (select userid from post_user where age between 0 and 18) group by post_month ), nonyoungsucc_rate as( select strftime('%m', postdate) AS postmonth, round(sum(issuccessfulpost)*1.0/count(issuccessfulpost),2)as nonyasc_rate from post where user_id in (select"See full answer

Jatin S. - "A project charter is a formal document that authorizes a project and outlines its objectives, scope, stakeholders, and key details. It serves as an agreement among stakeholders and provides a clear foundation for the project by defining what needs to be done and why. Typically, the project sponsor issues the project charter to the project manager or team, formally initiating the project. A project charter typically includes the following key elements to ensure a comprehensive and clear unde"See full answer

Krishnan S. - "I would start with few clarifying questions for the investigation and diagnosis of the problem. Timing and volume: For how long is the peak surge being noticed? Past few days / weeks / months? Clarify about 'certain times'. Is it weekday Morning (Peak), Morning (off peak), Afternoon, Afternoon (peak), Evening (peak), Evening (off peak) or weekend? Do we info on vehicle type that have the most volume? Cars, trucks, commercial vehicles, etc., Location and convenience of the gas st"See full answer

Bradley E. - "I'm pretty sure Exponent's answer is wrong. In the snippet below, they use "pl.name = 'Telephones' to attempt to filter down to the Telephone transactions, but they do this within a LEFT JOIN which means all product_lines rows are returned. > LEFT JOIN product_lines pl > ON p.productlineid = pl.id > AND pl.name = 'Telephones' Below is my solution. Also, I didn't see anywhere that said the "amount" column was in cents instead of dollars, but I still divided by 100 to be consistent with Exp"See full answer

Ramandeep S. - "If I were a Google PM in charge of the next Android keynote product announcement in 3 years, I would build the following: A more secure and privacy-focused Android platform. This is because security and privacy are becoming increasingly important to users. In the past few years, we have seen a number of high-profile data breaches, and users are becoming more aware of the risks of having their personal information online. A more secure and privacy-focused Android platform would help to add"See full answer

Nikolas C. - "That's really interesting how in section "Behavioral Interviews for Engineers" there is no single interview for, actually, Engineer. It's EM, SA, CEO, PM etc. So all problems are not relevant for people who are not managing products and not applying for manager's role. Will you consider adding at least couple of them? "See full answer

Mridul J. - "We have a list of documents. We want to build an index that maps keywords to documents containing them. Then, given a query keyword, we can efficiently retrieve all matching documents. docs = [ "Python is great for data science", "C++ is a powerful language", "Python supports OOP and functional programming", "Weather today is sunny", "Weather forecast shows rain" ]"See full answer

Ben G. - "Ask Follow up Questions Is this for specific type of user or open? Do we have any past research that has been done? Do we have an idea of company and user goals? Do we have metrics of success? Are there any existing constraints? Why  |  5 min Why is this product or feature important? How does this product benefit customers? What business opportunities does it create? What is our hypothesis? What are our company goals? Who  |  3 min Who are the different types"See full answer

Manik K. - "Agile methodologies are chosen by organizations to enhance delivery speed, integrate shorter feedback loops, and provide incremental value to customers. However, the suitability of Agile depends on several factors, including the nature of the work, team structure, and organizational objectives. From my experience, for teams focused on new feature development, Scrum tends to be more effective. Scrum’s structured cadence—emphasizing backlog grooming, sprint planning, and regular retrospective"See full answer

Laura S. - "Clarifying questions: is this a brand new product, or are we improving an existing one? (i.e. are we going to have to migrate an existing codebase or are we starting from scratch?). are we resource-strapped (e.g. # engineers, time)? are there any specific priorities for the product, or should i leave it open-ended? Assume: brand new product, well-resourced, no specific priorities. It seems that there are two sides to this question: 1) technical evaluation of different languages, and 2)"See full answer