Interview Questions

Salome L. - "SELECT AVG(julianday(dateend) - julianday(datestart)) AS avgcampaignduration FROM campaign; `"See full answer

Jagan M. - "This system design question is very small compared to other questions like design instagram, twitter, google drive etc... Since the design involves less components the level of detail we have to go in them were deep. I had to explain how to deal with all the NFR for the distributed cache system. Whether it is a push model or a pull model. Hade to do BOE calculations for the database too."See full answer

Rick E. - " DP Solution Time: O(W * C) Space: O(W * C) from typing import List def knapsack(weight: List[int], values: List[int], cap: int) -> int: dp = [[0] * (cap + 1) for _ in range( len(values) + 1 )] for i in range(1, len(weight)+1): for c in range(1, cap + 1): curr_weight = weight[i - 1] curr_value = values[i - 1] include = 0 exclude = dpi-1 if c - curr_weight >= 0: include = curr_valu"See full answer

Anonymous Stork - "You are working on a SaaS product that currently uses Basic Authentication (username/password) for API and application access. The security and compliance teams have mandated moving to a more secure, modern authentication mechanism — OIDC (OpenID Connect). Design the authentication system migration from Basic Authentication to OIDC. Discuss the architecture changes, the migration approach, and the rollout strategy. What are the technical challenges, impacts on customers, backward compatibility"See full answer

Exponent - "This may seem tricky at first, but this is actually an Expansion problem, since we're expanding to a new market. The only difference is this is specifically for small businesses within that market. 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 Witho"See full answer

Gaurav K. - "I think sliding window will work here and it is the most optimized approach to solve this question."See full answer

Pablo S. - "1) Product, the value and the users this business has Product: Yelp is a platform that connects local businesses with people looking for those services. Value: Yelpers can connect with them / book appointments or make reservations with a good amount and quality of reviews per business. For businesses, it is a way to get visibility and find new demand with an easy setup. Users: Local businesses (offering): successful when they are booked. Searchers / demand: successful when"See full answer

Aimable - "Clarifying question: Is there a goal that we have in mind? Fb mission: empower people to create community and bring the world closer together IG shops as I understand are the marketplace on IG, where users can view items listed for sale by creators/businesses and also search for specific items or categories. Users can actually buy through shops instead of getting navigated to the original business website. IG shop goals: Businesses continue to face the challenges of selling onli"See full answer

Poha - "Design the cache, set policy like LRU or other custom policies."See full answer

Catherine T. - "We want sales to grow, in order to have a growth in revenue. And customer usage as well as it allows to see if our product lead more engagement from our users. So to be able to see this overall evolution I would make a line chart for both : Sales : with month on x-axis and sales revenue on y-axis Customer Usage : with month on x-axis and a KPI allowing to measure customer usage (nblogins or nbsessions or nbgamesplayed, ... depending on the industry) on y-axis Moreover, after knowing th"See full answer

Sandeep B. - "This is my first attempt. Requesting feedback - Design a bookshelf for the users. I would like to create a framework to solve this problem and follow it. It will have the below sections - Goals User Persona Use Cases Pain Points Features Prioritization Metrics Few clarifying questions - What is the objective of doing this? (User engagement, matching a product that a competition has just launched) What type of industry we are in? (Are we a furniture design company, ar"See full answer

Unicorn 2. - "Clarifying questions: What is leisure travel? Assuming : Travel for vacation not business What is the vision/mission of the company that we are developing this for (I would like to keep this as an anchor to any users, pain points, solutions that we pick) Assuming : Brand new company - startup. Nothing specific in vision/mission for now. When we say travel user experience -> Do we have an existing product that we want to improve on? Is yes, is there any particular complaint or metric issue rel"See full answer