Skip to main content

Interview Questions

Review this list of 4,477 interview questions and answers verified by hiring managers and candidates.
  • Product Manager
    Product Design
  • Google logoAsked at Google 
    2 answers

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

    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

    Product Manager
    Analytical
    +1 more
  • Flipkart logoAsked at Flipkart 
    1 answer

    "By looking at QPS prolly! I mean that's the success metric for it after all, right? Maybe not, love to know your thoughts down below."

    Palak A. - "By looking at QPS prolly! I mean that's the success metric for it after all, right? Maybe not, love to know your thoughts down below."See full answer

    Product Manager
    Analytical
  • Google logoAsked at Google 
    2 answers

    "I explained the story of trying to help the engineer to improve the performance and after it is failed, the steps I have taken to move the eng to PIP."

    Nid P. - "I explained the story of trying to help the engineer to improve the performance and after it is failed, the steps I have taken to move the eng to PIP."See full answer

    Engineering Manager
    Behavioral
    +2 more
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • Apple logoAsked at Apple 
    Add answer
    Product Marketing Manager
    Product Strategy
  • Salesforce logoAsked at Salesforce 
    Add answer
    Solutions Architect
    Technical
  • Amazon logoAsked at Amazon 
    1 answer

    "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"

    Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

    Solutions Architect
    Technical
  • Salesforce logoAsked at Salesforce 
    Add answer
    Solutions Architect
    Technical
  • 15 answers
    +12

    "Agile methodologies are chosen by organizations to enhance delivery speed, integrate shorter feedback loops, and provide incremental value to customers. However, the suitability of Agile depends on several factors, including the nature of the work, team structure, and organizational objectives. From my experience, for teams focused on new feature development, Scrum tends to be more effective. Scrum’s structured cadence—emphasizing backlog grooming, sprint planning, and regular retrospective"

    Manik K. - "Agile methodologies are chosen by organizations to enhance delivery speed, integrate shorter feedback loops, and provide incremental value to customers. However, the suitability of Agile depends on several factors, including the nature of the work, team structure, and organizational objectives. From my experience, for teams focused on new feature development, Scrum tends to be more effective. Scrum’s structured cadence—emphasizing backlog grooming, sprint planning, and regular retrospective"See full answer

    Program Sense
    Project Management
    +1 more
  • Add answer
    Data Analyst
    Coding
    +1 more
  • Add answer
    Coding
  • Add answer
    Coding
  • 3 answers

    " import pandas as pd import numpy as np def findimprovingstudents(transcript: pd.DataFrame) -> pd.DataFrame: df = transcript.pivot(values='yearlygpa', columns='year', index='studentid') strictlyincreasingrows = np.all(np.diff(df, axis=1) > 0, axis=1) df['average_gpa'] = df.mean(axis=1).round(2) dfreset = df.resetindex() return dfreset[strictlyincreasing_rows] debug your code below transcript = pd.DataFrame({ 'student_id': [1, 2, 3, 4, 1, 2, 3, 4,"

    Lucas G. - " import pandas as pd import numpy as np def findimprovingstudents(transcript: pd.DataFrame) -> pd.DataFrame: df = transcript.pivot(values='yearlygpa', columns='year', index='studentid') strictlyincreasingrows = np.all(np.diff(df, axis=1) > 0, axis=1) df['average_gpa'] = df.mean(axis=1).round(2) dfreset = df.resetindex() return dfreset[strictlyincreasing_rows] debug your code below transcript = pd.DataFrame({ 'student_id': [1, 2, 3, 4, 1, 2, 3, 4,"See full answer

    Coding
    Data Analysis
  • 2 answers

    " import pandas as pd from datetime import datetime def findfastestlike(log: pd.DataFrame) -> pd.DataFrame: log=log.sortvalues(['userid','timestamp']) #get the prev event, time by user log['prevevent'] = log.groupby('userid')['event'].shift(1) log['prevtimestamp'] = log.groupby('userid')['timestamp'].shift(1) True only on rows where the previous event was a login and the current event is a like log['loginlike'] = (log['prevevent'] == 'log"

    Sean L. - " import pandas as pd from datetime import datetime def findfastestlike(log: pd.DataFrame) -> pd.DataFrame: log=log.sortvalues(['userid','timestamp']) #get the prev event, time by user log['prevevent'] = log.groupby('userid')['event'].shift(1) log['prevtimestamp'] = log.groupby('userid')['timestamp'].shift(1) True only on rows where the previous event was a login and the current event is a like log['loginlike'] = (log['prevevent'] == 'log"See full answer

    Coding
    Data Analysis
  • 4 answers

    " import pandas as pd import numpy as np def findoverstretchedemployees(departments: pd.DataFrame, employees: pd.DataFrame, projects: pd.DataFrame, employees_projects: pd.DataFrame) -> pd.DataFrame: Make a copy to avoid modifying original dataframe projects = projects.copy() Convert dates to datetime projects["startdate"] = pd.todatetime(projects["start_date""

    Diyorbek T. - " import pandas as pd import numpy as np def findoverstretchedemployees(departments: pd.DataFrame, employees: pd.DataFrame, projects: pd.DataFrame, employees_projects: pd.DataFrame) -> pd.DataFrame: Make a copy to avoid modifying original dataframe projects = projects.copy() Convert dates to datetime projects["startdate"] = pd.todatetime(projects["start_date""See full answer

    Data Analyst
    Coding
    +1 more
  • 4 answers
    +1

    "The question is incomplete --- the code only passes if you return the data frame sorted by BOTH department name AND rank. While in the problem description, it mentions to only rank by department name: "The results should be ordered by department name." Not a big difference I know, but students shouldn't need to look into the solution to get the necessary knowledge to answer the question."

    Chao peter Y. - "The question is incomplete --- the code only passes if you return the data frame sorted by BOTH department name AND rank. While in the problem description, it mentions to only rank by department name: "The results should be ordered by department name." Not a big difference I know, but students shouldn't need to look into the solution to get the necessary knowledge to answer the question."See full answer

    Coding
    Data Analysis
  • 9 answers
    +6

    "Hi, my solution gives the exact numerical values as the proposed solution, but it doesn't pass the tests. Am I missing something, or is this a bug? def findrevenueby_city(transactions: pd.DataFrame, users: pd.DataFrame, exchange_rate: pd.DataFrame) -> pd.DataFrame: gets user city for each user id userids = users[['id', 'usercity']] and merge on transactions transactions = transactions.merge(user_ids, how='left"

    Gabriel P. - "Hi, my solution gives the exact numerical values as the proposed solution, but it doesn't pass the tests. Am I missing something, or is this a bug? def findrevenueby_city(transactions: pd.DataFrame, users: pd.DataFrame, exchange_rate: pd.DataFrame) -> pd.DataFrame: gets user city for each user id userids = users[['id', 'usercity']] and merge on transactions transactions = transactions.merge(user_ids, how='left"See full answer

    Data Analyst
    Coding
    +1 more
Showing 1181-1200 of 4477