Interview Questions

Kirill K. - "DevOps it's bridge (methodology) between the Dev\Qa\etc(tech teams) and Ops to satisfy the business requirements, reduce the costs, reduce time to market, etc ..."See full answer

Ankit M. - "Clarifying questions: When we talk about a 'meditation app', are we mainly focusing on audio content? And are we thinking of this under a big brand or are we a fresh startup? Also, is our main target the US? And, are we designing mainly for individual use, or are we thinking about larger settings like schools? Interviewer: It's a startup. We're aiming for individual users, mainly in the US, and yes, an audio-based format. Summary till now: In today's digital age there's an increasi"See full answer

Jasmin R. - "Let's imagine you want to open Google Maps, you type maps.google.com and hit Enter. Here is what happens: You type maps.google.com into the address bar of your browser. Browser completes the address, for example, maps.google.com → https://www.maps.google.com [Address decoding] → browser breaks down the URL into parts ‘https://’: protocol → how the browser should connect to the website Default is HTTP (Hypertext Transfer Protocol) which shows up as ‘ http:/"See full answer

Mark - "Questions: Should we consider US or Global? Is there any existing market insights/research around driverless cars adoption? Can we assume that driverless car technology is production / public ready by 2025? Is this focus on commercial or consumer use? Assumption: Let's look at US to start for our estimation since Driverless car regulation and adoption trend will probably differ per country Let's also assume we want to estimate market size for driverless cars in 2025 for consume"See full answer

Glados - "Prompt - annual cost of managing Google photos (note - I believe Google doesn't ask estimation question anymore, not sure who/here/how this was asked) We will go over what Google photos is, its users, how they use photos, what costs are incurred, estimation - base case then scale it out, gut check the answers, and arrive at an estimate Google photos is a photo and video storage service. Its users are Content creators/users Google (hosting) Other service providers that provide value-add"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

Dhruv S. - "Before proceeding, I just wanted to clarify we wanted to check for the impact of showing content from non-friends in users’ feeds, and here non-friends I would assume could be anyone, but mainly like content creators, and I am not including ads here. But I wanted to ask if there is any current logic as to what posts to show based on users' affinity to those posts, maybe basis the user engagement to Insta feed. now objective of this would be to improve the engagement of the platform, as if users"See full answer

Venkata rakesh M. - "Here if we breakdown each dependency [A,B] , We need to check if there a cycle in Dependency Graph. If there is cycle installation is not possible, If there is no cycle installation is possible. Steps : 1: Build the graph 2: Perform DFS based Cycle Detection 3: Check each package if those packages have cycle or not."See full answer

Sreeram reddy B. - "user table - with userid, username, email, phonenumber, accountcreateddate exercises table - types of exercises - indoor walk, outdoor walk, running, stairs, cycling, swimming etc - exerciseid, exercisetype date table - date, day, month, year - with dateid Session table - userid, sessiondateid(linked to dateid in date table), exerciseid, distance covered, calories spent, starttime, endtime "See full answer

XYZ - "We have observed that DAU have been declining, while MAU has remained constant. Activity is define as: Logging in. Viewing content. Posting content. Interacting with other users (likes, comments, etc.). Daily Active Users (DAU): This measures the number of unique users who engage with Instagram on a daily basis. It indicates how frequently users interact with the platform and reflects its daily stickiness. Monthly Active Users (MAU): This measures the number of unique users who en"See full answer

Anonymous Muskox - "YouTube Goal -> Give voice to everyone and show them the world, Video -> Shorts( Dominated by Shorts, Reels, Tiktok Mid(1-25 Min). -> Youtube Medium Long(60-90 Mins) -> [Opportunity] Long(150-180 Mins) -> OTT Platform, Movies Youtube can assist content creators on Youtube to make high-quality Film Like Videos without any Production Setup. Assisting Content Creators to create Movies with"See full answer

Rita V. - "Gardening product for Meta Clarifying question: Is this going to be a new product? Or part of FB/IG? Gardening as a work? Pleasure? Lets start with META mission - Meta’s mission is to bring people together and form a community. In our case of gardening, it can be smart to solve the case of tips and questions, specially for users that just start to do some gardening. Its a nice hobby and can bring people to work together and support each other. Users I think I will go and seg"See full answer

Umang S. - "Context - I joined a large public-facing service as a PM midway through its development. Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics Concern - As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework This was evident in the show and tells as the"See full answer

B. T. - "The interviewer was interested how the system design would be for files, directories, symbolic links. After proposing my idea, I was asked to print all files for a given path."See full answer

Hashmina H. - "Clarifying Questions: Do we want to target a particular geography or location or should it be done globally? Assume global Is there any particular platform and device we are targeting (App/web) or should it be cross platforms? Cross platforms Can I think about it as Product led solutions or do you want to consider marketing alternatives as well? Let's start with Product led solutions & later if time permits, we can touch on the marketing side as well Are there any constra"See full answer

Mohammad shahid S. - "We were working on a very high stake migration project where were suppose to migrate all the traffic (more than 40 million users per day) from legacy to modern micro-services based architecture. Before making this massive migration decision, company has already developed a lot of services outside monolith and we were suppose to utilise those services. Some these services there were PADs responsible to communicate the specific vendor APIs. For each vendor we had a dedicated PAD. Fast forward"See full answer

Anshika R. - "Functional Requirement User should be able to add review the food item/order User should be able to rate the food item delivered User should be able to Like/Dislike others reviews User should be able to see all reviews on a food item Users should be able to receive rewards based on criteria- (Quality of the reviews- Based on number of likes - Monthly cash card) OOS - Item is already ordered and exists in a separate system, User is authenticated. No Media Non Functional requireme"See full answer

D P. - "Question for the community: have others experienced a situation where the interviewer really pushed for defining a success metric early on in the case before making too much progress on the case itself? If so, how did you handle? How I approached the case: I used the framework taught here on Exponent but have a question for the community. At the beginning of the interview, I shared my steps - company goals, customer, painpoints, solutions, prioritize and if we had time, I'll explore some succ"See full answer