Interview Questions

Gowtami K. - "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"See full answer

Anonymous Armadillo - "I couldn't follow the solution offered here, but my solution seemed to pass 6/6 tests. Any feedback is welcome, thank you! def encrypt(word): en_word = "" for i in range(len(word)): if i == 0: en_word += chr(ord(word[0])+1) else: num = ord(word[i]) + ord(en_word[i-1]) while num > 122: num -= 26 en_word += chr(num) return en_word def decrypt(word): de_word = "" for i in range(len(word)): if i == 0: de_word += chr(ord(word[i]"See full answer

William W. - "Clarifying questions Is there a specific airline we are focusing on here? Assume any US passenger airline (Delta, United, Spirit etc.) Why is this company interested in improving the boarding experience? To increase customer satisfaction Can you define what we mean by 'boarding experience'? The time between the passenger arriving at the gate and sitting down in their assigned seat on the plane. Are there any constraints (resources or otherwise) that I should"See full answer

Mark - "Clarifying questions: What's Lyft current goal and how does this new focus on Deaf drivers align with Lyft's goal & strategy? Do Lyft already have service/product to enable deaf users to drive for lyft? Assume We don't have any existing product/service to allow deaf users to drive for Lyft today We are designing for the ridesharing business and that the Deaf drivers can drive for all types of Lyft rideshare options Lyft's Mission: Improve people's lives w/ the world's best transport"See full answer

B. T. - "You are given a string S and a number K as input, and your task is to print S to console output considering that, at most, you can print K characters per line. Example: S = "abracadabra sample" K = 11 Output: abracadabra sample Note that this problem requires the interviewee gather extra requirements from the interviewer (e.g. do we care about multiple white spaces? what if the length of a word is greater than K, ...)"See full answer

Sayee M. - "depending on project phase, apply various methodologies. scrum for app dev, waterfall for data migration, Testing (TDD for dev, FUT FiT for manual, UAT) , OCM has it own methodology ."See full answer

Kiley S. - "Improve facebook’s feed. Clarifying questions: Do we want to look at desktop or mobile specifically? – Mobile Is there a specific goal we have in mind that we are trying to meet or just general improvements? — General improvements, innovation Clarify Product: The Facebook newsfeed is the content feed that users see when landing on the app. The feed shows content posted by people users follow Within the feed the user is offered updates on people they follow - friends, family, celebrities"See full answer

Michael B. - "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"See full answer

Namrata L. - "Measure the success of SnapMap Clarifying question Snap is the feature which is visible on right swipe on snap chat showing map and location of your friends right? Do we have any specific goal in mind or we want to decide the overall success of the feature? Mission - Help users be connected with their friends and family and be updated about them. That is why the main medium of exchange is photos or videos in Snapchat which keeps people updated which actually putting things in words. Goal"See full answer

Surekha G. - "In one of the projects I managed, one team member was slipping each of his task's ETAs several times, citing different reasons, and communicating the delay after it already happened. The delay seemed disproportional to the reasons thereof. I first collected sufficient historical data to confirm that this was a pattern, and similar circumstances were faced by other team members, but they were managing to still keep their ETAs. Then I had a talk with the person, and showed him the data. I also ex"See full answer

Exponent - "You should be able to easily 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! "See full answer

Angela - "Clarifying Qs: What are we building the Google campus for on the moon? We are the Google X team and always want to move people forward and want to be the first private entity on the moon Are we trying to build for astronauts or our employees or someone else? This will be for employees Do we already have a location on the moon and we're expanding or will this be the first one ever? This is the first one ever. For us to answer this question, we'll want to discuss Google's mission, us"See full answer

Exponent - "This is a Diagnosis problem. We've gone over diagnosis problems in the past, but most are centered around usage. Even though this is about retention - do not be alarmed. We can still follow the TROPIC method to create a plan to thoroughly diagnose the issue: Ask clarifying questions List potential high level reasons Gather Context (TROPIC)Time Region Other features / products (internal) Platform Industry / Competition Cannibalization **Establish a theory of proba"See full answer

IamaPM - "Number of visits to the site had increased, so total reservations infact went up, but conversion was down due to more users visiting, due to a promotion offered by the company or may be due to more ad entry points, social media, friend recommendations etc."See full answer

Frank A. - "1) create the experimental and control groups. 2) Then calculate the proportion (mean) of the true conversion rates for both groups using the convert column which counts True as 1 and False as 0. This is their conversion rates 3) calculate the statistic of the two groups by subtracting the proportion and standardizing. 4) get the p-value and compare with 0.05. 5) conclude the difference is statistically significant if the p-value is less than 0.05 otherwise no statistical difference"See full answer