Interview Questions

Darnel C. - "I consider the complexity of the task and align with the strengths and development goals of my team members. This not only fosters their growth but also builds a stronger, more self-sufficient team. Delegating allows me to focus on higher-level strategic initiatives and critical decisions that require my direct oversight. I want to ensure that I’m not spread too thin and can provide value where it’s most needed. I decide to own a task when cross functional stakeholders are involved and my expe"See full answer

Rahul J. - "LinkedIn as a platform is targeted primarily towards professionals who use it to search for and apply to jobs. Professionals can also share content like career updates, thought leadership, achievements etc. The business model of LinkedIn is twofold: Ads revenue in the content section Promoted job posts from recruiters Evaluate the business model of competitor and which customer unmet needs are they solving. Evaluate what impact is it having on our business - are DAU / WAU going down / job p"See full answer

Exponent - "This is a Measure Success question with a slight twist. The twist here is we need to consider a hypothetical product rather that one already built. This changes our formula slightly - specifically we may not be able to apply a UX flow to drive analysis since we're unsure of the implementation. Instead, we'll look at core behaviors that are indicative of success. Here's the modified formula: Ask clarifying questions State the goal of the feature **Apply a UX flow to drive a"See full answer

Jacky T. - "SELECT order_amount FROM ( SELECT *, rank() OVER(ORDER BY order_amount desc) as ranking FROM departments d LEFT JOIN orders o ON d.departmentid = o.departmentid LEFT JOIN customers c ON o.customerid = c.customerid WHERE department_name = 'Fashion' ) where ranking = 2"See full answer

Abhishek s. D. - "I would get an personal understanding of the pain-points my customers, & business teams are facing. In my experience, spending more time, going deeper in the problem discovery helped me get a rough idea of the how important this problem is. If this is not resolved - what could be the consequences for our users & the business. Given this broad idea, I just simply evaluate them on value vs effort scale. The higher the score, higher the priority. Effort could be in T-shirt size or sto"See full answer

Madeline S. - "I like Spotify, because Spotify has a social element and an element of community that other music apps do not. The ability to see what friends are listening to, make playlists/jams with friends, and enjoy the "wrapped" at the end of the year (which is also an incredible social sharing tactic), is what sets it apart from other apps."See full answer

Manoj K. - "I fumbled but my answer was along these lines Clarification: Are we talking about ChatGPT page or other ways to use it like API Ans: page When you say improve did you mean usage or monetization Ans: you pick We should pick user experience and usage since better product will enable easier monetization. Assume they monetize based on premium users subscription. Lets talk about users Business users Individual users Focus on business since traffic generated by individuals will not be as mu"See full answer

Exponent - "This question is a Diagnosis Question. It's used to test your ability to perform root cause analysis (RCA), identify many possible issues, come up with a theory of probable cause, and address how you would solve this issue. A drop in video engagement can signify either a technical issue (the video player is broken) or a product issue (recommendations performing poorly). Let's follow the template for answering Diagnosis Questions: Ask clarifying questions **List potential high level"See full answer

Rachel. kazir R. - "developing secured mobile phones for soldiers. too hot. the challenge was to find a creative ideas for power reduction on the existing technology"See full answer

Jaya S. - "Understood the problem statement by confirming details with interviewer. Approached by listing down all the basic features being provided by the platform. Platform -> Organizations can register themselves. One org can have more than one recruiters. Recruiters create jobs on the org portal. Candidate can apply to the jobs. Recruiters can accept and reject the applications. Categorized 4 parent tables by taking hints in between. The tables were USER -> ID, Name, Phone No, mail ID, Profile Des.("See full answer

Aneesha K. - "-- Write your query here select u.userid as userid, IFNULL(sum(purchase_value), 0) AS LTV FROM user_sessions u JOIN attribution a ON u.sessionid = a.sessionid group by user_id order by LTV desc ; Needs a full join. Wondering why cant we do a left outer join here. All the sessions should have complete data."See full answer

Nayla D. - "Instagram is social media app where you can share photo and video to others. Impressions is an important metrics to track because it shows how many contents that users see. Clarify Questions: Is this drop happen suddenly or gradually? - Gradually How long has it been happening? - Last 3 months Is it happen globally or in certain region? - Globally Is the drop happen to all user segments (age, new/existing, active/less active users)? - all user segments When calculating an impressions,"See full answer

Midde V. - "Front Page Layout Design for Newspaper App Header Section Logo: Displays at the top left. App Name: Displays alongside, so very prominent. Search Bar: Centered with search to find articles within the application. Navigation Menu: The links to the respective sections, World, Politics, Sports, Entertainment, and Opinion, etc Main Content Area Top Stories Carousel: It is a rotating banner that displays the top 3-5 news stories with images along with their headlines. Each story should be cl"See full answer

Exponent - "This is a Favorite Product question with a slight twist. We have a constraint: picking an e-commerce store. This should be relatively easy since we use e-commerce stores every day. Let's go over the Favorite Product formula before we begin: Choose a product and briefly explain what it is Who are the users? What are their pain points? How did competitors solve it in the past? How does this product address these pain points differently and better? **How wo"See full answer