Interview Questions

Arshad P. - "Schema is wrong - id from product is mapped to id from transactions, id from product should point to product_id in transcations table"See full answer

Sean L. - "df.loc[ isin()] is the crucial part of the solution."See full answer

Sean L. - " import pandas as pd def lowestearningemployees(employees: pd.DataFrame) -> pd.DataFrame: your code goes here df=employees.sort_values('salary').head(3) return df[['id','firstname','lastname','salary']] debug your code below employees = pd.DataFrame({ 'id': [1, 2, 3, 4, 5, 6], 'first_name': ['John', 'Ava', 'Cailin', 'Mike', 'Ian', 'John'], 'last_name': ['Smith', 'Muffinson', 'Ninson', 'Peterson', 'Peterson', 'Mills'], 'salary': [20000, 10000, 3000"See full answer

Aman M. - "dadda 2 variants right? Control, Treatment1 and Treatment 2, thats how we will design the experiment"See full answer

Vineet M. - "Each flip is independent. P(10 heads)=(1/2​)^10"See full answer

Idit G. - "To define the success metrics for Facebook Ads, I’ll outline: Who the users are What their goals and needs are How success is measured across their journey Who are the users: Advertisers: Individuals or businesses running ad campaigns to achieve business objectives. Potential Buyers: Users exposed to ads who may engage, click, or make purchases. User journey and Success metrics: Advertisers: Acquisition:Onboarding Completion Rate: % of advertisers completing"See full answer

Nayla D. - "Clarify Questions: Is this app in Facebook app? or we build a different app for this? - Yes, this is in FB app now. Will we have monetization in the first launch or launch it for free first? - Free first, but there is a potential monetization in the future. Context: we will launch Facebook Jobs in two weeks, indicating that this is a new product. I want to step back a bit, why this is important for Meta. Meta mission is to make it easier to build community and bring the world closer"See full answer

Nikitha G. - "Context / Goal: Have we seen this decrease in response time over a while (week/month) or short time (day/hours) - Over the last few months How is Employer Response time calculated? - Average time from an employee applying for a job to an employer responding - This isn’t accounting for the increase in listings / number of applicants but does it need to? Was there a change to how response time is calculated? - No Can job listings be duplicates? - Yes, but not likely i"See full answer

Malvika S. - "Top three most important variables Uber could use to estimate the ETA for passenger pickup, beyond the ETA on Google Maps can be: Driver related - sometimes driver cancel rides after they are assigned or agree to pickup, especially at odd hours. Sometimes, they can also cancel midway through their journeys. Other factor can be that they drive slower or faster than google maps ETA. Car related - The car may be old or not maintained well than other cars. It can be CNG, Diesel, petrol or elec"See full answer

Cj K. - "Clarifying Q Is the search traffic meaning # visits clicked through the 'search' button from the homepage(search CTR)? or does this include # pages viewed after the search result pages (search depth)? Hypothesis I believe introducing Gen AI as a default feature on the Google's search box will increase #search traffic. I assume the biggest user pain point within current google homepage is that deciding on a keyword for search. Unlike other alternative platforms such as"See full answer

Anonymous Ferret - "i do feel like the question itself is kind of confusing. Youtube does have a product called YouTube’s Analytics, which is a channel analytics tool for creator lol"See full answer

Nishtha - "How much does the Empire State Building weigh? I will estimate the weight of the Empire State Building using a structured approach. I’ll start with clarifying questions, define an equation, make reasonable assumptions, perform calculations, and address trade-offs and potential errors. Clarifying Questions To refine the scope, I considered: How many floors does the Empire State Building have? What is the area per floor? What materials are used (e.g., steel, concrete)"See full answer

Dessalew A. - "Strength: simplicity + interpretability Weakness: rigidity (can’t model complexity well)"See full answer

Megha V. - "Gradient Descent is an optimisation strategy used in several supervised learning models. It is the technique for finding the optimum solution of an objective function. Typically, for a linear regression use case, it is used to find the weights and bias that produce the lowest loss. It involves computing the partial derivative of the objective function with respect to the weight and bias vectors. To find the optima of the function, the derivative is equated to 0, and iteratively the weight and b"See full answer

Lucas G. - "Because testing many engagement metrics at once increases the risk of finding effects that aren't real (the 'multiple comparisons problem'), you must adjust your criteria for statistical significance. For social media data, the Benjamini-Hochberg procedure is often a practical choice as it controls the rate of false discoveries (FDR) while still allowing you to detect genuine changes; however, the ideal adjustment method will vary depending on your specific number of metrics (e.g., use Bonferron"See full answer

Lucas G. - "To speed up A/B tests results with limited sample sizes, we can apply advanced techniques like CUPED to reduce variance for faster statistical significance, interleaving to gather more comparative data per user (e.g., ranking), MAB to dynamically allocate traffic to winning variations for quicker optimization (e.g., campaigns), and Bayesian A/B testing which offers probabilistic conclusions that can be reached earlier. Each method, when appropriately applied, allows you to gain m"See full answer