Interview Questions

Bg - "Questions: Can the toothbrush be a smart toothbrush, different from typical toothbrushes? Ans: Yes Children's age group? Ans: Pick your choice Cost? Ans: Not a concern Country? Ans: Ignore Personas: Parents typically help kids in brushing up to 5 years. Let us assume 5-10year olds as our focus. That is a decent 5%+ of global population. Pain Points: Brushing teeth for kids is a pain. They simply do not like it sometimes. Dental checkup is always a hassle. Some ki"See full answer

A B. - "Followed Clarifying questions - why this product - competition - Meta's mission - product vision - user segments - prioritize and Why - pain points for prioritized segment - prioritize pain points - list solutions - tradeoff - North star - summerize "See full answer

Anonymous Jaguar - "Code reviews, automated linting, unit tests, integration tests, validation tests"See full answer

Sangeeta P. - "A/B testing is used when one wishes to only test minor front-end changes on the website. Consider a scenario where an organization wishes to make significant changes to its existing page, such as wants to create an entirely new version of an existing web page URL and wants to analyze which one performs better. Obviously, the organization will not be willing to touch the existing web page design for comparison purposes. In the above scenario, performing Split URL testing would be beneficial. T"See full answer

Varun S. - "Question: You'e a PM at Meta. Design a product for users to find a handyman. Clarifying questions: Why does Meta want to build this? A: Up to you to decide that, hoping to here you say why. When: No fixed duration for release. Market: I'd like to focus on a developed market, where technology reach is wider and people are more at ease with using online platforms for tasks. Maybe focus on the US market to start with. Standalone app - We will need to distinguish ourselves and create an identity"See full answer

realkimchi - "Objective: Proposal for expanding the service offerings for small restaurants and local cafes. The objective is to enhance the Instacart Business platform by integrating local vendors (Speciality Food & Beverage Business Units) to increase product selection and improve supply chain efficiencies for business customers. Market Focus: The target market includes food service establishments characterized by their need for distinct, locally sourced ingredients and their struggles wi"See full answer

Alexey T. - "-- The text of the task is a bit confusing. If the status is repeated several -- times, then in the end you should show as start_date the date of the first -- occurrence, and in end_date the date of the last occurrence of this status, -- and not the date of the beginning of the next status with t1 as (select order_id, status, orderdate as startdate, lead(orderdate) over (partition by orderid order by orderdate) as enddate, ifnull(lag(status) over (partition by order_id order by or"See full answer

Arnab R. - "Trying to find the reason for the low utilization. If it is systematic risk, I will down size the team temporarily. If is due to planning try to tweak details in order to bring 50-50 with a 90 days target time."See full answer

Mitchell K. - "What has been the most complex System Design question you were asked?"See full answer

Jessica C. - "select customer_id, order_date, orderid as earliestorder_id from ( select customer_id, order_date, order_id, rownumber() over (partition by customerid, orderdate order by orderdate) as orderrankper_customer from orders ) sub_table where orderrankper_customer=1 order by orderdate, customerid; Standard solution assumed that the orderid indicates which order comes in first. However this is not always the case, and sometime orderid can be random number withou"See full answer

Aaron W. - "Clarification questions What is the purpose of connecting the DB? Do we expect high-volumes of traffic to hit the DB Do we have scalability or reliability concerns? Format Code -> DB Code -> Cache -> DB API -> Cache -> DB - APIs are built for a purpose and have a specified protocol (GET, POST, DELETE) to speak to the DB. APIs can also use a contract to retrieve information from a DB much faster than code. Load balanced APIs -> Cache -> DB **Aut"See full answer

Peter H. - "As a technology leader with enormous power and influence, Google has a significant role to play in global social responsibility. Right now, that means that Google must focus on how humanity can create a sustainable future. If I had unlimited resources, I would focus on the products that enable future mobility in sustainable cities. The success of Gogoro, the Taiwanese scooter manufacturer that has created a swappable battery pack system for small scooters, shows how green tech, consumer visib"See full answer

Amparo L. - "The most impressive thing that I’ve done was I got to do a fowards flip on the gym mat and I’ve gotten way flexible "See full answer

Ram - "Clarification: Are we talking about creating an experience or product as part of another product or from 0→1? Encourage - the goal is to increase % of citizen vote. Or want to vote? Vote - are we talking about national elections? Am I a product manager for the government? Any focus on geo, segment, or platform? Context - why do we want to do it? Did we experience a recent decline? Could it be hardware or software only? Digital or physical? Structure: Context "See full answer

Darren L. - "First, I want to understand the scope of the problem: Definite ‘inappropriate’: does it something violate our community standards? Or is it in gray area? If it violates, I treat as a bug, something bad got through our system If it’s in gray area, I continue diagnosing the issue Does it happen to all users? It may happen to all but only some reported If it happens to all —> why the rest didn’t report, was it because they hold different opinion about what is appropriate, or because they d"See full answer