Interview Questions

Scott S. - "Yes, I have had to make the difficult decision to terminate an employee for low performance. As a manager, my primary goal is to build a high-performing and cohesive team. While I believe in providing ample support and opportunities for growth, there are instances when an employee’s performance does not meet the required standards despite multiple interventions. There was a data engineer on my team, let’s call him Mike, whose performance had been consistently below expectations for several mon"See full answer

Dnyaneshwar M. - "I am all-rounder"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

Anzhe M. - "There are 2 questions popping into my mind: Should the 2nd job have to kick off at 12:30AM? Are there others depending on the 2nd job? If both answers are no, we may simply postpone the second job to allow sufficient time for the first one to complete. If they are yeses, we could let the 2nd job retry to a certain amount of times. Make sure that even reaching the maximum of retries won't delay or fail the following jobs."See full answer

Karthik M. - "Structure Why should we build this? + market, company, product, trends Users Painpoints Solutions Summary Clarify company - 0 to 1 Why should build this Market factors Size and opportunity (tam) sizeable market - billions of dollars in TAM Competitors (1) governments (2) parkmobile (3) vendors for each parking lot (parking structures / lots, man people) Strengths Parkmobile - available anywh"See full answer

Veronica S. - " CQ: 1. Understanding of Google search and the way ads are being displayed today. What kind of subscription model are we thinking of: same as youtube I talked about Google search as a flagship product of google. % of revenue generated from ads. Other search engines and there % share in the market. Other players such as Facebook whose 99% revenue is from ads. Talked about Google Mission and alignment of the ads with Google mission Pro Con list of subscription versus ads User exp. 2."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

slouchingtowardssv - "Clarify the problem / make assumptions: What are we defining as misleading? For this problem, any video that contains information countering accepted scientific/research-driven results What is meant by fix? Does that entail removing said videos? For this problem, I want to see if we can minimize the amount of videos pulled from YouTube Intro to the product: YouTube is a video-sharing platform that was acquired by Google in 2006 YouTube's original mission statement:"See full answer

Steven S. - "too many questions for clarification on this to start"See full answer

Priti S. - "Designing an Email Application for the Blind Creating an accessible email application for blind users involves leveraging screen reader compatibility, tactile feedback, and voice recognition technologies. Here's a comprehensive approach: Core Design Principles: Accessibility-First Design: Ensure compatibility with screen readers like NVDA, JAWS, or VoiceOver. Follow accessibility guidelines (WCAG) for structure, navigation, and content. Voice Interaction:Use voice comman"See full answer

Alex M. - "A red-black tree is a self-balancing binary search tree. The motivation for this is that the benefits of O(logN) search, insertion, and deletion that a binary tree provides us will disappear if we let the tree get too "imbalanced" (e.g. there are too many nodes on one side of the tree or some branches have a depth that is way out of proportion to the average branch depth). This imbalance will occur if we don't adjust the tree after inserting or deleting nodes, hence our need for self-balancing c"See full answer

Cameron P. - "Clarifying Questions: US or globally? globally Consumer or business use? consumer Assumptions: Assuming we are interested in frequent users, let's say someone who uses Google Drive at least 5 times a year. Discluding anyone who has used Google Drive less than 4 times per year. Assuming Google Drive is a place to store, share, and collaborate on files and folders from your mobile device, tablet, or computer. Recap: We would like to estimate the number of users of Google Drive"See full answer

Arshad P. - "Schema is wrong - id from product is mapped to id from transactions, id from product should point to product_id in transcations table"See full answer

Aditi M. - "Amazon Go is cashierless shopping stores. The mission is to improve the shopping experience and reduce the time to get commodities without waiting in line for checkout. The goal of Amazon Go would be adoption and expansion. I will refine the goal as we go further. Competition All Convenience stores like Target, Safeway, Walgreens or any local corner stores too User Segments for Amazon Go Store managers Shoppers High intent shoppers- 2-3 times a week Medium intent and - On"See full answer