Interview Questions

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

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

Dev S. - "Clarfying questions : When we say a decrease in users adding the bank accounts. I would like to understand how the users making payments within Venmo I assume they are either using their credit cards/debit cards? I would like to understand why the Adding of Bank Accounts is integral to Venmo since the users are using the debit card and Credit Cards. My understanding is when the payments happen through debit cards rails Venmo pays higher interchange fees and to Reduces any losses incurred"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

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

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

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

Abdurhman M. - "Graphic design is the process of visual communication and problem-solving through the use of typography, photography"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

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

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

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

Rohit B. - "class Solution: def missingNumber(self, nums: list[int]) -> int: Sorting approach n = len(nums) s = n*(n+1)//2 r = s - sum(nums) return self.r l = [3,0,1] print(missingNumber(l))"See full answer

Connor W. - "This video is a duplicate of the other video in this lesson, "Design A/B test for New Campaign""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

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

Darpan D. - "Clarifying When we say cloud gaming, we refer to a video gaming experience using cloud computing, right? Assumption: Yes. Understanding of cloud computing first. I'll use some analogies: Imagine you are looking to do heavy computing but don't have a powerful CPU and GPU. CPU and GPU are like your big calculators. You can buy a powerful CPU and GPU, but problems: It costs a lot to buy. It costs a lot to run. You don't need it 24-7. You are not a un"See full answer