Interview Questions

Calyan - "Launch p2p payments on a chat application Clarify - - - - - - - - - - - any specific chat app in mind? [no] Is there a 3rd party vendor tech we can incorporate [no, build grounds-up] Markets [US] Framing - - - - - - - - - - - Messaging apps mission: be the go-to destination for 1:1, n:n info sharing and comms. Use network effects to gain market share Biz/product goals: Growth, gain more market share Engagement: time spent, instances of interaction and sharing Revenue: ads,"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

Brody C. - "Clarifying Questions: When you say Language Learning app, you're referring to a user wanting to learn a new language through a Meta property - not NLP tech correct? -- Yes Is this a stand-alone app, or part of Facebook or another Meta app? -- You choose Are there any restrictions like budget, or time for this learning app? -- Nope. Give me a moment to think about how I want to structure this answer: Mission // Goal of Language Learning App Competition Audience Segments Pain Points "See full answer

Claire W. - "Add more social features"See full answer

Abdurhman M. - "For larger projects, companies will often hire project managers to plan, document, organize and oversee a project's life cycle, helping ensure projects are completed on time and on budget. However, due to limited resources such as limited budgets or personnel constraints, many teams function without a project manager."See full answer

Tony A. - "Get alignment with interviewer on how Gen AI works, then talk about the automotive space with value chain analysis on high level: 1. Design the automobile 2. Source components 3 assemble 4. Market 5. sell to customer 6 vehicle operation and maintenance. Competition: Hyper competitive industry with ~10 big manufacturers in the world. Trends: EV, Self-driving Potential Goals for the Automotive company Gen AI use case: Gain market share by offering Gen AI driven value to its customers Bi"See full answer

Jerry D. - "My roles included: ➢ B2B Sales of sanitary ware products to clients ➢ Sourcing of New Businesses and Managing Existing Clients ➢ Responsible for managing sales unit ➢ Developing new sales lead to meet set target. ➢ Project Management Skills: Online Sales Management · Sales Management · Customer Engagement · Sales Operations · Direct Sales · B2B Marketing"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

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

Exponent - "This is an Improve a Product question. Let's first go over the Improve a Product formula: Ask clarifying questions Identify users, behaviors, and pain points State product goal Brainstorm small improvements Brainstorm bolder improvements Measure success Summarize Now, let's begin! Ask clarifying questions Before we begin listing off recommendations, it's important you ask questions to ensure you and the interviewer are on the same page"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

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

Ramagiri P. - "Medallion architecture is a layered data architecture used in lakehouse systems. Data flows through Bronze, Silver, and Gold layers where each layer improves data quality. Bronze stores raw data, Silver contains cleaned and validated datasets, and Gold provides aggregated business-ready data for analytics and reporting bronzedf = spark.read.json("/landing/apidata") bronze_df.write.format("delta").save("/bronze/users")"See full answer