Interview Questions

Dee - "Clarify the question: Is this team for a specific part of JPMC or all of JPMC? Did we already have a DevOps team and we want to introduce the element of security? Steps to build a solution: 1: Define the company and team goals 2: Define the landscape What is the toolchain we want to use? What should the CI/CD lifecycle look like? 3: Define guiding principles for internal builds and third-party software/services which could include: Deployment frequency Traceability/observa"See full answer

Apurv K. - "!! FEEDBACK WELCOME !! Clarify question By art we mean visual art, e.g. paintings? - Yes Is this a solution to create art on Instagram or to showcase existing art on Instagram? - Create art Why build this, Engagement or Acquisition? - Engagement Reframe: We want to increase Instagram engagement through creation and sharing of art with followers. Talking about the space The Internet has over time continuously reduced barriers to creative expression. From blogging to Twitter"See full answer

Kirubel D. - "Clarifying Questions (Noun, verb, and adjective) Pixel The Pixel Phone or are we talking about ore on the software? Hardware or SoftwareINT: This can be applied to both areas Best Compared to other related phones on the market? And do we have a specific time frame in mind?INT: we don’t really have a specific time frame maybe within the next couple of years. Best means comparing to other phones out there. Market Best when it comes to a particular feature or overall the user experience within"See full answer

Sumeet R. - "Google mission is to organize worlds information and make it universally accessible and useful. Keeping that in mind will focus on what should be the solve for emerging market. Clarification: Any specific country Google is thinking about ? Answer: lets say Ghana it has come often as one of the fast emerging markets and untapped Clarification: Goal is monetization or growth Answer: We are entering the market so growth Based on the clarification above I will think about user segments, p"See full answer

Kurt K. - "Why skip defining the data model? Or did I just miss it?"See full answer

Coach - "Great question Evan, could you please help me with some context. Do you want me to consider Gsuite & Gmail on consumer or limit it to one or the other segment? Limit to B2C on GMAIL Promotions/ Notifications do you want me to include them? Exclude Would you want to consider only Gmail ecosystem or Gmail to All types of users? Any email recipient I would like to start with US as a geo and extrapolate would you be good with that? That's ok. That helps, than"See full answer

Kai W. - "A high level framework Clarifications: Reactions already exist in Instagram? Any specific region or user group we try to target for the launch? ... Product description: IG is ... Reactions are Emoji alike icons users can use to reply to posts/photos/comments FB's mission: Help people stay connected and build communities IG's mission/goal: Allow users to capture world's moments and share with friends Reactions Goal: To provide users an easier way to react to the content and to bet"See full answer

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

Dewansh Z. - "It's fair to assume a tech lead is an experienced person, especially in bigger organizations like Google. How we shape our thought process is part of our past experiences of default nature. I will first give it some time before I react/respond. I will try to understand the pattern where the tech lead is being devil's advocate. Eg. If he is being negative about PRD everytime, that means he had past experiences where the PRD was incomplete or scope was change; if is negative about testing scena"See full answer

Shikha S. - "Binary serach on E range"See full answer

Bryan K. - "Did a quick 30 min writeup on this and I'm submitting before I review/edit. Success metrics for Spotify Podcasts Clarify Focus is on Spotify Podcasts, which are audio content posted by Spotify Content creators Spotify Podcasts exists across all devices Spotify as a company is at a mature state and is looking to enhance retention and revenue (monetization) Spotify makes money through ads, Spotify Podcasts too - Assuming that Spotify Podcasts has some sort of ad product where adv"See full answer

Raul K. - "No of Cars in 1 year = [ Total Road Length] / [Distance Covered by 1 Self Drive Car in One Year] Clarifying Question - How does Mapping work? I assume the car has a bunch of cameras and the car needs to go via a road each once to do the mapping for Google Street view. Is that correct? Assumption Google Street view required cars to go via road once and then use camera for mapping Assumption for average speed of the car - This can vary if the car is on the highway Assumption of Area of"See full answer

Praveen - "First, I would like to discuss and align what is meaningful social interaction. Given facebook's mission to empower users to build communities and get people closer, it is important that users have "meaningful social interaction" The goal of defining this metric is to use this as a north star or success metric around any efforts to increase engagement. It can also help with ads targeting/monetization by showing ads only during deeper interactions and hence might get better yield. Given faceb"See full answer

Brandy L. - "The North Star Metric for Google Photos should be: Monthly Active Users (MAUs) who successfully store, organize, or retrieve photos/videos. Why? This metric reflects Google Photos’ core value: helping users store, manage, and access their memories seamlessly. It ties user engagement with the platform's primary offerings: reliable storage, easy search, and organization. Supporting Metrics: User Engagement: Monthly Active User (MAU) ratio: Growth and retention trends. "See full answer

Sachin R. - "If 0's aren't a concern, couldn't we just multiply all numbers. and then divide product by each number in the list ? if there's more than one zero, then we just return an array of 0s if there's one zero, then we just replace 0 with product and rest 0s. what am i missing?"See full answer

Aswath B. - "basic drew the diagram"See full answer

P K. - "Redefining the question as: How will you solve the problem of misinformation on FB? Clarifying questions: Are we talking about building a product? (Up to you) What exactly is misinformation? (Fake news, inaccurate facts being shared on social media) Goal: Reduce the amount of misinformation spread on the platform and improve user trust. Key users associated with misinformation: News Accounts (eg CNN) - They may get involved in some controversy about a fake photoshopped artic"See full answer