Interview Questions

Scott S. - "Great question! Before communicating any major change, I would ensure I have a deep understanding of the strategic shift, its rationale, and its implications. This involves meeting with senior management to gather all necessary details and preparing to address any questions or concerns from the team. To share a recent experience I had, so Last year, our senior management decided to shift our focus towards leveraging machine learning and advanced real-time analytics to enhance our trading stra"See full answer

P K. - "Redefining the question as: How will you solve the problem of misinformation on FB? Clarifying questions: Are we talking about building a product? (Up to you) What exactly is misinformation? (Fake news, inaccurate facts being shared on social media) Goal: Reduce the amount of misinformation spread on the platform and improve user trust. Key users associated with misinformation: News Accounts (eg CNN) - They may get involved in some controversy about a fake photoshopped artic"See full answer

Ushita S. - "Video has audio disruption starting at ~7th minute, did not understand what law he was talking about. Can someone please clarify?"See full answer

Anonymous Unicorn - "python: def justifywords(wordslist, width): result = [] currlinechar_count = 0 curr_words = [] for word in words_list: if curr_words: space_needed = len(word) + 1 # Space needed for the word and a preceding space else: space_needed = len(word) if currlinecharcount + spaceneeded > width: result.append(' '.join(curr_words)) curr_words = [word] currlinechar_count = len("See full answer

Bryan L. - "with var1 as (select * from tbl_Employee where emp_id between 2 and 2+3 and (Empid = 2 and FirstName = 'Paul' and Last_Name = 'Desmond' or Emp_id > 2) ), var2 as (select *, case when Country = 'IRELAND' then Salary * 1.09 when Country = 'INDIA' then Salary * 0.012 else Salary end as USD_Salary from  (select * from var1 join tbl_EmployeeSalary on var1.EmpID = tblEmployeeSalary.Emp_ID)), var3 as (select * from var2 where Emp_ID = 2) select FirstName || ' ' || MiddleName || ' ' || Last_Name a"See full answer

Ekta M. - "Define the feature A virtual card number is a temporary or disposable card number generated by your credit card issuer or financial institution. It is designed to protect your actual credit card information during online transactions. Its main purpose is the security of your actual credit card. Clarification questions No questions What is the purpose of the feature? Enhanced Security: Using a virtual card number protects your actual credit card details from being exposed to potentia"See full answer

S Y. - "Clarifying question? What is GCP and what does it mean to create a new GCP region in Portugal? GCP is Google Cloud Portugal. Creating a new region means creating data centres (clouds) which can be used as hosts. Is there a business objective to consider Portugal for a new region? None in particular Structure: Explore internal factors Is there a particular business goal that we are trying to accomplish like goal of getting more business from EU companies in coming few years? If yes"See full answer

Aeshvarya J. - "Food delivery apps : Food delivery apps are clear example of demand and supply functions, Both end need to monitored closely. Ecosystem : Order placer, Restaurant and Food delivery Platform Value : Order placer find value when they can order food at home from their fav restaurants. Restaurant find value when they make sell via order coming in and probably good reviews which marks future growth. Food delivery platform when orders are being placed. North star metrics : # of order delivered Bre"See full answer

shubh4197 - "I responded by creating a directed graph and applying topological sorting on it"See full answer

Sanjana G. - " are we considering ride sharing app or also Uber Eats? If we are considering Ride sharing app Uber is successful when a Customer is safely dropped at its selected destination and Uber driver is paid for the drive. For Uber to be successful in a new city we want to track Number of completed rides per day/week Number of customers who came back to the app for another ride after first one was completed. Number of active drivers per day. Number of drivers completing at least 1 ride"See full answer

Chris C. - "Here are the key entities to design a relational schema for a calendar application: User - userid, email, firstname, lastname Calendar - calendarID, calendarName, caledanUserID, defaultUIView, created, updated, status Event - eventID, eventName, eventUserID, isRecurrence, startDateTime, endDatetime EventReminder - eventID, reminderMethod(email, notification), reminderTime, reminderTimeUnit(min, hr, day) Event guest - eventID, userID, isRequired, acceptStatus"See full answer

Michael S. - "import string from collections import defaultdict def mostcommonwords(text): d = defaultdict(int) s = text.translate(str.maketrans('', '', string.punctuation)) for w in s.lower().split(): d[w] = d[w] + 1 return sorted(sorted(d.items()), reverse=True, key=lambda x: x[1]) `"See full answer

Cameron P. - "Assuming I am a PM for company X and my current task for the morning is resolving a new conflicting product requirement. First I would like to inquire more about the product and about the conflict. Product: Assuming I am new and I didn’t already know what the product was, what is our product's value proposition to our customers? How does our product align with our company's goals? What does success look like for our product? Have we been successful in the past? Who are our customers? Conflict"See full answer

Farhan I. - "What software is being used to draw the design?"See full answer

Kurt K. - "Why skip defining the data model? Or did I just miss it?"See full answer

Scott S. - " Functional Requirements Content Ingestion\: Ingest news articles from various sources (websites, social media, etc.). Handle different types of content (text, images, videos). Content Analysis\: Extract and preprocess text from articles. Analyze the content for potential indicators of fake news. Model Training and Prediction\: Use machine learning models to classify content as fake or real. Continuously improve models with new data and f"See full answer

Puneet A. - "I recently had an experience with the Chipotle mobile app where I accidentally placed an extra order. Realizing my mistake within seconds, I tried to edit or cancel the order but found no option to do so in the app. Despite searching FAQs and attempting to contact the local store, I couldn't resolve the issue in time. This experience highlighted the importance of user-friendly design and clear communication in apps. If I were managing such a product, I would advocate for features like a grace pe"See full answer

Personal W. - "Payment system requirement assumption: Need to be ACID Amount limitation - some validation for max input size can be done at client level/ API level. Need to store historic info - GDPR The information to be stored for database assumed can be structured so RDBMS like mysql or Postgres Notification requirement - if fail or success need to be text or email to user and or caller Scalable - Assumption that it deals with critical transaction so Availability and Scalability requirement i"See full answer