Interview Questions

Sergio C. - "Clarifying questions is there a main reason why we want to improve it? For instance: active users declined monetization declined performance issues customer complaints (Based on this clarifying question the following answer could be any to be honest. if the interviewer says that it's an open questions, then I would go to the product design framework) Assumption Based on the impact that we would like to do, 1) I would assume that we are looking to improve the messaging experi"See full answer

Erjan G. - "1) select avg(session) from table where session> 180 2) select round(sessiontime/300)*300 as sessionbin, count() as sessioncount from table group by round(sessiontime/300)300 order by session_bin 3) SELECT t1.country AS country_a, t2.country AS country_b FROM ( SELECT country, COUNT(*) AS session_count FROM yourtablename GROUP BY country ) AS t1 JOIN ( SELECT country, COUNT(*) AS session_count FROM yourtablename `GROUP BY countr"See full answer

Aayush S. - "With $1 billion to invest in generative AI, my focus would be on addressing unmet needs in everyday life. Here's my vision: Identify User Pain Points: I would start by understanding the specific challenges a segment of users face daily. Many people are integrating AI into their routines to simplify tasks, yet there are gaps that need to be filled. Learn from ChatGPT’s Success: ChatGPT's rapid growth to 200 million users demonstrates the demand for AI solutions that genuinely solve"See full answer

Rafał P. - "def changeString(org: str,target:str) -> bool: lOrg = len(org) lTarget = len(target) \# They have to be equal in lenght if lOrg != lTarget: return False counter1 = Counter(org) counter2 = Counter(target) \# Counter internally iterates through the input sequence, counts the number of times a given object occurs, and stores objects as keys and the counts as values. if counter1 != counter2: return False diff = sum(org[i] != target[i] for i in range(n)) return diff == 2 or (diff == 0 and any(v > 1 f"See full answer

Srilaxmi C. - "Step 1: Clarify Before delving into the metrics, should I consider the current state of Google or when it just launched? Here, I am assuming the current state of Google. Google is currently a company that makes approx $15) billion in Revenue and 90 % of the revenue comes from Ads. Ads are core for Google's business and Google is the major player in the market Step 2: Goals: The main goal is to maximize revenue through effective Google Ads campaigns. This means ensuring that the campaign"See full answer

Cesar F. - "Outliers are data points that significantly deviate from the majority of the data distribution. They can arise due to various reasons, such as measurement errors, natural variability, or rare events. Outliers can distort statistical analyses and machine learning models, making it crucial to detect and handle them properly."See full answer

Bailey O. - "For this answer, I'm assuming that I'm a PM who has just started at this company. I assume this product is a growing start-up and that's why I wasn't familiar prior to taking the role. Understand the business, mission, and product's context: Understand the company mission, values, vision Understand any near-term/long term company goals Meet & listen to key stakeholders & decision makers Build relationship with team members Understand who the first 'sale' or 'bu"See full answer

Adib M. - "Clarifying question: Do I know of this other team? Have i worked with them before? Do i know the TPM of this team B? 1) Schedule 1-1 TPM of this other team (Team B) with the agenda to better understand Team B project 2) State that you came to know that Team B is working on what sounds like a project similar to your team and you want to understand more about it to see what is common /what is different, what are the objectives and who the stakeholders are and so on. Also, important to know how f"See full answer

Musonda C. - "Imagine you have a friend from France that speaks French, and you only speak English. You and your friend want to play a talking game. So, for your friend to understand you and for you to understand what your friend is saying you would need an API between the two of you. The api has its own language called api language. You and your friend will both get a small book that tells you how to speak api language. The api in between you and your friend would allow both of you to speak API language to"See full answer

Praniti S. - "Google VR mission - my understanding is to provide user an immersive experience where your room is the exploration ground/canvas and consumer has limitless possibilities What i know about VR : VR umbrella: Daydream and Cardboard VR devices: Headset/Cardboard/Desktop/Mobile VR product: Google Maps VR/ Carboard VR/Youtube VR/ TiltBrush/ Blocks VR feature: High quality video/ low latency video? Which product are we adding a new feature to? Tilt Brush which device are we implementing the new feat"See full answer

Debajyoti B. - "Understanding the problem: What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source Are we supposed to enhance the viewer's experience only or the creators as w"See full answer

Irene C. - "Of course! Let me outline a general approach and ask questions along the way to see if any one path makes more sense to follow. On my general approach: I think it's important to start with a strategic goal or purpose the museum is trying to accomplish with this product. That way we have a north star. From there I'll identify a couple user types we could solve for. Once aligned, I can drill down to potential pain points and solutions of different magnitude. How does that agenda sound? For our"See full answer

Anonymous Fox - "In what terms we need to improve the quality? Is there any focus on any particular host/customer experience? - Let’s consider that we need to improve the customer engagement on Airbnb platform. Airbnb has both - web interface as well as mobile interface. So, I am assuming the experience on both the platforms. I will brief about Airbnb - Airbnb provides homeowners to rent their spare rooms/properties to travelers/visitors and at the same time, travelers/visitors can get accommodation at budget"See full answer

Amparo L. - "Hard worker, positive attitude and arrives ready to work with no emotional issues."See full answer

Sangeeta P. - "Marketing campaigns are run through different channels such as social media, emails, SEO, web advertising, events, etc. Let’s look at some of the overall success metrics at a broader level: Total views for your campaign Unique views for your campaign Returning visitors for your campaign Engagement for your campaign (If it’s a social media campaign, the marketer might be interested in knowing the number of users engaging with the campaign and the type of campaign positive/negative) 5"See full answer

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

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