Interview Questions

Amana A. - "I have nothing in my mind even upon thinking that Google Product is going to be disliked. The reason is that it is made with the effort to serve the customers. I like Gooogle because the Searching using the web browser, its timely response, especially for Research problems, we use the Google Scholar, Google collaborative, Google Documents, Google Drive, Google GMAIL inbox and the interface design, and many other things."See full answer

Siddhant S. - "We'll consider cost-effectiveness, environmental impact, convenience, and scalability. Here are key metrics and trade-offs to consider: Cost Metrics Operational Costs: Compare the direct costs associated with operating each mode of transit, including vehicle maintenance, fuel or energy, and driver salaries. Subsidization Level: Assess how much subsidy each option requires per ride or per passenger to remain free or low-cost to employees. Cost Efficiency: Analyze the cost p"See full answer

Vysali K. - "Limit and rank() only works if there are no 2 employees with same salary ( which is okay for this use case) For the query to pass all the test results, we need to use dense_rank with ranked_employees as ( select id, firstname, lastname, salary, denserank() over(order by salary desc) as salaryrank from employees ) select id, firstname, lastname, salary from ranked_employees where salary_rank <= 3 `"See full answer

Rani Y. - "Prompt : design a farm product Clarifying question : what is the timeline and budget that i need to consider to build this ? 1 year , flexible budget . Is there any geography that i need to focus on ? no restriction What is farming ? Farming is a practice of raising crops and braising animals to produce food for human survival . This is one of the old / primitive ways to grow food using natural resources like land , water etc Why is it imp now ? Farming as I said is vary primitive way to grow fo"See full answer

Shraddha D. - "I like chatgpt for the following users Getting industry references are easy and time saving Getting recommendations is very easy Responses are accurate I use chatgpt to get feedback on content and identify gaps in my documentation or thought process I use chatgpt as a search engine and to get conscise situation based information. Chatgpt offers varierty of other tools in the explore version where similar users can create different content PRD template Chatgpt users 1."See full answer

Robert H. - "The addition of an intermediate "sanitization" ML is something Neeraj used in the Uber Eats design and again seems kind of outside the scope here and redundant. This can simply be built into the AI response model to save a step. It's not clear what benefit this step provides, and he basically said we should have it "just because it would be good" and there's no concrete reasoning why to include it. Adding a Kafka queue to handle the thumbs-down ratings? For what purpose do you need a queue othe"See full answer

Pramod V. - "Referring to https://www.forbes.com/sites/forbesbusinesscouncil/2022/03/23/15-strategies-for-balancing-competing-stakeholder-priorities/?sh=7c82aa68262f Understand the conflicting priorities and align it with the goal/ objectives and the company mission. Start with the Least Common Denominator between the conflicting priorities to come to a commonality and start from there to objectively approach the next imp priority Always keep communication on and be transparent with 'equality' an"See full answer

S V. - "I think, robots.txt file is provided by websites which web-crawler is crawling. Am I wrong somewhere or missing some context?"See full answer

Kishor J. - "we can use two pointer + set like maintain i,j and also insert jth character to set like while set size is equal to our window j-i+1 then maximize our answer and increase jth pointer till last index"See full answer

Alibi M. - "I would answer this question using MECE framework: Profit = Revenue - Costs. Revenue = # customers * price In case of the trading platform, this could be translated into avg. trading activity per user * avg. commission rate . Ask if there has been any recent change to Active users or their trading activities. Similarly, ask if the commission rate has been changed recently. Based on this information, you can then identify the problem and get to the root cause of this. Similarly with Costs. "See full answer

Hans - "Described a scenario where I joined an established project as an EM Typical medium sized team - 6 devs, 2 testers, PO, PM (part time) Scrum master (very hands off) The product was well established and already being used by circa 30000 single country based users for the companies own products (personal banking capabilities) We were due to go live with a BIG change about 2 months after I joined - this change meant a user could manage multiple personal banking accounts from the 1 interface. We w"See full answer

Adarsh S. - "Thanks for the question! This is one of my favourite topics because it’s at the core of what we do as PMs DAILY: making the complex simple to drive alignment. I’ve got a structured way to approach this, and I’ll use it to explain payment aggregators - like Plaid - and how they enable Open Banking, with a twist about a technical hiccup I’ve seen in practice. Let’s dive in. I start by assessing the audience. Say I’m talking to a marketing manager at Transak - someone sharp but not techni"See full answer

Rachita D. - "I will start with making sure that I have a clear understanding of Medium and how it works. I will ask the interviewer to fill in any gaps in my knowledge of Medium. Medium is a platform for novice, and professional writers to express/share their opinions readers to read about subjects that matter to them the platform has been running for some time (6-7 years), so it is relatively mature (this confirms that Medium has found a product-market fit) Here is my high-level structure for answeri"See full answer

Hamzeh J. - "Evaluate how much the issue affects the sprint goal and timeline. If it blocks the main goal, it needs to be prioritized. Discuss the issue with the team. Analyze the root cause of the issue. Is it because of unclear requirements or a design flaw? You may need to re-prioritize tasks. If the issue is serious enough to delay or change the sprint goal, communicate the updates to stakeholders and manage their expectations. Keep an eye on the solution’s progress and adjust your plans a"See full answer

Bala G. - "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"See full answer

Ben G. - "Situation - A time I dealt with conflict while on a team was while I was working at Shopify on physical and digital gift card refund point of sale solutions. The situation was that we were dealing with complex technical constraints including not changing particular UI components behavior to act as they should be intended. On the refund screen, the existing design was using a toggle on the same screen to bring up a modal for gift card selection to either select digital or physical options. Thi"See full answer

Devendra B. - "Narrow scope of mission: As a Product Manager for Google Search, my primary mission would be to enhance the search experience for users, ensuring they find the most relevant information quickly and efficiently. This involves continually improving the quality of search results, enhancing the user interface, and exploring innovative features to meet evolving user needs. Customer segments: Google Search caters to a diverse range of users, including students, professionals, researchers, and"See full answer

Anonymous Crayfish - "Clarify Read more what & where? -> Books. Where -> upto candidate Who are we? -> A big tech company Goal -> to help people read more books Assumptions Books which aren't education/work related. Basically books that you read in your free time Read doesn't necessarily mean read text, it means looking at and making sense of what is displayed. and display can be in any form -> text or image or video Customers Kids in age of 5-12 years Teens Adults Elderly We pick kids in age of 5-1"See full answer