Interview Questions

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

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

Ashish G. - "Rate Limiter is to limit the number of request from a particular IP Address. Rate limiter will block the IP address to reduce the load on server. It should be highly available and handle concurrent requests. Blocked IP addresses should be kept in a pool which is present in shared cache. We need to keep threshold value after it reaches threshold value it should start blocking IP address. All these ip address to be kept in No SQL DB. Batch will run that will clear the cache and delete all the bloc"See full answer

Ankit kumar S. - " logo Contact Interview Preparation Application Process Career Advancement Onboarding and Orientation Common Interview Questions Dashboard Creation Interview Questions and Answers Dashboard Creation Interview Questions and Answers What is a dashboard? Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"See full answer

Aayush S. - "With $1 billion to invest in generative AI, my focus would be on addressing unmet needs in everyday life. Here's my vision: Identify User Pain Points: I would start by understanding the specific challenges a segment of users face daily. Many people are integrating AI into their routines to simplify tasks, yet there are gaps that need to be filled. Learn from ChatGPT’s Success: ChatGPT's rapid growth to 200 million users demonstrates the demand for AI solutions that genuinely solve"See full answer

Dinar M. - " Thanks a lot for showing us how a recommender system can be build. I see it was proposed to use Collaborative filtering which is user - item matrix having dimension N * M (where N - number os users and M - number of songs). Though, it was explained how it gonna be built, it is still unclear how all users and songs features are going to be used. In that matrix we have values in cell (lets say i, j) like 1 - a specific user (i) clicked on song (j) when it was recommended or it is 0 when the user"See full answer

Kaitlyn M. - "System architecture diagram. Define API params, responses, tradeoffs between caching and webhooks to update message delivery status."See full answer

Bailey O. - "For this answer, I'm assuming that I'm a PM who has just started at this company. I assume this product is a growing start-up and that's why I wasn't familiar prior to taking the role. Understand the business, mission, and product's context: Understand the company mission, values, vision Understand any near-term/long term company goals Meet & listen to key stakeholders & decision makers Build relationship with team members Understand who the first 'sale' or 'bu"See full answer

Hl M. - "Would love to have transcripts posted below videos with timestamps to help us browse the video when video lengths are typically longer"See full answer

Indranil G. - "So we need to only consider Delhi within city limits? Yes And will we consider the big trees and not bushes? Yes Now inside Delhi total size is 1484 sq km means 2000000 sq km In this, there are 2% area which is lake or water so remove that will be (2000000-( 2000000 km*2%) )= 1960000 sq km In this area in Delhi, we have 20 % area where it is a park that means ( 1960000- (1960000*20%)) = 1568000 km area nonpark and 392000 km is a park area Obviously, in the park area, the density will b"See full answer

Helen Z. - "Two clarification questions first! When we say quarters, are we assuming the quarters are stacked on top of each other, or are we measuring across the diameter? let's say they are stacked. And second question, is the height of the building just from the ground floor to the top of the building? yes. Okay, the key numbers we need to find then are the height of the building in feet, and the # of quarters that fit into a foot. First for the height of the building, the key numbers are heigh"See full answer

Pankhuri T. - "Hi Everyone, As an aspiring product manager, I feel with the latest Ray-Ban or Orion AR glasses that provides hands-free experience to the user. So basically, with these glasses you can interact, ask it to remember where you parked and what can you make with the ingredients which are in front of you, I think an extension to it can be a very great healthcare product. Now let's imagine that this glass is storing all your eating habits, what medicines you take, with an integration to meta watches"See full answer

Apurv K. - "!! FEEDBACK WELCOME !! Clarify question By art we mean visual art, e.g. paintings? - Yes Is this a solution to create art on Instagram or to showcase existing art on Instagram? - Create art Why build this, Engagement or Acquisition? - Engagement Reframe: We want to increase Instagram engagement through creation and sharing of art with followers. Talking about the space The Internet has over time continuously reduced barriers to creative expression. From blogging to Twitter"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

John H. - "All products and services have to sell. I would create measurements on how much time, labor, and funds went into a project and how much value it brings back to customers and company."See full answer

Volderdore - "Population of Bangalore - 1.4 cr On an average 4 people live in 1 householde=> 1.4cr/4 => ~35L HouseHolds Out of the 35L Household, 30% household fall below poverty line are not interested in ordering online due to their own personal reasons prefers to visit to the hotel directly and eat instead of ordering online => Thus remaining is ~25L households out of the 25L households, assuming at least 20% of the households place one order on average on any given day will lead to 5L orders"See full answer

Kartik D. - "Clarifying Questions: What age range are we looking at between 13-19? Any specific range we need to target? - Assume all teens Any demography we would target? - Worldwide Do they have access to phones/laptops or do we need to build an offline product? - Assume they have access to phones and laptops Are there any constraints around privacy or content moderation? - Yes What platform (Facebook core, Messenger, or another product) is this for? - Assume faceb"See full answer

Ankit kumar S. - "To analyze a year-over-year (YoY) slowdown in transactions, you should start by understanding the context, segmenting data, identifying potential drivers, and then formulating actionable recommendations. This involves a structured approach that includes a thorough examination of the data, both internally and externally. Understand the Context: Define "transactions": What specific transactions are being analyzed (e.g., website purchases, in-store purchases, total transactions)? Timeframe: Sp"See full answer

Kanishvaran P. - "class Solution { public boolean isValid(String s) { // Time Complexity and Space complexity will be O(n) Stack stack=new Stack(); for(char c:s.toCharArray()){ if(c=='('){ stack.push(')'); } else if(c=='{'){ stack.push('}'); } else if(c=='['){ stack.push(']'); } else if(stack.pop()!=c){ return false; } } return stack.isEmpty(); } }"See full answer

Yair G. - "Are we speaking of all Meta Ads products on something specific? All of them Meta is a social media and AI company that generates most of it's revenue from Ads on social media. Meta's mission is to empower people to build communities and bring the world closer together. If ads violate the community guidelines regulations that can directly hurt both Meta's mission and its revenue stream. For example ads that include hate speech are against community guidelines and also hurts Meta's mission. Ha"See full answer