Interview Questions

Akshay D. - "SELECT name, type, CASE WHEN type = 'Electronic' THEN price-(0.10*price) WHEN type = 'Clothing' THEN price-(0.20*price) WHEN type = 'Grocery' THEN price-(0.05*price) WHEN type = 'Book' THEN price-(0.15*price) ELSE price END AS discounted_price FROM products; `"See full answer

Anonymous Hummingbird - "Q: should this be part of FB or a standalone product? A: no hard requirements, it just has to be something that FB would launch Q: is there a specific region we should be designing for? is it ok that we focus on the US as its the current epiccenter of the pandemic? A: Yes that's fine Q: fighting covid-19 is a very broad goal, what if we translated this into decrease the spread of covid-19 - there's multiple ways we could do that but it makes it a bit more concrete. A: Yes that sounds good "See full answer

Harish K. - "Swiggy could implement to increase the average order value (AOV) on its platform: 1. Smart Recommendations and Upselling: Personalized suggestions: Leverage data to recommend items based on past orders, popular choices, and trending items in the user's area. Upselling prompts: When a user adds an item to their cart, suggest related or higher-value items (e.g., "Would you like to add a side of fries with that?" or "Upgrade to a large for just ₹X more"). Bundle deals: Offer c"See full answer

Navin T. - "Clarification Question: What kind of revenue is Target trying to increase? ( Gross Revenue, Net Revenue .. etc ) Answer: Let's stick to Gross revenue. As I understand, the target has two revenue streams - In-store and online purchases. Are there any other revenue streams I should consider? Answer: No Why Now ?. Answer: we have seen our revenue being impacted due to competition from Amazon and Walmart, and our revenue is flat. Which revenue stream do you see a decline, increase, or flat?"See full answer

Amit T. - "Question Design a product for P2P borrowing & lending money Clarifications Is this only P2P borrowing/lending or can financial entities participate too? - P2P only Is it to borrow/lend physical cash/digital money/cryptocurrency? - digital fiat money Are we focusing on specific geography? - US What’s the goal of this product? - Retention Are there any resource constraints? - No What’s the timeline to launch MVP? - 6 months FB Mission Empower people to build commun"See full answer

Talles S. - "Me: Thanks for the question. I have a clarifying question, how the actionable data points are arriving? Is it based on direct user feedback or from the iPhone integrated with the Airpod Pro? Interviewer: You can consider both. Me: Ok, let me take a minute to structure my approach. Me: First, I would begin by establishing the types of users of Airpod Pros, and I come up with two: 1) the casual user that goes for a run once in a while or listen to music 1-2 hours a day. 2) the pretty intense"See full answer

Sourabh M. - "\>> Amazon Mission & Strategy \>> Where does Amazon Prime fit into Amazon’s mission? \>> Analyze Amazon’s positioning thru \Porter’s 5 forces \ \>> Available Options \\Amazon Mission & Strategy\\ \>> Vision // To be everything store \>> Jeff Bezos // Your margin is my opportunity \\Amazon Prime\\ \>> Loyalty program to help increase customer loyalty // CLTV \>> Fuels Bezos philosophy of \“your margin is my opportunity”\ \>> Amazon Services\: E-Commerce, OTT, Mus"See full answer

Rohan S. - "I got to play with a VR for the first time a few weeks ago at my friend’s house and I loved it, so this is a really fun question. Clarifying Questions Is this something we are looking to create Microsoft or are we a startup company etc? > Education can refer to elementary, high school, university, or even self-learning (e.g. Udemy). Is there a specific area we want to focus on? << What do y"See full answer

Anirudh G. - "Initial Questions: 1.How many patients do you think you will have in the next 5 years? Interviewer: Max 1000 In that case we don't have to build a highly scalable system. 2.Will you be carrying out some procedures like xrays, ct scans or will only be doing consultations? Interviewer: We will be doing minor procedures. Will refer to hospitals for anything major. 3.I see that you mentioned 2 locations. Are there any special billing requirements for each of them? Interviewer: No Users: Fo"See full answer

Vlada J. - "Adding to what Zoe already mentioned: running a user study with existing customers to understand if they see the proposed design as favorable running AB testing with users to compare two different designs and decide which one is more favorable (based on a previously determined metrics)"See full answer

Anonymous Unicorn - "Count items between indices within compartments compartments are delineated by by: '|' items are identified by: '*' input_inventory = "*||||" inputstartidxs = [1, 4, 6] inputendidxs = [9, 5, 8] expected_output = [3, 0, 1] Explanation: "*||||" 0123456789... indices ++ + # within compartments ^ start_idx = 1 ^ end_idx = 9 -- - # within idxs but not within compartments "*||||" 0123456789... indices "See full answer

Ram - "Clarification Are we focusing on building the product on a specific Meta platform (Facebook, Instagram, WhatsApp), or is this a standalone effort? Is the product digital or physical? Are we targeting internal (employees) or external (customers) users? Are there any specific constraints like funding, resourcing, or geography? 1. Narrowing Down the Problem Awareness and Education: Create tools to increase understanding of climate change and its effects. -"See full answer

P K. - "Note: Modifying the question to reflect the storage cost as well. Question: Estimate the cost of storing google photos on the photos app? Clarifying questions: Google photos - an app that syncs automatically to your camera app and uploads photos to Google cloud and reduces the need to store it on your device Cost of 1GB storage $0.002 Time storage cost per year Equation: Cost of storage per year = average cost of storing photos per day x 30 days x 12 months The ave"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

Yag S. - "I studied Exponent's TinyURL system design video. My interviewer was asking many detailed questions on API design, schema, as well as data required to store. I found system design questions are bit high level instead of depth. I think should have detail design of API, schema and some additional flavors."See full answer