Interview Questions

Dave F. - "After researching Glassdoor, I provided an in-depth answer that incorporated my interest in DB technologies, alignment with career objectives, and ability to make an impact from professional experience. "See full answer

Prachi N. - "When I joined my second Firm after my MBA, I was given a complex pilot project to manage end-to-end, despite having just about a year of experience. One client expressed concern about my limited experience and raised it to senior stakeholders. While I understood her concern, I decided to treat it as motivation rather than discouragement. I put extra effort into understanding the complex SAP designs, managed priorities carefully, and built strong relationships with stakeholders to gain their conf"See full answer

Tj C. - "SELECT (zip, rides, deliveries) FROM dataset GROUP BY zip;"See full answer

Rahul J. - "Clarifying questions Target geography: USA, all urban areas Form factor: Mobile app, supported on iOS and Android Items to be borrowed: simple appliances like toaster, FMCG products, etc. Target market USA has a population of millions of people People generally need to frequently borrow household items from neighbours in case of emergency (or even otherwise) Internal company assessment Meta's mission is to create communities that help each other. This problem ties in well with t"See full answer

Scott S. - "my team is distributed across different regions, different time zones. Managing distributed teams presents unique challenges and opportunities,. I have developed a structured approach to ensure effective collaboration, communication, and productivity. I follow various strategies, as follows: I schedule regular meetings, including daily stand-ups, weekly syncs, and monthly retrospectives. This ensures that everyone stays aligned and up-to-date on team progress and priorities. I leverage commu"See full answer

Brandon C. - "We can start by considering the key components: waiters, tables and customers. We'll need a database to store information about waiters, tables and customers, each waiter can have a unique ID and we can track the. number of tables they are servicng. Tables can have attributes like table number, capacity, and current status. Customers can be tracked by their arrival time and party size. we can calculat ethe expected waiting time bu considering the average time a table is occupied and the number o"See full answer

Chetak C. - "Probability that one of the coupons is used = 1 - Probability that no coupon is used = 1 - nC0 p^0 * (1-p)^n = 1 -(1-p)^n"See full answer

Rahul J. - "This depends on the following two variables: What's the percentage of people dropping off at each step What's the perceived impact to business and users of the failure of each step. In general, I'd start from the very end, and then go back in the process as it's more important that we satisfy customers who have paid i.e. they should get a booking confirmation vs customers that are entering details and then payment info."See full answer

E L. - "WITH CTE AS ( SELECT *, ROWNUMBER()OVER(PARTITION BY utxoid ORDER BY transactionid) AS trxrk FROM transactions JOIN transaction_inputs USING (transaction_id) JOIN utxo USING (utxo_id) ) SELECT transaction_id AS InvalidTransactionId FROM CTE WHERE sender!=address OR trx_rk > 1 `"See full answer

Exponent - "This is a Design a Product question. For this, we'll want to follow the formula for success: Ask clarifying questions Identify user types, behaviors, and pain points State the goal and use cases List current solutions Improvements / net new solutions Evaluate and select solutions Measure Success Summarize Ask clarifying questions The PM interview isn't about your ability to come up with the best solution right away — it's about bein"See full answer

Alessandra L. - "My answer followed the framework: Users -> Goals -> Main Tasks -> Requirements -> Design -> Implementation -> Launch"See full answer

Sri H. - "First of all, are some of these hypothetical questions? Anyway, I'd start by asking what's a "Video feature" ;-)"See full answer

Lucas G. - "The central limit theorem tells us that as we repeat the sampling process of an statistic (n > 30), the sampling distribution of that statistic approximates the normal distribution regardless of the original population's distribution. This theorem is useful because it allows us to apply inference with tools that assume normality like t-test, ANOVA, calculate p-values hypothesis testing or regression analysis, calculate confidence intervals, etc."See full answer