Interview Questions

G B. - " select user_id, b.marketing_channel from user_sessions a Left join attribution b on b.sessionid = a.sessionid group by 1,2 HAVING sum(purchasevalue)>100 and min(adclick_timestamp) `"See full answer

Karthik M. - "I would always pick a specific product and make a case. Answering this question without a specific product in mind makes the answer unstructured in my opinion. For instance, I would pick Gmail as an example to answer this and structure my response. Clarifications & Assumptions Let us pick a specific product and structure our response - for instance - let us pick Gmail as the product that you want to analyse and make a Go / No Recommendation to Sunset the Product. Overall Google Revenu"See full answer

Ankit kumar S. - " logo Contact Interview Preparation Application Process Career Advancement Onboarding and Orientation Common Interview Questions Dashboard Creation Interview Questions and Answers Dashboard Creation Interview Questions and Answers What is a dashboard? Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"See full answer

An D. - "First find the node that we need to delete. After it's found, think about ways to keep the tree BST after deleting the node. a. If there's no left or right subtree, we found the leaf. Delete this node without any further traversing. b. If it's not a leaf node, what node we can use from the subtree that can replace the delete node and still maintain the BST property? We can either replace the delete node with the minimum from the right subtree (if right exists) or we can replace the delete"See full answer

Pathworks P. - "I would begin by asking the following clarifying questions: Are there any special use cases such as VIP Penthouse access, restricted floors etc? Do we need to consider safety requirements or other technical constraints such as maximum load/capacity? If the lobby for the entire hotel located on the ground floor? Can we assume that the majority of the guest amenities are located near the lobby and lower floors? Can we assume that the passenger controls on the floors are purely directional"See full answer

P K. - "Clarifying questions, Before I begin, I want to make sure I understand what the product is. FB fundraiser is a platform for entities (charitable organizations) and individuals to create fundraising campaigns, invite certain users to it, share it with others and ask them to invite potential contributors to it. It is also part of the core facebook product. The approach I want to take about defining goals is as following: Define the mission of FB as a company, goal of fundraiser p"See full answer

Anonymous Flamingo - "As a product manager, my first step in designing a free product would be to define the product's target audience and the problem it aims to solve. Once these factors are established, I can then determine the best way to monetize the product. One way to monetize a free product is through advertising. This involves displaying ads to users as they use the product, and earning revenue based on the number of clicks or impressions the ads receive. This model is commonly used by social media platforms,"See full answer

Dhruv M. - "During my internship at Inceptra Analytics, our team was working on improving the monthly reporting process for the operations department. I proposed switching from manual Excel reports to a Power BI dashboard to automate and visualize key metrics. However, some team members were hesitant—they felt the current process, although tedious, was more familiar and controllable. My task was to get buy-in from the team to adopt a more efficient reporting method without causing disruption or resistance."See full answer

Ankita S. - "let's say I'm working on a social media platform and considering implementing a new feature: "Reactions" to posts, similar to Facebook's reactions (like, love, haha, wow, sad, angry). Here's how I would conduct an A/B test for this feature: Define goals and Identify the feature: Goal is to increase user engagement and provide more nuanced ways for users to express their reactions to posts.The feature I want to test is the introduction of "Reactions" buttons alongside the traditional "Lik"See full answer

Kk - "Clarifying Questions : By reducing bandwidth , do you mean reducing the total size of video transfer reduction ? Ans Yes Is it ok to reduce the resolution by reducing the bandwidth : Ans May be yes and no Any app in particular you are looking forward which could help talking from its standpoint : Ans : Youtube Assumptions : Youtube has a compression algorithm which can still be made better with the evolution of technologies Solutions ( prioritised list ) Improve the compressio"See full answer

Dan H. - "Assumptions Instacart for Business is core Instacart with additional features and capabilities tailored to businesses. Users Potential user segments: Office managers (Focus here) Entrepreneurs/small business owners Restauranteurs Opportunities (pain points, needs, problems) Many places don’t offer same-day shipping. Inconvenient to physically go out and purchase these items from a store if urgent Hard to predict an"See full answer

Saket S. - "I will ask few clarifying questions to the interviewer: Is there any specific application that we are referring to (assuming B2C website/app) What are we Trading off here (assuming Requirements/Features) I will consider following criteria to prioritize Trade offs: Impact on User experience: In terms of usability, reliability, and efficiency Usability: Ease of Use, Intuitive UI Reliability: Functions as expected and produces desired results, tolerates user mistakes and prevents unauthor"See full answer

Stanislav I. - "I want to work at Stripe because Stripe has become the industry standard for many businesses and startups in the world. As a CFO I would be proud to work with a leader on a processing market, improving it position with my skills and experience. I will be happy to be a part of this great Team and learn from them."See full answer

Pm P. - "Clarification: Are we talking of Amazon as an entity in whole (or) Amazon E-commerce ? I would like to use overlap across following buckets with emphasis on current product & markets, Future adjacencies and expansions, strengths barrier to entry in the markets either way Amazon Intuit Products - Considering Amazon as a whole - Devices - AWS - E-Commerce - Music - Video - E-Books - All other services, currently there is no overlap between the use-cases and services offered"See full answer

Sri A. - "Mission: to help users buy and sell products from groups. If we think about the value here, users want to join groups that sell/buy products of interest (young moms or vinyl), or location of interest, or trust, or some other factor - either from other users or SMBs. User Actions: create groups, join groups, active in groups - make posts to sell or show interest in buying (like, commenting, sharing or ideally transacting) deeper engagement - sharing , saving , searching more based on wh"See full answer

Shoaib H. - "Clarifyig questons Why do we want to re-design the feature? are there any existing problem with the existing DM feature? -- you figure out Do we have any particular goal in mind which we want to achieve? related to Engagement, Session time etc? -- Think yourself When we say DMs, this includes P2P, Message to business, Message to an open account or you have something else in mind? -- Think yourself With that bieng said lets first understand what are the core use cases of the DM as a feature P"See full answer