Interview Questions

Derrick M. - "SELECT u.id as user_id, u.name, COUNT(t.product_id) AS orders FROM users u JOIN transactions t ON t.user_id = u.id JOIN products p ON p.id = t.product_id GROUP BY u.id, u.name ORDER BY orders DESC LIMIT 1 `"See full answer

Monika C. - "Iphone 12, It's sleek design , screen resolution, camera quality, sound quality, navigation around the apps very smooth and easy. Love the design !!"See full answer

Divya R. - "public Double calculateRatio(String source, String destination) { Double ratio=1.0; while(graph.containsKey(source) && !visited.contains(source)) { visited.add(source); Map valueMap=graph.get(source); if(valueMap.containsKey(destination)) { return ratio*=valueMap.get(destination); } Map.Entry firstEntry=valueMap.entrySet().iterator().next(); source=firstEntry.getKey(); ratio*=firstEntry.getValue(); System.out.println("Entered"); } return null; }"See full answer

Erjan G. - "this task is misleading . i used lag(1) and lead(1) cuz it did not say "compare temperature from 2 days before and 1 day before" , it reads to me as if its asking "compare cur temperature to prev and future and see if it rose and fall""See full answer

Tony A. - "Get alignment with interviewer on how Gen AI works, then talk about the automotive space with value chain analysis on high level: 1. Design the automobile 2. Source components 3 assemble 4. Market 5. sell to customer 6 vehicle operation and maintenance. Competition: Hyper competitive industry with ~10 big manufacturers in the world. Trends: EV, Self-driving Potential Goals for the Automotive company Gen AI use case: Gain market share by offering Gen AI driven value to its customers Bi"See full answer

Parag L. - "I was in my early days of leadership and strategy. In Marriott when a decision was made by C suite to buy products as wrapper over cloud providers I was surprised and based on my limited information and knowledge posted a question to Chief technology officer as why it won't be a good strategy to directly use Native offering from AWS. The reason enlightened me and gave new a new thought process that being such a large enterprise that has presence in 200+ countries across globe we may have challen"See full answer

Medha A. - "DAU and MAU: The number of active users daily and monthly to gauge the content recommended on the home page. Bounce Rate: The percentage of users who navigate away from the site after viewing only the home page. Number of Signups: The number of users who signup after seeing the content on the homepage leading to lower CAC. "See full answer

Guru M. - "I have softened recruited people through LinkedIn. People from LinkedIn are more than happy to share their feedback on new products and features and to my surprise, I also saved a lot of company money on recruiting through services and offered Amazon vouchers to participants instead."See full answer

Esteban G. - "Mentioned that business category will not be back to previous COVID levels as a result of a systematic shift in the way business is now conducted via zoon calls. Exposed poor customer service and online booking experience as a focus of "things to fix" to improve bookings Suggested to shift (upgrade) the leisure customer segment into the luxury travel experience which was previously the choice of business class. Prioritized fixing customer service digital experience as it is the central spi"See full answer

Rahul J. - "YouTube is a platform that lets users upload self generated content that's available for all other users to view, globally. It has a freemium model where unpaid users can watch unlimited content. However, the paid users get additional features that enhance the viewing experience. YouTube would like to move the unpaid users to a paid subscription model as it ensures higher ARPU for YT and gives users incentive to repeated come back to the platform to watch content. **Ways to increase conversion"See full answer