Skip to main content

Interview Questions

Review this list of 4,477 interview questions and answers verified by hiring managers and candidates.
  • 4 answers

    "with login_data as ( select * from useractivitylog where activity_type = 'LOGIN' ) ,cte as ( select userid, timestamp as currentlogin ,lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc) as previous_login, round((julianday(timestamp) - julianday(lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc))) * 24 * 60) as minutes_elapsed from login_data ) select * from cte where currentlogin  previouslogin;"

    Kedar W. - "with login_data as ( select * from useractivitylog where activity_type = 'LOGIN' ) ,cte as ( select userid, timestamp as currentlogin ,lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc) as previous_login, round((julianday(timestamp) - julianday(lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc))) * 24 * 60) as minutes_elapsed from login_data ) select * from cte where currentlogin  previouslogin;"See full answer

    Coding
    SQL
  • "I would take the following approach: Define what acquisition of a merchant means - It could be a few of these actions - 1. Merchant provides their email/phone number to shopify, 2. They create a store 3. they sign up for a subscription Second we need to establish the method we are using to acquire new merchants Assumption - it is paid advertising on IG and FB given that's one of the ways of acquiring audience on these platforms and is easy to track. Other approach could be social"

    Anhul C. - "I would take the following approach: Define what acquisition of a merchant means - It could be a few of these actions - 1. Merchant provides their email/phone number to shopify, 2. They create a store 3. they sign up for a subscription Second we need to establish the method we are using to acquire new merchants Assumption - it is paid advertising on IG and FB given that's one of the ways of acquiring audience on these platforms and is easy to track. Other approach could be social"See full answer

    Analytical
  • Google logoAsked at Google 
    Add answer
    Product Manager
    Product Strategy
  • "Understand what is the business objective behind the ask ? We should not be adopting trends just because everyone is adopting, it has to be tied to business objective Once objective is clear - we need to determine feasibility and cost\benefit assessment by deciding on pilot candidates - since its bank, do we want to integrate this with mobile banking only ? Once we decide on candidate - we will also need to decide on buy vs build decision ? If there are any fintech offerings (like Zell"

    Hmm T. - "Understand what is the business objective behind the ask ? We should not be adopting trends just because everyone is adopting, it has to be tied to business objective Once objective is clear - we need to determine feasibility and cost\benefit assessment by deciding on pilot candidates - since its bank, do we want to integrate this with mobile banking only ? Once we decide on candidate - we will also need to decide on buy vs build decision ? If there are any fintech offerings (like Zell"See full answer

    Analytical
    Behavioral
    +1 more
  • Google Cloud (GCP) logoAsked at Google Cloud (GCP) 
    3 answers

    " 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."

    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

    Product Manager
    Estimation
    +1 more
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • Peloton logoAsked at Peloton 
    Add answer
    System Design
    Technical
  • Spotify logoAsked at Spotify 
    1 answer
    Video answer for 'Critique the Spotify app.'

    "Problem & Users What is the primary problem the App is trying to solve? Who is the primary user for the App? What is the core value proposition and what business model does it employ to serve the value? What are the business goals the app is trying to achieve and how effective is their strategy Structure Is the purpose of the app clearly conveyed? How is the overall use of space? Is there enough negative space? How does the Information Architecture help users accomplish de"

    Ben G. - "Problem & Users What is the primary problem the App is trying to solve? Who is the primary user for the App? What is the core value proposition and what business model does it employ to serve the value? What are the business goals the app is trying to achieve and how effective is their strategy Structure Is the purpose of the app clearly conveyed? How is the overall use of space? Is there enough negative space? How does the Information Architecture help users accomplish de"See full answer

    Product Designer
    App Critique
    +1 more
  • "I have often experienced my manager believing in something while I don't. The situation largely arises when the manager is under pressure of taking decision and has not spent enough time on researching about the decision. While I on the other hand have always spent time learning about issues right since we feel this is going to be a challenge in the near future. In such scenarios, I would believe something else base on my research while the manager would have some other belief based on his exper"

    Vinit K. - "I have often experienced my manager believing in something while I don't. The situation largely arises when the manager is under pressure of taking decision and has not spent enough time on researching about the decision. While I on the other hand have always spent time learning about issues right since we feel this is going to be a challenge in the near future. In such scenarios, I would believe something else base on my research while the manager would have some other belief based on his exper"See full answer

    Behavioral
  • Amazon logoAsked at Amazon 
    Add answer
    Product Manager
    Behavioral
  • Google logoAsked at Google 
    1 answer

    "https://en.wikipedia.org/wiki/Operational_transformation"

    Sunny G. - "https://en.wikipedia.org/wiki/Operational_transformation"See full answer

    System Design
    Technical
  • Sierra AI logoAsked at Sierra AI 
    Add answer
    Product Manager
    Artificial Intelligence
  • Capital One logoAsked at Capital One 
    Add answer
    Machine Learning Engineer
    System Design
  • Oracle logoAsked at Oracle 
    Add answer
    Software Engineer
    Behavioral
  • 6 answers
    +3

    "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;"

    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

    Data Engineer
    Coding
    +3 more
  • Visa logoAsked at Visa 
    Add answer
    Software Engineer
    Data Structures & Algorithms
    +1 more
  • PayPal logoAsked at PayPal 
    1 answer

    "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"

    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

    Product Manager
    Behavioral
  • Meta logoAsked at Meta 
    1 answer

    "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"

    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

    Product Manager
    Product Design
  • +5

    "Clarifying questions: What are open homes and how does this model work? Open homes cater to provide free shelter for refugees; hosts list the property and partner NGOs based on the requirement book an appropriate property for the refugees. How long does a refugee stay at a property? Minimum 2 weeks Does the host provide meals? Up to the host, some do and some don't What does improve Open Homes mean? There is an imbalance in hosts - we need more hosts"

    P K. - "Clarifying questions: What are open homes and how does this model work? Open homes cater to provide free shelter for refugees; hosts list the property and partner NGOs based on the requirement book an appropriate property for the refugees. How long does a refugee stay at a property? Minimum 2 weeks Does the host provide meals? Up to the host, some do and some don't What does improve Open Homes mean? There is an imbalance in hosts - we need more hosts"See full answer

    Product Design
  • Meta logoAsked at Meta 
    1 answer

    "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"

    Michael B. - "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"See full answer

    Machine Learning Engineer
    Data Structures & Algorithms
    +1 more
  • Amazon logoAsked at Amazon 
    2 answers

    " Questions: Is there any specific user pain point we are trying to solve ? Is this for engagement or retention or revenue Is there any specific Geo you want me to focus ? Is there any specifc user segment you want to focus ? Structure: Company Mission: Easy access to vehicle no matter when and where you are. Product Mission: Quick and easy delivery of food delivered at your door step User Segments: Sellers : Restaurant, Catering, F"

    Swetha C. - " Questions: Is there any specific user pain point we are trying to solve ? Is this for engagement or retention or revenue Is there any specific Geo you want me to focus ? Is there any specifc user segment you want to focus ? Structure: Company Mission: Easy access to vehicle no matter when and where you are. Product Mission: Quick and easy delivery of food delivered at your door step User Segments: Sellers : Restaurant, Catering, F"See full answer

    Product Strategy
Showing 2241-2260 of 4477