Interview Questions

Adib M. - "Useful article on API migration https://www.linkedin.com/pulse/tips-successful-api-migration-pooja-nihalani/"See full answer

U K. - "Additional of COVID disclaimers to COVID related reels in instagram has helped users to navigate the crisis effectively as well as get the facts addressed regarding the vaccine."See full answer

Anonymous Salmon - "Situation Action Result"See full answer

Ben G. - "In my time as a product designer, I’ve seen a transition of growth from something that is visually appealing to what is actually useful / functional / scalable. I think as designers, we are afraid to let things go such as the visual fidelity of design and how something could be useful but not necessarily have the flash of a more consumer based product. I think when we learn to let that go, we can see the scale of our impact and that we aren’t just people who make something look good/pretty but t"See full answer

Shivam B. - "The Critical Rendering Path (CRP) refers to the sequence of steps that a web browser takes to convert HTML, CSS, and JavaScript into a fully rendered webpage. CRP highlights the processes that can slow down the time it takes for a webpage to become interactive for users."See full answer

Jessica C. - "select customer_id, order_date, orderid as earliestorder_id from ( select customer_id, order_date, order_id, rownumber() over (partition by customerid, orderdate order by orderdate) as orderrankper_customer from orders ) sub_table where orderrankper_customer=1 order by orderdate, customerid; Standard solution assumed that the orderid indicates which order comes in first. However this is not always the case, and sometime orderid can be random number withou"See full answer

Abdurhman M. - "Graphic design is the process of visual communication and problem-solving through the use of typography, photography"See full answer

Tyler V. - "This is a very interesting question. First, I would like to ask a few clarifying questions about the premise, as I am not a bird expert! (pause for polite chuckle.) For the purposes of this question, I am going to assume some priors about you mean when you say "survival" and "adaptation". If we are discussing these in the evolutionary sense, it's very difficult to understand the time scale and actual causality that would be needed to bring about any sort of assessment of how this one aspect of"See full answer

Amparo L. - "The most impressive thing that I’ve done was I got to do a fowards flip on the gym mat and I’ve gotten way flexible "See full answer

Anonymous Hummingbird - "Q: How do we know that they spend too much time in the app? A: User research/Qualitative survey goal: decrease dissatisfaction that they spend too much time in IG Persona's, lets segment based on usage: New users: just signed up and getting the hang of it lurkers: don't post or engage, just follow contributors: post occasionally (stories + posts) super users/micro influencers: post daily, engage with commenters, spend a lot of time in discover tab IG mission statement is to capture and s"See full answer

Chirag C. - "was this techincal phone screen round or panel discussion round?"See full answer

Pm P. - "Alexa: Is the virtual assistant that runs on amazon smart speakers as well as on other devices. Clarification on goals/Objectives: What would the goal at that point of time be? Is it increase in revenue ? Either via new customers i.e. adoption or Increasing the wallet share of the customer? Increasing the sales ordered via Alexa ? Why do people want to use Alexa? To get answers, make their lives easier by automating activities within their home Integrates with amazon account so"See full answer

Aneesha K. - "-- filter for december and november data -- the total order amount per depatment per month -- department, month, order_amount with monthly_orders AS ( SELECT department_id, strftime('%m', order_date) AS month, SUM(orderamount) AS orderamount FROM orders WHERE orderdate >= '2022-11-01' AND orderdate < '2023-01-01' group by department_id, month ), -- -- add difference from this month to last ( use lag ) monthly_comp"See full answer

Olasile A. - "How would you decide on ad placement on Pinterest? First I would ask clarifying questions as to the reason why no ads have been placed in the top left section of the page feed. Is this more strategic to Pinterest's mission? Is this by design to lay out the architecture of the page feed this way? In the prompt, it is explained that the company is targeting revenue increase as a goal this quarter. Are there alternatives means to generate more revenue in order not to compromise our values an"See full answer

Anonymous Wasp - "I was able to provide the optimal approach and coded it up"See full answer

Jagan M. - "This system design question is very small compared to other questions like design instagram, twitter, google drive etc... Since the design involves less components the level of detail we have to go in them were deep. I had to explain how to deal with all the NFR for the distributed cache system. Whether it is a push model or a pull model. Hade to do BOE calculations for the database too."See full answer