Interview Questions

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

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

Alok S. - "Functional Rquirements: User should be able to read account balance user should be able to withdraw money from account user should be able to add money to account user should be able to create a new account user should be able to cancel an opened account All of the above for Checkings and Savings account User should be able to pay credit card bill (similar to adding balance to checking and savings account) Non functional Requirements: ACID transactions. consistency > availabi"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

Rashi N. - "Yes"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

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

Adam S. - "The diagram for this problem is silly. The nodes are labeled with numbers, but those numbers are really the weights of the edges, not the labels of the nodes."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

Janell O. - "One of the most basic measures of how well a PMO is functioning is the percentage of projects that are completed as a ratio of all the projects in a portfolio. More illustrative is how many of the projects are completed within the timeframes budgeted for the projects."See full answer

Anonymous Sheep - "Would be great to order the answer by Pirate Metrics and prioritize recommendations by the leakiest part of the funnel: Awareness - Advertising the existence of the restaurant in the local community. Acquisition - Getting tables booked. Can you book online? Do we have a phone number? Activation - Food orders. What's the average size of an order? Can we change the menu a bit? Payment options. Retention - Maybe we can create a loyalty club for patrons? Referral - Maybe we can give coupon"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

Teja G. - "To design a scalable ticketing system for peak events like Black Friday, you must employ a microservices architecture, implement robust load balancing, leverage caching, and use a combination of NoSQL and relational databases for different data types. Key features also include real-time seat booking, secure payment integration, mobile compatibility with QR code validation, robust admin dashboards for analytics, and integrated marketing tools like promo codes. The system needs to prioritize avail"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

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