Interview Questions

Alexey T. - "-- The text of the task is a bit confusing. If the status is repeated several -- times, then in the end you should show as start_date the date of the first -- occurrence, and in end_date the date of the last occurrence of this status, -- and not the date of the beginning of the next status with t1 as (select order_id, status, orderdate as startdate, lead(orderdate) over (partition by orderid order by orderdate) as enddate, ifnull(lag(status) over (partition by order_id order by or"See full answer

Lucas G. - "A confidence interval gives you a range of values where you can be reasonably sure the true value of something lies. It helps us understand the uncertainty around an estimate we've measured from a sample of data. Typically, confidence intervals are set at the 95% confidence level. For example, A/B test results show that variant B has a CTR of 10.5% and its confidence intervals are [9.8%, 11.2%], this means that based on our sampled data, we are 95% confident that the true avg CTR for variant B a"See full answer

kkkt - "Me: First let's clarify the user journey of the Facebook dating app Interviewer: Me: Do we know how success is defined in this context? Interviewer: Please figure that out yourself Me: Ok let's first discuss the mission of Facebook and how Facebook dating app is part of that. Then lets brainstorm what the goals would be for Facebook Dating. That help us determine the user behavior and metrics we can create. Finally let's fi"See full answer

Yulia D. - "First, I would like to ask some clarifying questions. Are we talking about the business metrics dashboard or health metrics(like response time)? - it is up to you Do I understand right that Netflix is a subscription-based video streaming service for watchers? So I know that they create original content for Netflix, but it is out of the scope of this question. - right My approach will be to: Define the business goal from Netflix’s mission Break down the actions taken by users at each stage of the"See full answer

stash - "Clarification What does showing ads mean ? Is it showing outside of the car as a mobile billboard or showing inside of the car on screens? —> Inside of the car / digital ads What is our product strategy with Waymo. Do we want to get into the ride hailing business or license our tech —> To be defined by you Do we have any near or long term revenue goals for this —> Get wide usage of Waymo tech and be a key driver in accelerating the adoption of self-driving cars accessible in the world"See full answer

Anonymous Mastodon - "WHAT IS IMPORTANT TO CUSTOMER VALUE TO THE CUSTOMER IMPACT ON THE CUSTOMER PRIORITIZE BASED ON THAT the sales team wants Specific changes to customer - Value NPV etc Client services want automation - Customer priority "See full answer

Howard H. - "We have to work with the c-suite to understood the direct quartly outcomes or goals. This could be our epic and then we try to break that down into business value and complexity . This will allow us to prioritize whats next. From there we can structure a mvp to cover maybe some of these areas to understand the estimation of this work. After the first couple weeks we can structure a roadmap and then define when"See full answer

Kavya C. - "MTBF is Mean time between failures. This is measured to figure out how reliable a system is by what is the gap between 2 failures. (Total time elapsed- Down time)/No of failures"See full answer

Anjali M. - "Several reasons why eCommerce will capture a trillion$ market in the next 10 years. User consumption habits have changed and the pandemic has only accelerated user behavior to order online from the convenience of buying from home. The supply chain is becoming better with partnerships and digital products are making shipping and deliveries much more convenient. Many companies investing in automated shipping vehicles eg Drone deliveries and in near future we might see automated driving v"See full answer

jantheman88 - "Company Mission: To Organize the World's Information Clarify: What type of product are we looking to build? Software, Hardware? -> Hardware Makes sense since Google has a strong software stack including Android TV, which is a huge business by Firestick & Nvidia Shield, as well as Chinese based hardware implementations. Is there any restrictions for this type of approach, or are we free to go around any way we'd like? -> You're free to take any approach you'd like. Google has a strong c"See full answer

Aekagra S. - "I'll approach this by asking questions and creating scenarios based on answers. If the answer to any questions points to a specific issue, I'll double down on that to understand the issue. This is more of a RCA question. First I'll quickly check Were there any recent updates released before we observed the drops? Assuming Yes, I'll check the updates released and check the test cases and testing results If the issue is identified, I will engage with the product leadership, update them and conne"See full answer

Anonymous Sparrow - "Clarifying question: board meetings have varying degrees of formality, usually dependent on the size of the company and whether it's publicly-listed or still private. Is there a particular type of board meetings you'd like me to focus on? (Assume interviewer responds with: why don't you design something that's flexible to be used for any type of board meeting and any type of company) Sounds good, I'll leverage my own experience and understandings on how board meetings are run and problems to so"See full answer

Anna H. - "Clarifying questions: How to define “price” in this interview question? Price is defined as the market value of a crypto asset (bitcoin, Ethereum, tether, BNB etc.). Due to the characteristic of crypto assets which is time-sensitive, is this designed for a particular period of time? 1H, 1D, 1W, 1M, 1Y? No Do we know the target customer segment given geographic location or demographic? Not specific. Is it designed across devices? Mobile app. Assumptions: There are 03 cu"See full answer

onering2ruleall - "Total volume of the swimming pool, let's say it's a standard 50m x 25 m x 2m =2500 m3 = 2.5 million litter standard water horse water flow rate is 17 liter per min. So, 2.5 m / 17 =147,059 min"See full answer