Interview Questions

Adriel W. - "A DOS attack is meant to shut down a machine or network, making it inaccessible to its intended users. Some mitigations would be knowing what normal and abnormal traffic is. Deploy Firewalls for sophisticated application attacks."See full answer

Jayveer S. - "WITH suspicious_transactions AS ( SELECT c.first_name, c.last_name, t.receipt_number, COUNT(t.receiptnumber) OVER (PARTITION BY c.customerid) AS noofoffences FROM customers c JOIN transactions t ON c.customerid = t.customerid WHERE t.receipt_number LIKE '%999%' OR t.receipt_number LIKE '%1234%' OR t.receipt_number LIKE '%XYZ%' ) SELECT first_name, last_name, receipt_number, noofoffences FROM suspicious_transactions WHERE noofoffences >= 2;"See full answer

Mohit C. - "-- LTV = Sum of all purchases made by that user -- order the results by desc on LTV select u.user_id, sum(a.purchase_value) as LTV from user_sessions u join attribution a on u.sessionid = a.sessionid group by u.user_id order by sum(a.purchase_value) desc"See full answer

Gowtami K. - "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"See full answer

Karthik R. - "Use Dijkstra's Algorithm with priority queue"See full answer

Anonymous Muskox - "Clarification Question what does it mean by the different markets? Emerging market, developing market, or developed market. Technical Front Low bandwidth or network can affect the performance Latency can be high if the server is not placed near to the regions Business Front The average number of people who indulge in corporate or white collar jobs is very less. Jobs in the local market is very less People who don't have smartphone/desktop excess extensively may not be present on the"See full answer

Sarah K. - "I once had to change a decision i had previously made when I got stakeholder feedback that seemed to contradict what was already designed or already even built - such as the way a page was architected or the designs or colors used on a page. I had a justification for all decisions made, but sometimes the stakeholder feedback brings a perspective, such as a part of the user experience, that I had not thought of before. So I then went back to the original design or product and made an adjustment o"See full answer

Vincent T. - "Google Maps has achieved remarkable success due to several key factors that have set it apart in the realm of digital mapping and navigation services. There are a few crucial reasons behind its success: Comprehensive and Accurate Data: Google Maps has a vast database of geographic information, including detailed maps, street views, and satellite imagery from all around the world. It provides accurate and up-to-date data on roads, landmarks, businesses, and other points of interest, allowing u"See full answer

Exponent - "This is a Measure Success question. These questions are asked to gauge your familiarity with common metrics such as DAUs and MAUs, A/B testing, and ability to map user behaviors and flows to impactful metrics. A great PM will also be able to deeply understand when metrics sometimes fail (e.g. blind spots). Knowing metrics closely is also crucial to demonstrating the impact of a project, whether it's after launching or the ongoing impact. Let's follow the Measure Success formula to tackle"See full answer

Ying T. - "def encode(root): if not root: return [] def dfs(node): if not node: return res.append(node.val) res.append(len(node,children)) for child_node in node.children: dfs(child_node) res = [] dfs(root) return res def decode(arr): if not arr: return None n = len(arr) i = 0 def dfs(val, children_count): if children_count == 0: return Node(val) cur_node = Node(val) cur_node.children = [] for j in range(children_count): nonlocal i i += 2 cur_node.children.append(dfs(arr[i], arr[i"See full answer

Anonymous Crayfish - "Let me tell you about a time when I learnt the craft of writing and sending emails. I worked at an early stage startup that does voice recording and transcription and one of my primary responsibilities was to engage with existing customers. At that time, there were a around 10k users in total. I decided to split the entire user base into cohorts. Users who've recorded and transcribed atleast 10 words within 3 months Users who've recorded and transcribed atleast 10 words within 3- 6 month"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

Kartikeya N. - "Clarifying questions What do we mean by bookings? Is it nights booked or transactions?: Nights booked Are there any constraints like platform or anything else while calculating the nights booked? : No If a user books a night but does not show up, do we still count him? : Yes If a user cancels before turning up, do we not count him? : Yes Expedia operates globally. Its major markets are Europe, USA, Asia, Africa etc. We will take the following high level approach **Total population →"See full answer

Charles E. - "I will continue to try to be more thorough about the analysis to match my expectations, experience has taught me to do something calmly and with high accuracy, therefore even though work uses deadlines, I must stay focused and calm to do it so that accuracy is not lost while working"See full answer