Interview Questions

Jayveer S. - "with jay as (select employeeid, max(score)  as maxscore from test_results group by employeeid,testid) select employeeid,e.name as employeename ,sum(maxscore) as totalscore from jay inner join employees as e on jay.employee_id=e.id group by 1 order by 3 desc"See full answer

Mahima M. - "class Solution: def lengthOfLIS(self, nums: List[int]) -> int: temp = [nums[0]] for num in nums: if temp[-1]< num: temp.append(num) else: index = bisect_left(temp,num) temp[index] = num return len(temp) "See full answer

Bhuvan D. - "DFD, data flow diagram or Information flow diagram helps a business user clearly understand technical concepts as it links use cases with technical concepts. While feature document along with user stories (with acceptance criteria) works best for technical user to understand business concepts."See full answer

R K. - "Clarifying questions: Can we pick any business product across CapOne spectrum? any preference? - Assume pick any Are there any specific geographies you'd like to focus on? Are there any specific customer segments you'd like to focus on? Are you able to provide any information on the market/competitive analysis? Or I can just make reasonable assumptions along the way. Confirming we care about revenue? not profit per customer? Lay out the framework: I'd like to focus on the followi"See full answer

Ben G. - "Situation - A situation where I used creative / innovative thinking to eliminate frustration with a product was while I was working on Point of Sale and Polaris for Retail Design System for Shopify. Upon seeing our vision for the future of this design system, it lacked a lot of the visual polish and necessary components that would make the product much more competitive in the market - this included having a lack of an interaction model for what is tappable vs. not tappable as well as containmen"See full answer

Vidhyadhar V. - "public class CircularBuffer { private T[] buffer; private int head; private int tail; private int size; private final int capacity; public CircularBuffer(int capacity) { this.capacity = capacity; this.buffer = (T[]) new Object[capacity]; this.head = 0; this.tail = 0; this.size = 0; } public void enqueue(T item) { if (isFull()) { throw new IllegalStateException("Buffer is full"); } buf"See full answer

Michael F. - "As an interviewer, I have asked this question to candidates in the past. Here are the major topics I am looking for in an interview The candidate should understand that there are ways of measuring the loss of a particular clustering. For example, we can take the average distance of each point to it's cluster center. The candidate should understand that this loss will always decrease as the number of clusters increases. For that reason, we can't just pick the value of K that minimizes the l"See full answer

Esha - "Clarifying Questions What do we mean by ‘improve’? Is there a certain goal that we are trying to attain? Is there a target user that we are going for? Any constraints or things to keep in mind when building this? Assumptions Only focused on google docs and not collaboration on other G-suite products such as PPT or sheets What is Google Docs? Web-based productivity tool that allows you to access your files from any computer through your gmail account. You can also share and"See full answer

Scott S. - " Project Overview: Real-Time Risk Management System Objective The goal was to develop a real-time risk management system capable of processing and analyzing large volumes of trading data to provide near-instantaneous risk assessments. This system was crucial for enabling traders to make informed decisions while managing their exposure to various market risks in real-time. Complexity Factors 1. \\Data Volume and Velocity\\ \\High Throughput:\\ The system needed to ha"See full answer

Aruna D. - "Assumption #1: the deal is signed and the customer now will being the process of moving to GCP Assumption #2 : the deal includes Iaas as well as Paas (App Engine) - moving apps from on prem to cloud Objective : Design a product that will help the customer onboard and successfully plan the move to GCP. Customer is using on premise and is new to cloud. Lets assume the tool should include the roadmap planning too ie decisions such as moving all vs some applications etc . As in any onboarding to"See full answer

Santhosh K. - "As an engineering manager, motivation is key to the success of the team. Here are some ways to motivate the team: Set clear goals: Clearly defined goals help team members understand what they're working towards and give them a sense of purpose. Offer growth opportunities: Providing opportunities for professional development and advancement can increase motivation and job satisfaction. Provide recognition and rewards: Recognising and rewarding team members for their hard work and achieve"See full answer

Anonymous Puma - "Assuming for the US Segment by size of businessNumber of employees per business sizePrice per employee=Revenue Price per employee should decrease with a larger employee base. 30M businesses in the US Small Business 60% of businesses are small=18M Average number of employees=50 Price per employee=$5 Small Business Revenue=$2.7B Medium Business 30% of them are medium=9M Average number of employees=1000 Price per employee=$3 Medium Business Revenue=$8.1B Large Business 10% of th"See full answer

Dheeraj sai P. - "As a product manager in microsoft to support the customers I have to design a product. Let us take the E-Service as a name.In that we can see a form at first and after that a chat bot at the picture even there is a calling facility.Other queries done with the bot."See full answer