Interview Questions

Sreenath P. - "I confirmed with the interviewer that its about how slave replaces primary when primary node when suddenly shuts down. It was very tough question for me i felt. i told, we need to maintain schema of primary, secondary instances with their URL's and posts. There should be heartbeat service which always pings the actual microservices to get to know their instances health."See full answer

Ravi P. - "First Example I in my role as a engineering manager were designing homepage widget where we showing , how much sales the seller has made today . We were listening to order placed event , and then aggregating this information and showing to seller , Now there were cases where a sellers order might have been cancelled be user or by the seller or due to some breaches , as this can happen through multiple different channels and which were not audited , There was no full proof way to cover all the e"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

Tomer B. - "Clarify What do we mean by memorialize? Are we aiming to launch a physical or software product? What is our goal with this product? Are there specific types of pets we have in mind? Assumption Memorialize means to remind ourselves about our loved pets who passed away. We would like to launch a software product. The goal is to help users cope with the lose of their beloved pets. We also focus on house pets, keeping it for dogs and cats as the biggest market for pets. User"See full answer

Nanda S. - "Looked at use-cases - what would be biggest value props be. Looked at VIP people moving to save the cost of private airplane, security personnel and for everyday people it could be used for emergencies when people had to be moved quickly and safely. Looked at industrial use cases also for security such as moving precious stones like diamonds or high amount of cash where there would be high security, armoured trucks and logistics cost. Decided to narrow down to industrial use and went deeper int"See full answer

Deepak M. - "Imagine there's a new toy you've always wanted, but it's not quite perfect. Maybe it's missing a feature you'd love, or it's a bit too complex to use. That's where a product manager, or PM, comes in! Think of a PM like the captain of a shipbuilding this amazing toy. They work with different teams, like the designers who make it look cool, the engineers who build it, and the marketers who tell everyone about it. They listen to people like you, who use the toy, to understand what they like and wha"See full answer

Tulio G. - "Imagine you're a PM at YouTube and you've made the decision to ban videos with explicit language from monetization; take me through your decision process. Clarifying questions: Was the decision made, to ban videos in general from the platform, or only for monetization? Answer: Ban for Monetization only, the videos would still be available on the platform. Considering highly offensive, vulgar, sexual or graphical language are already considered violations of Youtube'"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

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

Harsha J. - " from typing import List, Optional class Node: Constructor to create a new node def init(self, cost: int): self.cost: int = cost self.children: List['Node'] = [] self.parent: Optional['Node'] = None def getcheapestcost(rootNode: Node) -> int: if len(rootNode.children) == 0 : if rootNode is None: return rootNode.cost ans = float('inf') def helper(root, sum1): nonlocal ans if len(root.children) == 0 : "See full answer

Anonymous Wallaby - "Before I begin, I would confirm the idea of Stories as "phone-shot video with light editing to share a person's current experience in a short form video". I would also ask if they would be integrated into the current application or a standalone service. The process I'll use is to think through twitter's mission, outline its current user personas and how they use twitter. Articulate a rubric framework for stakeholder needs, and then compare the stories idea against that. To start off with the m"See full answer

Wang L. - "Tagging system - tagging the resources, like tickets, tasks, pages. Support to query based on tags."See full answer