Interview Questions

Salome L. - "WITH discount AS ( SELECT name, type, CASE WHEN type = 'Electronic' THEN price * 0.90 WHEN type = 'Clothing' THEN price * 0.80 WHEN type = 'Grocery' THEN price * 0.95 WHEN type = 'Book' THEN price * 0.85 ELSE price END AS discounted_price FROM products ) SELECT name, type, ROUND(discountedprice, 2) AS discountedprice FROM discount; `"See full answer

Jaswanth P. - "Proposed Solution: Awareness and Control Features Algorithm Awareness Campaign Educational Content: Create short videos explaining how the algorithm works to enhance user experience. Transparency Reports: Regular updates on algorithm changes to keep users informed. User-Controlled Engagement Settings Customizable Feed Options: Allow users to adjust content preferences and limit certain types of videos. Time Management Tools: Introduce reminders for screen time limits an"See full answer

Akash C. - " from typing import List def find_first(array: List[int], num: int) -> int: left = 0 right = len(array) - 1 result = -1 # keep track of leftmost occurence found so far while left <= right: mid = (left + right) // 2 if array[mid] == num: result = mid #Found a potential result right = mid - 1 elif array[mid] < num: left = mid + 1 else: right = mid - 1 return result debug your code"See full answer

Ranj A. - "In the Transformer architecture, the decoder differs from the encoder primarily in its additional mechanisms designed to handle autoregressive sequence generation. Here's a breakdown of the key differences: Self-Attention Mechanism: Encoder: The encoder has a standard self-attention mechanism that allows each token to attend to all other tokens in the input sequence. Decoder: The decoder has two types of self-attention. The first is the same as in the encoder, but the second is mas"See full answer

Hayatu H. - "What do all data scientists need to know about how to work with very large datasets? 37 Follow Request Answer More All related (39) Recommended 📷 Corrin Lakeland · Follow , M.S. Data Science, University of St. Thomas, St. Paul (2018)6yData Science consultant and managerUpvoted by[Tom Halloin](https://www.quora"See full answer

Sam A. - "The distribution of daily search queries per user, as shown in the histogram, can be described as approximately normal (or bell-shaped) with a slight positive skew. Key Characteristics: Shape: The distribution is roughly symmetrical around its center, resembling a bell curve. This indicates that most users perform a moderate number of daily search queries. Central Tendency: The peak of the distribution, representing the highest density of users, appears to be around **8"See full answer

Ram - "Clarification Are we focusing on building the product on a specific Meta platform (Facebook, Instagram, WhatsApp), or is this a standalone effort? Is the product digital or physical? Are we targeting internal (employees) or external (customers) users? Are there any specific constraints like funding, resourcing, or geography? 1. Narrowing Down the Problem Awareness and Education: Create tools to increase understanding of climate change and its effects. -"See full answer

James H. - "I broke the vehicles down by regions in the world. Designed a wireless api interface to sync with a database backend that linked to google maps through another service and api."See full answer

Kunal M. - "I would apply the CIRCLES framework to this problem. Context: The mortgage industry is based on front to broken back-office operational processes, fragmented data, rates war, non-clarity on appraisal. The coming age of digital savvy Millenials who wants a one-stop shop for all their banking needs in a techno-savy way will pave the way for mortgage disruption. Goal: Metrics to optimize - increase market share in Loan origination, increase revue and increase customer stickiness on the plat"See full answer

Rahul J. - "Clarifying questions / assumptions we are talking about a typical retail bank and not investments banks or other NBFCs The banking app covers the primary functions of a bank like money transfers, account management, savings etc. A typical bank has the following business functions: Giving loans (primary function to make money) Savings and other accounts Investments (like Fixed deposits of the bank and other government schemes) Pain points A bank had to deploy manpower to perform all"See full answer

Angie B. - "Clarify the problem to ensure you understand what to improve - reactions are used to react to posts or comments. They show the reactors' sentiments, emotions, and opinions in a simple yet clear manner without using words. Business Objectives What are the business objectives that we need to consider before digging deeper? Are there specific goals that we're trying to achieve by improving the reactions feature? We want to increase the number of engagement and want more users to react acro"See full answer

Mala R. - "Fitness app - for kids waze - for turists whats app for senior citizens "See full answer

Luca D. - "The real discussion was very much similar o what exposed at https://www.tryexponent.com/courses/software-engineering/system-design/design-rate-limiter, but - as I commented the video - the real interviewer wasn't so naive to do not forgive the client identification only because IP. I had to introduce glimpses of https://en.wikipedia.org/wiki/Knowyourcustomer practice, I quoted JWT. I proposed a logical map of id addressing a "deque" of time-stamps of requests, with a threshold for the deque an"See full answer

Product V. - "Thanks for the question - What is your definition of the challenges - There can be multiple gaps and opportunities - Is there any specific opportunity you want me to look - Are free to assume My understanding of online purchase can be card not present or e-commerce - any specific you want to look Region - USA Goal - Feel free to assume - Trust Timeline - Say about a year Take a pause - Segment 1 - Online shoppers only Segment 2 - Strictly Brick and Mortar Segment 3 - S"See full answer

Abdurhman M. - "Even after a successful launch and long-term performance locally, app developers will need to develop a rigorous expansion strategy to succeed on a global scale. And although users are more connected than ever before, each region will present new challenges and considerations that must be solved by data-driven insights and research into the target market. This guide outlines everything you need to consider when expanding into new territories and localizing your app for new audiences."See full answer