Interview Questions

Soodong P. - "Product and Mission To allow users to create events and host on FB pages. It can be one time or recurring. It can include FB users through feeds or referrals or can be shared out with a link. Product objective is to build strong online and offline bonding through connecting people with common interests and ensure continued engagements. Aligns with the core Meta mission. User Journey and Value + Metrics Organizers: Finds the value when the many participants share interest or"See full answer

Tabrez Z. - "First of all, I could tell that Google maps are used by billions of people around the world. Not only immensely used by the billions of people, but also they are dependent on google maps. I believe that google maps are the only map service in the world, which is providing the best services. We are collecting huge data from this service, which is very useful to predict or analyze market sentiments. We have invested a humongous amount of time, effort, and money to establish these renowned google M"See full answer

Abiodun M. - "A successful marketing campaign is the practice of putting your yourself, product or idea in front of the right audience who are interested in what you do. For a campaign to be successful, you will have gone through series of UX research like audience research, market research, competitor research, users research, etc. Let me put it this way, A successful marketing campaign is human-centered both in design and words. i don't know if i got the answer right."See full answer

Ragupathy V. - "Started with clarifications, listed out assumptions, created stories with user pain points in existing business, how we can eliminate in our design and strategy, metrics for the success of business initial 90 days, 6 months and a year. What i missed to present is the north star metrics Overall i thought i did well, still didnt get through Hope it will help me for other interviews in Amazon/Meta/Cisco"See full answer

Jack F. - "This is an estimation question - the goal is to show your thought process to the interviewer how you think through the question Let's make some assumptions - we are only focused on the TAM for Capital One's new potential card For the purpose of scoping this more narrowly let's assume we are solely focused on the U.S. Let's continue to scope in... 1). We know the United States population is somewhere in the ballpark of ~330MM (let's use round figures) 2). You should have some due dili"See full answer

Anonymous Sheep - "Would be great to order the answer by Pirate Metrics and prioritize recommendations by the leakiest part of the funnel: Awareness - Advertising the existence of the restaurant in the local community. Acquisition - Getting tables booked. Can you book online? Do we have a phone number? Activation - Food orders. What's the average size of an order? Can we change the menu a bit? Payment options. Retention - Maybe we can create a loyalty club for patrons? Referral - Maybe we can give coupon"See full answer

Alexey T. - "with t1 as (select employee_name, department_id, salary, avg(salary) over (partition by departmentid) as avgsalary, abs(salary - avg(salary) over (partition by department_id)) as diff from employees ) select employee_name, department_id, salary, avg_salary, denserank() over (partition by departmentid order by diff desc) as deviation_rank from t1 order by departmentid asc, deviationrank asc, employee_name `"See full answer

Danyal R. - "Estimate the number of Instagram posts per day Assumptions: calculating for the US only Assumption for grid photos and not stories Equation Number of Instagram posts / day = users * frequency / 365 Break down components Assumption: instagram has 1 billion active user's across the world, let's assume there's 100 million active users in US But in a day there's likely only 50% of the active users on the app [30%] Casual Users - open the app 3-4 times a week but post once ever"See full answer

Michael M. - "Tiktok"See full answer

Sean S. - "test"See full answer

Hayatu H. - "How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)? 1 Follow Request Answer More All related (34) Recommended 📷 Trausti Thor Johannsson · Follow Been using MySQL for more than 16 yearsDec 27 There are functions like DATEDIFF but there are also BETWE"See full answer

Sam M. - "The design review has three stages; In-draft, Review and Complete. I consider a design review completed when the problem statement has been clearly addressed via a feature or a solution and signed off on by all the key stakeholders along with engineerings."See full answer

Priyanka C. - "Firstly need to check is this service really beneficial or not. And video service provide more realistic perspective about the product so keep it"See full answer

Anonymous Caribou - "Sales and Delivery app: Ask Clarifying questions: What all parts of the user journey does this app play a role in? All delivery notifications go through this app. Tesla while completing sales does ask its customer to download this app. Sales can be completely done through the app. Sales person at Tesla could be reached through app. App can be used to buy other peripherals for Tesla. Success Metrics: Revenue: \# of car sales completed through the delivery app. \# of peripheral"See full answer