Interview Questions

Gabriel P. - "Hi, my solution gives the exact numerical values as the proposed solution, but it doesn't pass the tests. Am I missing something, or is this a bug? def findrevenueby_city(transactions: pd.DataFrame, users: pd.DataFrame, exchange_rate: pd.DataFrame) -> pd.DataFrame: gets user city for each user id userids = users[['id', 'usercity']] and merge on transactions transactions = transactions.merge(user_ids, how='left"See full answer

Shivam B. - "In my role as a Product Manager at a B2B SaaS startup, I encountered a situation where we were facing a critical issue with one of our key features. Our engineering team proposed a quick fix that would address the immediate problem, but it was clear that this solution wouldn't provide a sustainable long-term solution. Despite the pressure to implement the short-term fix and resolve the issue swiftly, I decided to advocate for a more comprehensive, long-term strategy that would address the root c"See full answer

Cameron P. - "3 fav products. Pick 1 and 10X it. My criteria: Add value to my life Easy to use My fav products: Pinterest Youtube Google Docs How would you 10X Youtube? Interviewee: 10X revenue? 10X user base? 10X sales? Interviewer: you can decide Interviewee: Ok, let’s discuss Youtube's mission and goal and we will determine which direction to proceed after Youtube: Global product. Has Red,Music,Kids,Premium. Subscription and Ads. 5B videos watched per day. 80% market share Missio"See full answer

Anonymous Tortoise - "SELECT i.item_category, o.order_date, SUM(o.orderquantity) AS totalunits_ordered FROM orders o JOIN items i ON o.itemid = i.itemid WHERE o.order_date >= DATE('now', '-6 days') GROUP BY i.item_category, o.order_date ORDER BY i.item_category ASC, o.order_date ASC;"See full answer

Kedar W. - "with login_data as ( select * from useractivitylog where activity_type = 'LOGIN' ) ,cte as ( select userid, timestamp as currentlogin ,lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc) as previous_login, round((julianday(timestamp) - julianday(lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc))) * 24 * 60) as minutes_elapsed from login_data ) select * from cte where currentlogin  previouslogin;"See full answer

Exponent - "You should be able to easily identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! "See full answer

Graig - "Reflect leadership quality in software engineering team"See full answer

Saket S. - "If other org is not taking PM seriously, then following may be potential reasons: They don't like the way PM communicates with them They do not understand project goals They do not understand requirements clearly They are occupied with other high priority project I think Project Manager did not prepare himself well before reaching out to org for resources. He can use the following approach to get resources from a different org: Good documentation: PM should capture the project"See full answer

Anonymous Reindeer - "Clarifying Questions: Is it a chain of supermarkets? Or just an individual market? Is the revenue overall or just from one store? What are the reasons for the revenue growth? Pandemic? New buildings around? Other? What does the supermarket sell? Anything specialized? Local goods? Is there an app/website available to order stuff? 10,000 - 50,000 Vision: Be the most customer centric store Goals: Able to reach out to as many users as they can. Increase the user base while keeping th"See full answer

Vinay P. - "Fintechs are providing ready solutions for various financial operations of banks with customer-centric UI which are easy to integrate with various platforms and cost-effective."See full answer

KAI - "Clarified on definition of hyperlocal - Defined it as a community of people in a 2-3 km radius and assumed geography as India Talked about different type of community needs in a hyperlocal space - public services, local grocery delivery, food delivery, parcel delivery, making new friends for shared interests like playing badminton (Prioritised public services since it was underserved with respect to things like sewage cleaning, electricity outage in an area, community traffic problems, water"See full answer

Abdurhman M. - "I had a very difficult situation where the company I was working for was having financial problems. Because of that, I had to fire one person from my team. I chose the team member we had hired most recently. She had great potential, but she still needed guidance to do her job. Before I talked to her, I reached out to some acquaintances from other companies, and one of them was hiring. So, when I gave her the bad news, I also told her about that opportunity. I gave her a recommendation letter and"See full answer

gdecuri - "I suggest a 4 step process: Ensure your recruitment process and company's branding are inclusive. This means using inclusive language in your job postings, avoiding gender stereotypes, and making sure your company's website and social media presence are welcoming to people from all backgrounds. Partner with nonprofit and cultural organizations to reach a more diverse pool of candidates. Many organizations can help you connect with candidates from underrepresented groups. These org"See full answer

Sneha D. - "Created a solution for remote online learning app on the lines of coursera and also made a option for live streaming classes . Uni admin creates uni account, courses, adds instructors; instructors can create content , give classes ; student searches, enrols, consumes content. Used micro services architecture with APIs for all functions, RDBMS, NoSQL , indexed with redis and elastic."See full answer