Interview Questions

Davide P. - "Microsoft's mission is to empower every person and every organisation on the planet to achieve more. I am always inspired by helping others to achieve more by participating to different volunteer and mentorship experiences like Microsoft Student Ambassador, and GeeksForGeeks student ambassador, and I have also created and shared a free competitive-programming guide which once reached more than 700 stars on github, that enables students and professionals to join Microsoft like Microsoft, that hav"See full answer

Dan D. - "I love the answer and framework, my summary of the interview: it is a slightly modified version of Porter's 5 Forces: User benefit -> Bargaining Power of Buyers Apple benefit -> Talks about the company mission and culture (esp. on the relatively closed eco-system) It was expanded more in the latter half of the interview (SWOT + a bit of Value Chain) Competitive landscape -> Industry Rivalry + Threat of New Entrants + Threat of Substitutes Partnership Impact -> Bargaining Power of"See full answer

Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

Ankit J. - "Clarifying questions: What is the motivation for Airbnb to consider entering furniture space? Assumption: Data suggests the quality & type of furniture has a direct impact on guests’ Airbnb experience. Many hosts are also converting their Airbnb’s into full-time businesses, so there is a revenue opportunity here while improving the experience. Is Airbnb looking to feature furniture listings on Airbnb.com? It’s still TBD. We want to know if it’s a good idea first. Are there any other g"See full answer

Gaurav C. - "Clarifying Questions: Do we have any specific goal in mind for this new product, for example targeting new audience, expansion to new places , catering to new need etc. · I am going to assume targeting new audience Do we have any constraints? · No constraints When you say restaurants does it mean casual restaurants, pubs, food joints 5 star hotels etc. · I am going to assume all kind of restaurants who have already registered there establishments on Swiggy Structure User Segme"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

Shreejal L. - "Clarifying questions: Should I include the tail of the helicopter when computing the area for this question? Can I assume that the average ping pong ball has a radius of around 1 inch? Assumption: Assume that the helicopter is more circular than a rectangle. Hence use the formula of a circle in computing the area. Assume that the helicopter's radius is 5 feet a 6 feet person can't stand on the helicopter because they're tall for it hence rounding down. Assume that th"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

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

Alemayehu m G. - "I would try to understand their perspective, focus on the issue, find common ground, brainstorm solutions, and agree on a course of action."See full answer

Atharv S. - "Assumptions / Questions: tech inclinations: AI induced Painpoints: helps me get up early, but no cues for my morning rituals. Goal: Comprehensive morning exp and not limited to just getting up but also aiding in the morining rituals. Get up early and fresh, set the tone for the day. User Segment/cat: Biz: parents Schools. Geo: India? Prod: students: >= 12, 13-18. School, Boarding school kids. Solution: Workflows like clock: Aesthically apealling and more engag"See full answer

Raymond W. - "Clarifications/assumptions - we're only interested in opening and closing hours, not serving times e.g. breakfast or lunch time format etc will be local only interested in regular hours not special holiday hours Potential users/data providers (ranked by order of authority) Businesses/Advertisers Consumers Google Goal Coverage Prioritising the most popular restaurants, or those who are willing to invest in advertising Accurate, but conservative - better be wrong to"See full answer

Y C. - "One way to develop project metrics is around what problem the project is trying to solve within a particular timeframe, at a cost of x dollars and with y quality Scope: Did the project deliver as per the problem statement - over and beyond Resources metrics: Planned resources were utilized to contribute to the success Budget: Did the cost of the project implementation be under the budget or over? Schedule: In-flight milestones were completed on time or not as per the plan Was the proje"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

Anonymous Cat - "Good practice video; however, at minute 6:40 in this video, the interviewer confirmed the app version causes no issue! While the final answer was the app version!"See full answer