Interview Questions

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

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

Exponent - "This is one of the core behavioral questions that you should expect to cover in any interview. In particular, it asks you to justify why you want to work at a specific company that you've applied for. There's no right answer for this, however we do recommend you list at least three distinct reasons. Here's an example of what you might say: > Great question! There's so many reasons, but I'll keep it to my top three.I love how intricate and delicate the payments space is and I want to work in this"See full answer

Md kamrul H. - "public class HashMap { public class Element { T key; V value; Element(T k, V v) { this.key = k; this.value = v; } } private static final int DEFAULT_CAPACITY = 16; private static final float LOAD_FACTOR = 0.75f; private LinkedList[] table = new LinkedList[DEFAULT_CAPACITY]; private int size = 0; private int threshold = (int) (DEFAULTCAPACITY * LOADFACTOR); public void put(T k"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

Priti S. - "T launch the Copilot Plus feature for Surface, follow these steps: Define Value Proposition: Highlight AI-driven enhancements for productivity, creativity, and collaboration tailored to Surface users. Target Audience: Focus on professionals, creators, and students with specific use cases. Product Development: Ensure seamless integration with Surface hardware (touchscreen, Pen) and leverage Azure AI for unique functionalities. Marketing Strategy: Build excitement with teasers, influencer partner"See full answer

Anonymous Dove - "Improving the parking experience as a Google Maps PM is a challenging and interesting task that requires understanding the user needs, pain points, and goals. Here are some of my ideas for how to improve the parking experience on Google Maps: Provide real-time parking availability and prices: One of the main challenges for drivers is finding a parking spot that is available, convenient, and affordable. Google Maps could use data from various sources, such as sensors, cameras, or crowdsourc"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

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

Katherine B. - "We want to use rigorous framework for evaluating shipping a new feature — ideally an A/B test. If an A/B test is not available, we first evaluate quantitative data; we look at feature adoption metrics, time-to-use, retention and frequency of visitation. What does the business impact of the feature on conversion rates, revenue per users and LTV, and secondarily evaluate any error rates that could be occurring after the launch of the new feature. It’s important for this analysis to perform segmen"See full answer

M N. - "Potential ad creators: Brands Drivers Travel services. Goal: To create a revenue stream. Acquire new users? To potentially develop new products? For now, lets focus on generating revenue as the goal. Potential ad products: Ads from brands you can watch while you are riding. Most riders dont look at the app while riding but we can provide them incentives like 5% off next ride if they watch ads the whole ride and pay it via ad revenue. Drivers can pay Lyft to be matched more w"See full answer