Interview Questions

Chung jin C. - "In my role as VP of operational model transformation was leading the definition of current and to be state of operations for a business representing >50% of the revenue & profits of the company. In a monthly feedback session, my manager shared how he noticed I had not delegated tasks and that I should work with 2 members who had been seconded to the team. We were working on a tight timeline and we wanted to get the targets completed earlier so that we can provide some buffer for further alignm"See full answer

Preyas J. - "Let's apply Porter's Five Forces model to Amazon's business. All of these are my personal opinions. Industry Rivalry - There's a continuous rivalry in the ecommerce space with each rival trying to focus on specific aspect's of Amazon's business. Walmart (price, convenience), Google Shopping (relevancy, search), Shopify (brand trust, direct buying), eBay (antiques, used, shipping), Facebook Marketplace (buy from 3P sellers). Threat of new entrants - Amazon continuously faces threa"See full answer

Lakshmi tejaswi S. - "First I would like to define what a negative experience might construe Unable to book the reservation Customers unable to cancel reservations The customers unable to find restaurants in the location they are in customers unable to interact or leave reviews. I will try to solve for the first one. In this scenario, I would like to understand the frequency of the issue’s occurrence. I will try to understand if there was a new feature rolled out that may have impacted it such as chang"See full answer

Shin K. - "First of all, there are different industries with different business in security measures which influence trends in the security industry as information they store and infrastructure they have are not the same. In this exercise, I'll take a look at the security industry in general and talk about the biggest trends from the perspectives of "lines of defense" for software in particular in: identify, data (on client and server side) and infrastructure. There are several topics associated with each"See full answer

Rafia M. - "SQL is structured query language."See full answer

Aniket B. - "Firstly lets note down the ways of monetization - Promotional Ads Paid Filters and AR effects Influencer promotional fee Instagram Additional Tools for Creators - subscription basis (analytics and management) > many influencers also run their own promotional campaigns to gain more and more followers on their handles - Instagram can use this opportunity (e-commerce sites ranking algorithm of different items/sellers) > promotional ads can affect slightly on user engagement but accord"See full answer

Aneesha K. - "Test case is wrong. It expects to sort in asc order of month_year. -- Write your query here SELECT strftime('%Y-%m', createdat) AS monthyear, COUNT(DISTINCT userid) AS numcustomers, COUNT(t.id) AS num_orders, SUM(price * quantity) AS order_amt FROM transactions t INNER JOIN products p ON t.product_id = p.id GROUP BY month_year ORDER BY month_year ; "See full answer

Rasika D. - "Message queue is like a buffer. Its has 3 parts: Producer -> which creates a message and sends it to the queue. Queue -> which acta like a buffer pipe and stores the message. Subscriber -> which processes and releases messages one by one in FIFO manner."See full answer

Pattern P. - "In Drive > Slack > In Shorts Shortlisted for further discussion - In Drive (Ride Hailing App) Briefly: > \>> JTBD: > Search, Book, Cancel, Rate and Complain for Rides > > \>> User Segments: > Based on frequency of usage > User Engagement Metrics: > Use Cases or JTBD used interchaneably Frequency of all the JTBD Performed in a Unit Time (Breadth) Ratio of Searches compared to Book Ride in a Unit Time (Monetization Use Case) Ratio of Cancellations compared to Book Ride in a"See full answer

Exponent - "This is a Strategy Question, which asks you to justify high-level business decisions and strategy. This could be confused with an expansion problem, but it's only asking for the risks. You should be thorough with the risks and identify as many as possible. Let's go over one possible solution: > Expanding to China could be a huge opportunity for Netflix, but it's definitely risky. I'd love to go over a few risks that we should consider. To me, the biggest risks are:Censorship > Chinese compet"See full answer

Atharva P. - "Problem: Facebook Jobs has seen a 20% increase in job listings, but employer response time to applicants has decreased by 20%. Goal: Investigate and address the decrease in employer response time. Assumptions and Clarifying Questions: Scope: Is this issue internal to Facebook or affecting external users? Timeline: Analyzing data from the past 6 months is assumed to be sufficient. Response Time Definition: Clarify the precise definition of "response time" (e.g."See full answer

Abhishek V. - "Currently, there's no option to write Python code for the solution to this problem. Is it possible to add it?"See full answer