Interview Questions

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

Irina L. - "I’ve named Netflix, Acloset, Youtube music. Focused of YouTube music, increasing social interaction of existing users."See full answer

Mudit B. - "Clarifying question Why? Does booking.com have data on demand for this new feature? Let's say no Does booking.com have any specific goal with this new feature? Improve revenue or Improve user experience ( provide flexibility in payments or expand user base dealing with crypto, etc.) Let's say targetting new users who want to deal with crypto (I don't know if this is to be approached as a product design question) I would approach the introduction of cryptocurrency as a new payment method i"See full answer

Rishi P. - "Optimizing Booking.com to improve conversion rates involves a strategic and holistic approach that considers various aspects of the user experience, website functionality, and marketing. Here are several strategies that could be employed: \\User-Centric Design:\\ \\Mobile Optimization:\\ Ensure the website is fully optimized for mobile devices, given the increasing number of users booking on smartphones. \\Intuitive Navigation:\\ Streamline the booking process with a cl"See full answer

Harshit G. - "Great. I will start by understanding the goal of Google Photos and how it aligns with the goal and mission of Google. After defining goals, I will talk about the user actions which will contribute towards this goal. Based on these actions, we will define metrics. Check-in with the interviewer on the approach here. Assuming that this looks good for the interviewer to proceed. Google Photo - Helping users organise & manage their pictures. Completely in line with Google's mission. Thinking ab"See full answer

Cameron P. - " Questions: Deadly diseases: new and current CEO of healthtech startup: adoption phase Mission: to improve and extend lives What we do: Research new diseases and connects people to doctors Structure: Objective -> Macro-Factors -> Company -> Users -> Suggestions Objective: Why? Mission to improve and extend lives How do we inform the world about these 20 deadly diseases we detected? Macro-Factors(climate/competition) World events like pandemics - this is a good investment* "See full answer

Praful B. - "The customer's business needs and requirements. The technical aspects of their legacy system. The budget and timeline constraints. The risks and mitigation strategies. The customer's specific concerns. Assess the feasibility of migrating their legacy system to the cloud - This will involve evaluating the technical aspects of their legacy system, as well as the business impact of the migration. Develop a migration plan -This plan should outline the steps involved in migrat"See full answer

Ilnur I. - "I really appreciate how he clearly explains every term he uses!"See full answer

Anonymous Prawn - "Would be better to adjust resolution in the video player directly."See full answer

Davide P. - "Microsoft's mission is to empower every person and every organisation on the planet to achieve more. I am always inspired by helping others to achieve more by participating to different volunteer and mentorship experiences like Microsoft Student Ambassador, and GeeksForGeeks student ambassador, and I have also created and shared a free competitive-programming guide which once reached more than 700 stars on github, that enables students and professionals to join Microsoft like Microsoft, that hav"See full answer

Abel alejandro H. - "I asked for clairication on what region in the world we were focusing on and I settled on the United States. I asked for clarification on the type of doctors and for what kind of patients and that was left up to me. I landed on any patient looking to find a doctor for "Preventive Medicine" given that the US is hurting on that. The pain points were around expensive/payment methods, access & lacking knowledge to know what kind of doctor is best for each person. I spent too much time here and had l"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

Ramesh Y. - "Clarification - is it Uber that is building the feature? Answer: Yes Assuming if Uber is the one building this feature, I would start with if and how does the feature help Uber's mission and north star metrics. Uber's mission is to provide reliable transportation around the world and the primary metric that i can think on a high level is Number of rides , Number of drivers and from business revenue perspective revenue per ride, revenue per rider and driver. I picked revenue per ride because it"See full answer

Anonymous Flamingo - "Handling projects out of my expertise: When faced with a project that falls outside of my expertise, I take the following steps: Identify my skills and knowledge gaps: I assess my own strengths and limitations, and determine which areas of the project may be outside of my comfort zone or expertise. Seek guidance and mentorship: I reach out to colleagues or subject matter experts who have relevant knowledge or experience, and ask for their advice and guidance on the project. Learn and adapt"See full answer

Anonymous Flamingo - "As a YouTube PM, there are several factors that I would consider when evaluating the idea of developing a tool for content creators to generate ideas with scripts automatically added. First, I would assess the potential demand for such a tool among YouTube content creators. This would involve researching the needs and challenges of content creators, as well as gathering feedback from content creators on the value and usefulness of the tool. This would help me understand whether there is a strong"See full answer