Interview Questions

Rudra pratap S. - "select sum(orderquantity) as totalunitsorderedyesterday from orders as ord join items as it on ord.itemid=it.itemid where order_date="2023-10-14""See full answer

Sumeet R. - "Google mission is to organize worlds information and make it universally accessible and useful. Keeping that in mind will focus on what should be the solve for emerging market. Clarification: Any specific country Google is thinking about ? Answer: lets say Ghana it has come often as one of the fast emerging markets and untapped Clarification: Goal is monetization or growth Answer: We are entering the market so growth Based on the clarification above I will think about user segments, p"See full answer

Anup S. - "1 Billion Matches per day is it over sized ?"See full answer

Srinivasa R. - "Any more details about this can make it easy"See full answer

Sandhya N. - "Clarifying Questions: Discover events, purchase/resell via app Post booking: After ticket purchase to event completion Motivation for Ticketmaster: Strengths: 70-80% of ticketing business, tie ups with venues Competition: meetup Low frequency product - so every experience matters Positive wom: Reduced marketing Retention of users, organizers Users: Ecosystem Attendees: Discover, buy and attend events - {chose this} Event Organizers: marketing/demand, s"See full answer

Cameron P. - "Assuming I am a PM for company X and my current task for the morning is resolving a new conflicting product requirement. First I would like to inquire more about the product and about the conflict. Product: Assuming I am new and I didn’t already know what the product was, what is our product's value proposition to our customers? How does our product align with our company's goals? What does success look like for our product? Have we been successful in the past? Who are our customers? Conflict"See full answer

Kai W. - "A high level framework Clarifications: Reactions already exist in Instagram? Any specific region or user group we try to target for the launch? ... Product description: IG is ... Reactions are Emoji alike icons users can use to reply to posts/photos/comments FB's mission: Help people stay connected and build communities IG's mission/goal: Allow users to capture world's moments and share with friends Reactions Goal: To provide users an easier way to react to the content and to bet"See full answer

Sandeep K. - "Clarifying Questions Improve Netflix; Geography? India Vision - Becoming the best global entertainment distribution service Objective: Growth Engagement Retention I would focus on Growth because Highly growing adoption of internet increasing purchasing power in T2&T3 Indian consumers are constantly in need of finding new content to watch aligned with Netflix strategy of producing content for indian masses I believe Netflix has a really good immersive viewing/wathcing"See full answer

Abhijit B. - "I would start with the User feedback- both explicit (from surveys) and implicit(from Product insights on app usage/drop offs). Then understand the business direction/priorities that Paypal wants to take with Venmo and come up with a Iteration plan that starts with "low hanging fruit" first and then builds to more ambitious products. The goal is to find features that are at the intersection of "valuable(to users), feasible(for dev) and usable(to users) . Once we prioritize these features, I would"See full answer

Praveen - "First, I would like to discuss and align what is meaningful social interaction. Given facebook's mission to empower users to build communities and get people closer, it is important that users have "meaningful social interaction" The goal of defining this metric is to use this as a north star or success metric around any efforts to increase engagement. It can also help with ads targeting/monetization by showing ads only during deeper interactions and hence might get better yield. Given faceb"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

Scott S. - " Functional Requirements Content Ingestion\: Ingest news articles from various sources (websites, social media, etc.). Handle different types of content (text, images, videos). Content Analysis\: Extract and preprocess text from articles. Analyze the content for potential indicators of fake news. Model Training and Prediction\: Use machine learning models to classify content as fake or real. Continuously improve models with new data and f"See full answer

Nikita C. - "WhatsApp is a free messaging platform, that introduces new and amazing features frequently to leverage its user data and vast user base. I assume the goal is to get revenue from the services without affecting user satisfaction. For that, I am listing a few ideas using which we can monetize WhatsApp. Whatsaap has recently introduced channels, for verified channels WhatsApp can start a subscription model. WhatsApp can introduce in-app ads in the stories section showing relevant ads. What"See full answer

Beth S. - "The DNS server of the site URL can identify the source of the traffic via GeoIP and redirect it to the Amazon services closest to that location. The load balancer, installed before the web server, can manage the load and redirect traffic to redundant services."See full answer

Rjj - "I tried solving this question and here is the recorded video for the entire solution - https://youtu.be/G_LIbTp58XA Feel free to comment here or on the video for further discussion."See full answer

Kshitij I. - "Data lake and warehouse are both places that allow an organization to store large amounts of data. When swimming in a lake, one would imagine that they come across all sorts of stuff - floating twigs, fish in the water, stones, chemicals and sometimes may be even a snake. Similarly, a data lake stores all forms of data that the company has without any indexing. The data is available at any time but needs to be first cleaned up and reorganized before it can be used for any type of analysis. A"See full answer

Mc L. - "I believe human emotions can't be judged by number and hence I have always made mistakes while judging the outcome of a reaction by data."See full answer

Mitchell K. - "How important are referrals? Do you need multiple vs. just one? Does it matter who refers you?"See full answer