Interview Questions

Arshad P. - "Schema is wrong - id from product is mapped to id from transactions, id from product should point to product_id in transcations table"See full answer

Karthik M. - "Structure Why should we build this? + market, company, product, trends Users Painpoints Solutions Summary Clarify company - 0 to 1 Why should build this Market factors Size and opportunity (tam) sizeable market - billions of dollars in TAM Competitors (1) governments (2) parkmobile (3) vendors for each parking lot (parking structures / lots, man people) Strengths Parkmobile - available anywh"See full answer

Ben G. - "Problem & Users What is the primary problem the App is trying to solve? Who is the primary user for the App? What is the core value proposition and what business model does it employ to serve the value? What are the business goals the app is trying to achieve and how effective is their strategy Structure Is the purpose of the app clearly conveyed? How is the overall use of space? Is there enough negative space? How does the Information Architecture help users accomplish de"See full answer

Derrick M. - "SELECT d.departmentname,SUM(o.orderamount) AS total_revenue FROM orders o JOIN departments d ON d.departmentid =o.departmentid WHERE o.orderdate >= CURRENTDATE - INTERVAL '12 months' GROUP BY d.department_name ORDER BY total_revenue DESC; `"See full answer

Anhul C. - "I would take the following approach: Define what acquisition of a merchant means - It could be a few of these actions - 1. Merchant provides their email/phone number to shopify, 2. They create a store 3. they sign up for a subscription Second we need to establish the method we are using to acquire new merchants Assumption - it is paid advertising on IG and FB given that's one of the ways of acquiring audience on these platforms and is easy to track. Other approach could be social"See full answer

Hamilton D. - "I will teach the user to use the application in a simple and objective way"See full answer

Product V. - "QQ  Design a product to help people feel more rested Clarifying Questions What is the definition of being rested - Am I the PM for google or any other tech startup - tech startup Does this help people meditate or sleep - Say sleep well and relax What is the specific goal of the product - Refresh people Is this mobile or any other medium - it is mobile based offering Any specific country - USA Any other constraints - No other constraints **How th"See full answer

Abdurhman M. - "Solving current problems by considering what would have happened if the past had been slightly different."See full answer

Exponent - "You should be able to identify this as a Strategy Question, which asks you to justify high-level business decisions and strategy. Here are some ideas for risks to Airbnb: Regulation > I believe the biggest risk to Airbnb is regulation, both from local and foreign governments. Already, Airbnb is subject to onerous laws in foreign countries. For example, homes in London can only be booked for a total of 90 days in London, and in Japan hosts must apply and register their listing with the gov"See full answer

Hmm T. - "Understand what is the business objective behind the ask ? We should not be adopting trends just because everyone is adopting, it has to be tied to business objective Once objective is clear - we need to determine feasibility and cost\benefit assessment by deciding on pilot candidates - since its bank, do we want to integrate this with mobile banking only ? Once we decide on candidate - we will also need to decide on buy vs build decision ? If there are any fintech offerings (like Zell"See full answer

Vinit K. - "I have often experienced my manager believing in something while I don't. The situation largely arises when the manager is under pressure of taking decision and has not spent enough time on researching about the decision. While I on the other hand have always spent time learning about issues right since we feel this is going to be a challenge in the near future. In such scenarios, I would believe something else base on my research while the manager would have some other belief based on his exper"See full answer

Anonymous - "Functional requirements: (a) location tracking (b) check-in at nearby place (c) view historical checkins with how much time user stayed there (d) Mark checkout when out of proximity (e) analytics - checkins by user at given loc, top n places Out of scope: (a) checkin sharing with followers Non functional: (a) low latency (b) high availability (c) eventual consistency Scale: (a) QPS: 10M DAU * 2 checkins /86400 seconds (b) Yearly Data Volume: 10M* 0.1 KB *365 days HLD: user -> location servic"See full answer

Lucas G. - "I would conduct a sample z-test because we have enough samples and the population variance is known. H1: average monthly spending per user is $50 H0: average monthly spending per user is greater $50 One-sample z-test x_bar = $85 mu = $50 s = $20 n = 100 x_bar - mu / (s / sqrt(n) = 17.5 17.5 is the z-score that we will need to associate with its corresponding p-value. However, the z-score is very high, so the p-value will be very close to zero, which is much less than the standa"See full answer

Deepti K. - "I gave multiple answers including polling the service every 10 sec to see customer. Or we can have the client side call which will send this data after 10 sec to us. We will store in dynamo DB and then send through pipelines to redshift DB for analytics."See full answer