yellow.ai Senior Business Analyst Interview Questions and Answers

4 Coding Questions Leetcode Level Medium to Hard. Had to solve it within 1.5 hours.

Was able to solve 2 questions - One hard and one Medium. Hadn't enough time to solve all.

Q1. DSA based round. Was asked to write 3 APIs based on the the given n-ary tree.
Add your answer
Q2. Questions based on Path, end node, best path, etc.
Add your answer

Q1. System Design round : Was asked to design RDBMS for the given problem.
Add your answer

Q1. HM Round : Mostly behavioral based around Twilio Magic Values
Add your answer

Q1. Bar Raiser Round : Taken by a director. Was asked behavioral questions again.
Add your answer

Q1. What final class and method
Ans. 
The final class and method are used to prevent inheritance and method overriding respectively.
• Final class: A final class cannot be subclassed. It is often used for utility classes or classes that should not be extended.

• Final method: A final method cannot be overridden by subclasses. It is used to prevent modification of a method's behavior in subclasses.
Answered by AI
Add your answer
Q2. PHP reference variable
Add your answer
Q3. Find duplicate numbers
Ans. 
Find duplicate numbers in an array of strings.
• Iterate through the array and keep track of the count of each number using a hash map.

• If the count of a number is greater than 1, it is a duplicate.

• Return the list of duplicate numbers.
Answered by AI
Add your answer
Q4. Echo variable in single quote what will be output
Ans. 
The output will be the literal string of the variable, without any variable interpolation.
• When a variable is echoed in single quotes, it is treated as a literal string.

• No variable interpolation or special characters are interpreted.

• The output will include the variable name itself, not its value.
Answered by AI
Add your answer
Q5. What is oops concept
Ans. 
Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.
• OOP is based on the concept of classes and objects.

• It focuses on encapsulation, inheritance, and polymorphism.

• Encapsulation hides the internal details of an object and provides a public interface.

• Inheritance allows classes to inherit properties and methods from other classes.

• Polymorphism allows objects of diff...read more
Answered by AI
Add your answer
Q6. Having clause in MySQL
Ans. 
The HAVING clause is used in MySQL to filter the results of a GROUP BY query based on a condition.
• The HAVING clause is similar to the WHERE clause, but it operates on grouped rows rather than individual rows.

• It is used in conjunction with the GROUP BY clause.

• The HAVING clause is used to filter the results of a GROUP BY query based on a condition that applies to the grouped rows.

• It is typically used to specify condition...read more
Answered by AI
Add your answer