Interview Questions

Charles E. - "I will continue to try to be more thorough about the analysis to match my expectations, experience has taught me to do something calmly and with high accuracy, therefore even though work uses deadlines, I must stay focused and calm to do it so that accuracy is not lost while working"See full answer

Debajyoti B. - "This is the first time im attempting a product design question, kindly forgive all the rookie mistakes i might have done & point them out if anyone reviews this. do let me know my areas of improvement, as a PM enthusiast, I'll always appreciate feedback. As far as i am aware, Instagram posts allows a user to post their own content, be it a photo, video snippets(rest of which can be viewed by clicking on the watch full video icon), share content of other people the user was associated with, for"See full answer

Amadea N. - "When designing an app for buying and selling antiques, there are the following objectives: For app users to successfully sell their antiques For app users to successfully buy their preferred antiques For the app to generate revenue through the app Given that the only way to sustainably ensure the app's existence is the guarantee the company remains in business, I'll select objective 3 as the main mission with the other two as leading indicators. In order to get to objective 3, th"See full answer

Exponent - "You should identify this type of interview question as an Expansion problem, since we're expanding to a new market. This is similar to a growth problem, with a few additional components. This is the formula you should use when tackling these types of interview questions: Ask clarifying questions Perform user analysis Market risk analysis State goals Perform channel analysis Prioritize growth channels Strategy Summarize Without further"See full answer

Rishabh S. - "Clarifying Questions: How do you define 45% drop in ride orders? Does it include completed as well as cancelled rides? Is it a sudden drop or a gradual decline? For all types of services/rides or anything specific? At any particular time of the day/week/month, have we observed this drop? Is it happening across all locations or in a particular region? For a particular platform? iOS/Android Most likely reasons (that we can cross-off asap): Unrest in a particular geograph"See full answer

P D. - "User: Self Driving Ride Sharing Car Companies (consdering waymo uasecase for google) Needs Identify the rider and allow only authorized rider to enter Emergency use case (allow maintenance team to enter in case of emergency) Avoid accidents with nearby vehicles Avoid blindspots with kids / pets nearby Solutions Biometrics / qr code scanning to identify the rider / maintenance team Alerting the emergency team in case of accident / fire etc. Sensors / camera in the car Remote Locking"See full answer

Danyal R. - "Couple of methods: User Research: Talk to customers, find/initiate focus groups Competitive Research: Social listening - look at industry trends, study competitive landscape Identify trends - people, products, technologies used Look at existing product data Review teams backlog (if you're new) Tie everything back to the mission of the company and value system of the company"See full answer

Exponent - "You should be able to identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! Ask cl"See full answer

Nikunj V. - "OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two types of data processing systems, each designed for specific purposes in the context of database and data warehouse environments. OLTP (Online Transaction Processing):Purpose: OLTP systems are designed to manage and handle high volumes of transactions, such as inserting, updating, and deleting data. These systems are typically used in day-to-day business operations. Characteristics: Handles small, si"See full answer

Harshi B. - "SELECT DISTINCT title, ROUND(AVG(rating) over (partition by title),1) avg_rating, ROUND(AVG(rating) over (partition by genre),1) genre_rating FROM rating r JOIN movie m ON r.movieid=m.movieid ORDER by 1"See full answer

Manas M. - "Since Experimentation is a Broad Term I would like to ask a couple of Clarifying questions What kind of Experimentation User Behavior with newly introduced Beta features AI/Image learning Based Experimentation to test out trial features Something else API based experimentation for user/Third-party experiments,with APIs for new features exposed(this has a lot of potential where devs of apps etc can integrate new experimentation features in their apps with minima"See full answer

Zain R. - "I've worked on projects not quite like this, but very similar, in the past - I'll borrow from that to answer this: The Broader Context this problem doesn't specify the type of data we're working with, or how it's being ingested to align with my personal background, I'll assume a picture that lends this problem well to being a computer vision (abbreviated "CV") related question: let's say we have a conveyor belt in a waste facility, which sequentially carries a stream of waste w"See full answer

Jaime A. - "I would avoid converting order_date WITH monthly_totals AS ( SELECT department_id, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-11-01' THEN orderamount ELSE 0 END) AS novtotal, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-12-01' THEN orderamount ELSE 0 END) AS dectotal FROM orders WHERE order_date BETWEEN '2022-11-01' AND '2022-12-31' GROUP BY department_id ), mom_increases AS ( SELECT "See full answer