Interview Questions

Farhan -. - "Sorting is a technique to arrange data in either increasing order or decreasing order, and, the function that implements this functionality is called sort function"See full answer

Bryan L. - "with var1 as (select *, rank() over(order by score desc) as srank from players) select player_name, score, srank as ranking from var1 where srank in (4, 6, 11) `"See full answer

Praful B. - "Set clear goals- What do you want to achieve by learning this new technology? Are you trying to build a specific project, or are you just interested in learning more about it? Having clear goals will help you stay motivated and focused. Find a good learning resource There are many different ways to learn a new technology. You can take online courses, read books, or watch tutorials. Find a resource that fits your learning style and budget. Start with the basics- Don't try to"See full answer

Yashaswini K. - "The interviewer was curious to understand my transition from a core development profile to an NGO and then to an MBA program. He was trying to understand my thoughts behind the journey and what convinced me about going for a PM role. What helped me answer this was - Having spent some time by myself mapping out the good and not-so-great experiences at each part of my journey What exactly motivated me to take the next step each time How it all connected What moments in the journey hi"See full answer

Nicholas S. - "Definitely nice to think of this without memorization, but there is a well known algorithm for this problem, which is the Levenshtein Distance. Lev(a,b) = len(a) if len(b) == 0 = len(b) if len(a) == 0 = lev(a[1:], b[1:] if a[0] == b[0] = 1 + min (lev(a, b[1:]), lev(a[1:], b), lev(a[1:], b[1:])) https://en.wikipedia.org/wiki/Levenshtein_distance I'm sure some optimizations could be made with heuristic."See full answer

Ben G. - "Ask Follow up Questions Is this for specific type of user or open? Do we have any past research that has been done? Do we have an idea of company and user goals? Do we have metrics of success? Are there any existing constraints? Why  |  5 min Why is this product or feature important? How does this product benefit customers? What business opportunities does it create? What is our hypothesis? What are our company goals? Who  |  3 min Who are the different types"See full answer

Helen - "Clarify What type of company are we? [We are a new company that is launching a smart closet] Any constraints? [No constraints; you have infinite resources] What’s the goal? [Enter the market/acquire users] Closet for clothing only or for some commercial use? [Clothing only in homes] How are we defining a 'smart' closet? Assuming we are incorporating technology? [Yes] Which market? [You decide] --> Let's go with US market to start Business Objective/Market Context For the purpose of thi"See full answer

Pavani M. - "I value feedback and see it as crucial for professional devolopment"See full answer

Vineet S. - "This is phased approach and would consist below steps Initiation - Identify Business Goals and Drivers, Perform TCO Analysis, Compliance Assessment and then formulating strategy Prepare: Develop Require Skill sets and roles and Technical Cultural Training through CoE, Collaboration with partners and internal stakeholders Assess: Conduct workshops, understand Application Realms and identify the cloud candidates OKRs and App Roadmap Execute: Learn, Design, Implement, Document, Depl"See full answer

Exponent - "This is a Favorite Product question with a slight twist. We have a constraint: picking a marketplace. Let's go over the Favorite Product formula before we begin: Choose a product and briefly explain what it is Who are the users? What are their pain points? How did competitors solve it in the past? How does this product address these pain points differently and better? How would you improve it/make it better? Summarize Let's start! Choose a"See full answer

David n. C. - "First of all, I would try to create and foster a good atmosphere. I will talk honestly with the team and I will expose my doubts openly in order to be transparent. I will talk calmly about my fears and I will ask for opinions. This way I will open the door of transparent communication."See full answer

Abhishek T. - "I explained about a project that was technically very challenging and had tight deadline. We were working on a new technology with new team members but delay was not an option. When we hit a road block due to lack of knowledge on Content Management System and Database, we came up with an idea of hard coded JSON data to help continue building the front end and user experience while team is figuring out to unblock the CMS and DB blocker. That way we would still move forward and show progress in IT"See full answer

M N. - "I'm assuming we are estimating lyft rides taken for attending Halloween parties since the usual daily ride data is already available. Let's assume Lyft is only available in the US. I'm going to start with US population and then estimate the number of people who might be party goers and then deduce number of rideshare users and then estimate how many of them will use Lyft to take them to and from the Halloween party. There are 300M ppl in US. Lets say I break down age groups 1-20, 20-40, 40-60,"See full answer

Nehal B. - "Who uses translation API Consumer apps Enterprise SaaS Content Platforms Gaming Companies Govt Global internet users - 5B out of which 20% need translation as they encounter foreign content = 1B users Average translation triggering event per use per day - 0.3 (review, website…) Total translation demand = 0.3 * 1B = 300M Translation can happen in-house or via Third-party APIs Assume 60% served by APIs for enterprise 180M API translation calls/day Assume 1000 characters should be abo"See full answer

Sarthak A. - "Generally, these kinds of issues are routed via the customer support teams, their role in such a scenario is to try to reproduce the issue. If the issue is valid they create a JIRA ticket with the exact issue for the development teams / On-Call engineer to fix. In this case, I am going to assume there is no customer support team. The first thing I'll try to do is reproduce the issue using the exact steps that the customer would have used to connect to the fire stick. In case the customer was d"See full answer