Interview Questions

Daniel C. - "select name, stock from products p left join transactions t on p.id = t.product_id order by date desc limit 1"See full answer

Rahul R. - "I would first call out the two types of Google Doodles that are published. First would be the static doodle which just shows a picture, and users can get more information on it by hovering on it or clicking on it. Second would be the dynamic google doodles which are either short videos or games through which users engage a bit more. My top 3 metrics that covers both would be: Click-through rate and post-click CTR - Although different metrics, I clubbed them since they fall under similar"See full answer

Anjaly J. - "Spotify is a music streaming app. Monetization of Spotify happens in multiple ways : Ads Subscriptions (Ads free, premium) Make Spotify default on Android phones as Apple Music on Iphones Spotify to be a default on Nest hubs Exclusive membership (New songs ) Learn with Spotify classes Chat with Content creators (for a minimum fee)"See full answer

Mehdi K. - "It would be good to talk about the impacts on costs as well"See full answer

Lavanya S. - "To enhance customer adoption of JPMorgan Chase's Payments Developer Portal, I propose a feature called "Guided Onboarding and Custom Integration Paths." Feature Overview Guided Onboarding: A step-by-step onboarding process for new users that includes interactive tutorials, video walkthroughs, and a personalized dashboard based on their needs and use cases. Users can select their business type and goals (e.g., e-commerce, retail, fintech) to receive tailored content and API recomm"See full answer

Deepak K. - "FN Given text need to figure out is it following guidelines. Should notify the user in case of not following guidelines. Reason for failure should have misleading/spam/adult filters. NFN High availability High Scalability Low latency of processing Estimations 1M requests/min text - 10kb => 9.5GB/min => 14TB/day API fetchmoderationscore(text) score will be between 0 to 1 more than 0.8 => not following guidelines fetchmoderationscore(text, filter)"See full answer

Mallory M. - "The first thing I would want to do is understand why. Did the requirements change? Did we underscope the project? Were there unforeseen technical complexities? Did our capacity or velocity change for any reason? Did other more urgent priorities come up that shifted focus away from this? Next I would want to understand all of the risks of missing the launch deadline. Are other teams dependent on our work? Are there any external marketing communications tied our to launch? What will be the impact"See full answer

Anonymous Hare - "Sharing the approach for functional requirements we tool to solve this question. Functional Requirements This is only for the Registered users What is a "For You" page ? Home page where you get suggestions based on people you follow. Interactions like/share/comments (done by user) Interests (shared by the user during registration or onboarding) sports choices/ region choices/ Video sharing platform. So how many videos should we s"See full answer

Scott S. - "As a Software Engineering Manager, one of the biggest mistakes I encountered early in my role involved underestimating the importance of aligning team goals with individual career aspirations and professional growth opportunities. This oversight became evident through a project that initially seemed successful but later revealed deeper issues within the team dynamics and morale. I was leading a software development team on a major project aimed at revamping a critical trading platform. The proj"See full answer

Saurabh K. - "P(A) = 0.6 P(B) = 0.4 P(D|A) = 0.05 P(D|B) = 0.03 Question asks to solve for P(A|D) P(A|D) = (P(D|A) x P(A))/P(D) = (0.05 x 0.6)/(P(D|A) x P(A) + P(D|B) x P(B)) = (0.05 x 0.6)/(0.05 x 0.6+0.03 x 0.4) = 30/42 = 5/7 = 0.714 Notice above that P(D) = P(D|A) x P(A) + P(D|B) x P (B)"See full answer

Nikita B. - "Mission for TikTok shop is to increase brand growth and sales. TikTok gives platform to these brands/advertiser to market their products via influencers/creators to be able to sell their products faster and users on tiktok platform(mainly Gen-z) are motivated to make inspirational based discovery of products and purchase them So main objective for TikTok shop could be Increase sales for diverse brands So, some of the metrics to consider would be: no of orders placed per week"See full answer

Rahul J. - "Clarifying questions Target market: parents Geo: USA Key value proposition: help people in parenting Target market assessment Reach: Every year, millions of people become parents and they need to take majority of decisions for their children till the child is 18. Frequency: The decision making and guidance is needed on almost every aspect of the child's life - so the frequency is high Importance: Making decision and managing children is one of the most important aspect of people"See full answer

Push S. - "STAR story weaved around the project 0 to 1 execution with all the technical tradeoffs, issues, and success metrics involved."See full answer

David P. - "delete"See full answer

Janakiram P. - "goal of whatsapp: to connect people at no cost associated to it, over internet, with complete privacy and 100% encryption clarify improve means? increase # of users increase revenues? increase # of countries its used in ? increase features ? who are the customer personas of whatsapp: students working professionals families individuals SMEs current features of whatsapp : communication: video/audio calls, messages document sh"See full answer