1500+ Business Analyst Interview Questions and Answers

Weigh each box one by one and compare the weight with the expected weight.

• Weigh the first box, if it weighs 100gm then it's not the defective box.

• If it weighs 99gm, then it's the defective box.

• If it weighs 101gm, move on to the next box and repeat the process.

• Continue until you find the box with the defective balls.

The last person surviving will be the 73rd person.

• The pattern of shooting skips every second person.

• After each round of shooting, the number of people remaining is halved.

• The last person standing will be the one who is skipped in every round of shooting.

After opening and closing doors with multiples of their numbers, which doors are open?

• Doors with odd number factors will be open after 100th time

• Doors with even number factors will be closed after 100th time

• Example: Door 16 will be closed after 100th time as it has factors 2, 4, 8, 16

My strong point is Java. I have a good understanding of inheritance, modularity, and abstraction. I also have knowledge of C++.

• Inheritance is a mechanism in OOP where a new class is derived from an existing class. Types of inheritance are single, multiple, multilevel, and hierarchical.

• C++ is a compiled language while Java is an interpreted language. C++ supports operator overloading while Java does not.

• Modularity in C++ is achieved through the use of header files and namespac...read more

The minimum number of times you need to weigh the coins is 4.

• Divide the 100 coins into 3 groups of 33, 33, and 34 coins.

• Weigh the first two groups against each other.

• If they balance, the defective coin is in the third group.

• If they don't balance, the defective coin is in the lighter group.

• Divide the lighter group into 11 coins and weigh any 2 groups of 3 coins against each other.

• If they balance, the defective coin is one of the remaining 5 coins.

• If they don't balance, the def...read more

As a product manager, I would approach selling a product by identifying the target audience, creating a unique value proposition, and utilizing various marketing channels.

• Identify the target audience and their needs

• Create a unique value proposition that addresses those needs

• Utilize various marketing channels such as social media, email marketing, and advertising to reach the target audience

• Provide product demos or trials to potential customers

• Collect feedback and make necessa...read more

The 100th person will be alive.

• The pattern shows that every even numbered person is killed and every odd numbered person receives the sword.

• The sword eventually comes back to the 1st person who started the cycle.

• Therefore, the 100th person will be killed by the 99th person and the sword will go back to the 1st person.

• Hence, the 1st person will be the only one left alive.

The last ball will be red.

• If the first two balls are of different colors, they will be replaced with a red ball.

• If the first two balls are of the same color, they will be replaced with a blue ball.

• The number of balls in the container does not affect the outcome.

• The last ball will be red because there are more red balls than blue balls in the container.

Fill the 3L jar and pour it into the 5L jar. Repeat the process with 3L jar and stop when 5L jar has 4L water.

• Fill 3L jar and pour it into 5L jar

• Repeat the process until 5L jar has 4L water

• 4L can be measured by filling 3L jar twice and pouring it into 5L jar until it reaches 4L

The task is to find the sum of squares of the first 'N' natural numbers.

• Iterate from 1 to N and calculate the square of each number

• Add all the squares together to get the final sum

• Return the sum as the result

Check if a given string is a palindrome or not.

• Iterate through the string from both ends and compare characters.

• If all characters match, the string is a palindrome.

• Consider handling cases where spaces or special characters are present.

• Example: 'racecar' is a palindrome, 'hello' is not.

Count the total number of set bits in the binary representation of numbers from 1 to N, modulo 10^9+7.

• Iterate through numbers from 1 to N and count the set bits in their binary representation

• Use bitwise operations to count set bits efficiently

• Return the total count modulo 10^9+7 as the result

Label the outcomes as 0 and 1. Toss the dice twice and record the outcome as 00, 01, 10, or 11. If the outcome is 00 or 11, discard and repeat.

• Label the outcomes as 0 and 1

• Toss the dice twice and record the outcome as 00, 01, 10, or 11

• If the outcome is 00 or 11, discard and repeat

This pen is not just a writing instrument, it's a statement of luxury and exclusivity.

• Highlight the pen's unique design and craftsmanship

• Emphasize the use of high-quality materials

• Mention any special features or functions

• Create a sense of exclusivity and rarity

• Appeal to the buyer's desire for luxury and status

• Offer personalized engraving or customization options

Eligible customers for Vodafone's 4G service launch in India.

• Customers with 4G compatible devices

• Customers with high data usage

• Customers in areas with good network coverage

• Customers who have shown interest in technology and gadgets

• Customers who have previously used Vodafone's high-speed data services

• Customers who have opted-in to receive promotional messages

Weighing balance puzzle to find the lighter coin among 9 coins.

• Divide the coins into 3 groups of 3 coins each

• Weigh any two groups against each other

• If one group is lighter, weigh two coins from that group against each other

• If they are equal, the third coin is the lighter one

• If they are not equal, the lighter coin is the one that weighs less

• If both groups weigh the same, the lighter coin is in the third group

• Weigh two coins from the third group against each other to find the l...read more

The minimum number of trips required to achieve a rating of 4.5 is 20.

• To calculate the minimum number of trips required, we need to find the difference between the current rating and the desired rating.

• Since the desired rating is 4.5 and the current rating is 4.2, the difference is 0.3.

• Each trip contributes to the rating, so we need to divide the difference by the rating increment per trip.

• The rating increment per trip can be calculated by dividing the additional discount (10...read more

Calculate the Nth term of the Fibonacci series using a recursive formula.

• Use recursion to calculate the Nth Fibonacci number by summing the previous two numbers.

• Base cases are F(1) = 1 and F(2) = 1.

• Handle edge cases like N = 1 separately.

• Optimize the solution using memoization to avoid redundant calculations.

• Ensure the input N is within the constraints 1 ≤ N ≤ 10000.

The exact number of orders delivered by Swiggy in Pune on a daily basis is not publicly available.

• Swiggy does not disclose the number of orders delivered in a specific city on a daily basis.

• The number of orders delivered by Swiggy in Pune may vary depending on factors such as day of the week, time of day, and season.

• Swiggy's focus is on providing timely and efficient delivery services to its customers, rather than on disclosing the number of orders delivered.

• However, Swiggy h...read more

Estimate cycle sales in Bokaro by analyzing demographics, economic factors, and travel needs.

• Identify the population of Bokaro, focusing on urban vs rural distribution.

• Assess the economic conditions, such as average income and employment rates.

• Consider the average travel distance for daily commutes and leisure activities.

• Evaluate the availability of public transport and its impact on cycle usage.

• Look into local cycling culture and any government initiatives promoting cycling.

Reverse a given number while excluding trailing zeros.

• Iterate through the digits of the number from right to left.

• Skip any trailing zeros while reversing the number.

• Store the reversed number and return it as the output.

The number of delivery boys who called customers more than 5 times is not provided.

• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.

ERP is a software that integrates various business processes and functions into a single system.

• ERP stands for Enterprise Resource Planning.

• It helps organizations streamline their operations and improve efficiency.

• Advantages of ERP include centralized data management, improved collaboration, and better decision-making.

• It automates processes like inventory management, financials, human resources, and customer relationship management.

• ERP provides real-time visibility into busin...read more

Guesstimate the total number of Wagon-R cars sold in India.

• Consider the total population of India and the percentage of car owners

• Look at the market share of Maruti Suzuki in India

• Consider the popularity of Wagon-R among small car buyers

• Check the sales figures of Wagon-R in the last few years

• Assume a growth rate based on the current market trends

Query to calculate rolling sum

• Use window functions like SUM() OVER() in SQL

• Specify the window frame to define the range for the rolling sum

• Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name

Inheritance, polymorphism, and classes are fundamental concepts in object-oriented programming.

• Inheritance allows a class to inherit properties and methods from another class.

• Polymorphism allows objects of different classes to be treated as if they are of the same class.

• Classes are blueprints for creating objects that have properties and methods.

• For example, a Car class can inherit from a Vehicle class, and a SportsCar class can inherit from the Car class.

• Polymorphism allows ...read more

TCS recently announced a partnership with Google Cloud to build industry-specific cloud solutions.

• TCS and Google Cloud will jointly develop cloud solutions for industries such as healthcare, financial services, and retail.

• The partnership aims to help organizations accelerate their digital transformation journey by leveraging the power of cloud technology.

• TCS will also establish a Google Cloud Academy to train its employees on Google Cloud technologies.

• This collaboration highl...read more