Interview Questions

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

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

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

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

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

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

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

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

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

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