Interview Questions

Ankit kumar S. - "A 25% drop-off rate at sign-up for a new app, especially one from Meta, indicates a significant challenge in onboarding and user retention. To analyze this, consider external, internal, and product-specific factors. Identify Potential Causes: External Factors:Competition: Are other platforms offering a more attractive or simpler signup process? Timing: Is there a recent major event or trend that might be influencing user behavior? User Experience: Is the signup process clunk"See full answer

Ankit kumar S. - " logo Contact Interview Preparation Application Process Career Advancement Onboarding and Orientation Common Interview Questions Dashboard Creation Interview Questions and Answers Dashboard Creation Interview Questions and Answers What is a dashboard? Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"See full answer

Takashi M. - "My approach is try to narrow down by 4W1H. When - When this happened? Still continuously happen the problem? Where - Is this happen specific region or entire customers? What - What kind of problem? One time big error or any data show the curve? Who - Is it all platform or specific platform (Web, iOS, Android) How - How serious problem? How many customer affected? Next step is to narrow down the causes is from internal factors or external factors. For internal factors: Any recent up"See full answer

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

Mc L. - "I believe human emotions can't be judged by number and hence I have always made mistakes while judging the outcome of a reaction by data."See full answer

Chloe T. - "Mock interview 2/3/2025 Google Wallet User Needs (pain points): At physical store: understand the price tag proceed the transaction Audio cue to pick one credit card read the payment machine transaction confirmation (optional) balance hear transaction summary At home: check balance make payment send money receive money understand statement Prioritization Understand the price tag"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

Basil A. - " import java.util.*; public class MostCommonWords { public static String mostCommonWords(String text) { // your code goes here Map map = new HashMap(); for(String s : text.replaceAll("[\\p{Punct}]", "").toLowerCase().split(" ")) { if(!s.isEmpty()) { map.merge(s, 1, Integer::sum); } } return map.entrySet().stream().sorted( (e1, e2) -> { "See full answer

Mitchell K. - "How important are referrals? Do you need multiple vs. just one? Does it matter who refers you?"See full answer

Kartikeya N. - "Clarifying questions Are we referring to the credit card users of a particular card company or the overall number of users? : Overall number And we are referring to the number of unique users right, as in a person may have more than 1 card? : yes Can I assume the time setting of the question to be 2024? : Yes Thanks. Here's how I would approach this. India's total population = 1.4 Bn I know for a fact that in India only 2.5% of population pays income tax. A salaried employee who doe"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

Darpan D. - "Clarifying questions and Assumptions ChatGPT search means the search function inside the chat app? OR ChatGPT search Chrome extension? Assumption: Search inside the chat app. Is there any location restriction in this analysis? Assumption: USA only. Is there any user segment restriction in this analysis? Assumption: All user segments. Are we assuming the ChatGPT search already exists or going back in time before the ChatGPT search existed? Assumption: Go back in time"See full answer

Kshitij I. - "Data lake and warehouse are both places that allow an organization to store large amounts of data. When swimming in a lake, one would imagine that they come across all sorts of stuff - floating twigs, fish in the water, stones, chemicals and sometimes may be even a snake. Similarly, a data lake stores all forms of data that the company has without any indexing. The data is available at any time but needs to be first cleaned up and reorganized before it can be used for any type of analysis. A"See full answer

Victor N. - "--country names are UPPERCASE but the table in the in the question showing lowercase. That's why it took me a while to figure it out until I ran the country column WITH RECURSIVE Hierarchy AS ( SELECT e.Emp_ID, CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS FullName, e.Manager_ID, 0 AS Level, CASE WHEN e.Country = 'IRELAND' THEN s.Salary * 1.09 WHEN e.Country = 'INDIA' THEN s.Salary * 0.012 ELSE s.Salary "See full answer

V V. - "Simple file system ( Hash Map , LSM trees), and consistent hashing. I failed to discuss about conflicts ( Versioning)"See full answer

Greg L. - "From chatGPT: If Coinbase's net income is 10% less than it was last month, several actions can be considered to address the decrease in profitability. Here are some steps that might be taken: Conduct a Detailed Analysis:Investigate the reasons behind the decrease in net income. Analyze key financial metrics, transaction volumes, fee structures, market conditions, and any external factors impacting revenue. Expense Review:Review and analyze operating expenses. Identify areas where"See full answer