Interview Questions

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

Bala G. - "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"See full answer

Will P. - "There are several categories of ads that users may encounter on YouTube content pages, depending on the user's device and browser. To narrow the scope of my answer, I am going to assume this is a non-skippable, midroll video ad that is 15 seconds long, and shown to a non-premium desktop user in the US. The next step is to clarify the motivations behind the proposed feature. Are non-relevant ads harmful to the overall user satisfaction? Do users engage more with relevant ads? Are advertisers mak"See full answer

Hari priya K. - "Netflix is a OTT platform that streams content , TV shows, movies documentaries, to the subscriber's of Netflix. Netflix has approximately 90 million subscribers in USA alone and Netflix's revenue is generated based on their subscriptions. The user buys Netflix subscription, logs in , opens profile and opens the home page of Netflix. 1. Confirmation of the Assumptions Homepage Definition: The homepage is the screen users see after logging into their profile, showing tailored recom"See full answer

Jay K. - "First, let’s discuss why this is important for any platform business Think of platform businesses like Amazon or YouTube as matchmakers. They connect people who want something with those who provide it, whether it's products or content. But here's the catch: users trust these platforms to make sure they're getting good stuff. They want genuine products, safe content, and no scams. So, platforms need to be like guardians. They check suppliers and content creators to make sure they're not"See full answer

Kartikeya N. - "Clarifying questions: What city/ country are we talking about? Indian metro. What all counts as a grocery store? Do have to cover dark stores as well which are not open to public? Only consider all grocery stores where public pick up is allowed. Do we have to include hyper markets/ super markets as well or only smaller stores? Include both. Okay, so I would be considering the Indian metro of Bangalore here. The overall equation is , **total number of grocery stores = Number of small grocer"See full answer

Hans - "Described a scenario where I joined an established project as an EM Typical medium sized team - 6 devs, 2 testers, PO, PM (part time) Scrum master (very hands off) The product was well established and already being used by circa 30000 single country based users for the companies own products (personal banking capabilities) We were due to go live with a BIG change about 2 months after I joined - this change meant a user could manage multiple personal banking accounts from the 1 interface. We w"See full answer

Daniel P. - "Okay, so I understand the question: "how does Google Maps compute estimated time of arrival"... There are a couple scenarios when ETA is calculated: planning a future journey, planning current journey. Can we assume scope to the current journey? The learnings will likely be transferable. User inputs to ETA include origin, destination, and route chosen. Let's assume first that the user has chosen an origin, destination, and a route chosen. We can come back to these assumptions later. The way I'"See full answer

Hayatu H. - "How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)? 1 Follow Request Answer More All related (34) Recommended 📷 Trausti Thor Johannsson · Follow Been using MySQL for more than 16 yearsDec 27 There are functions like DATEDIFF but there are also BETWE"See full answer

A R. - "I liked the role of a TPM due to the opportunity to contribute to the multiple dimensions of software product development. As a TPM I need to collaborate with multiple teams like Engineering, Product, and other business functions, but I also get the opportunity to contribute to the technical aspects of the program/project. I can use my sharp analytical skills to identify/anticipate problems, and leverage my problem solving skills to unblock the teams. I orchestrate multiple teams effort to del"See full answer

P R. - "First I'd like to clarify the definition of reactions and confirm that it's same as what exists today. Definition: Reactions provides users the ability to provide richer expression beyond 'like' Business goal: Since this is a mature product, the business goal is to improve user engagement Product goal: Bring people closer together by letting people provide more accurate sentiment to the community based on the content Personas: 1. Content creator 2. user using reactions **Li"See full answer

Mike Z. - "Clarifying questions Scope: Just Reels in Facebook, or Instagram too? Mobile and desktop? Goal: Any specific goal we know of or up to me to decide? Framework/Overview Strategy Metric options with pros/cons North Star Metric (NSM) Risks & countermetrics Strategy / The Why: we want to give people … Meta: the power to build community + Bring people closer together Reels: new form of self-expression / entertainment with short form video and pro editing tools Ads in Re"See full answer

Abhinav M. - "Always assume good intentions on the part of both parties when resolving conflicts. Then proceed with a STAR example."See full answer

Steven M. - "Clarifying questions: I assume we're focused on the consumer side of this? ** Yes I am assuming post booking begins immediately after booking a ticket and ends when the user leaves the airport at their destination. Does that sound right? ** Yes Goals: United Airlines wants to get its passengers to their destination seamlessly, safely, and on time. Users: I think about user groups in 3 main buckets. 1) 24 hours following booking 2) >24 following booking through 24 hours before boarding "See full answer

Saisandeep M. - "Explained the charts with using Scatter Plot with Size and Color Encoding X-axis: Ride duration (in minutes). Y-axis: Total fare (in dollars). Point size: Encodes the star rating (e.g., larger points for higher ratings). Point color: Indicates whether the rating is favorable (green) or unfavorable (red). Heatmap for Correlation Analysis Why: Heatmaps are ideal for quickly identifying patterns and correlations between variables. How: Create a heatmap matrix where rows represent ride durat"See full answer

Ama M. - "Answering only estimation portion for practice (for some reason after submitting the formatting is unorganized) clarification and assumptions can I assume this grocery store location is called Greens can I assume that self-checkout means that customers checks out without assistance? can I assume that cashier checkout means that cashier assists customers with checkout? can I assume that ratio means how man self-checkouts should be place at this grocery store compare"See full answer

David I. - "WITH filtered_posts AS ( SELECT p.user_id, p.issuccessfulpost FROM post p WHERE p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01' ), post_summary AS ( SELECT pu.user_type, COUNT(*) AS post_attempt, SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success FROM filtered_posts fp JOIN postuser pu ON fp.userid = pu.user_id GROUP BY pu.user_type ) SELECT user_type, post_success, post_attempt, CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate FROM po"See full answer

Clayton P. - "The interviewer hinted that a two-tower recommender system might be a suitable approach, using user history to embed users and pages separately and train on view or interaction data. Instead, I proposed a different approach that I felt was more aligned with how knowledge is structured in Confluence: I designed a system using a graph database to model the relationships between Confluence pages. Each page is a node, and edges represent content-based references. For example, when one article"See full answer