200+ Business Analyst Interview Questions and Answers for Freshers

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

333 digits can number 166 pages of a book.

• Each page number takes up 2 digits.

• The first page is numbered 01.

• The last page that can be numbered is 166.

• The remaining 2 digits are used for the cover page or other information.

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

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.

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

Cars would grow faster than motorbikes due to economic factors.

• Shift from lower middle to upper middle class favors cars

• Increasing growth rate for cars more than for bikes

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

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

A diode is an electronic component that allows current to flow in one direction, while a rectifier converts alternating current to direct current, and an amplifier increases the amplitude of a signal.

• A diode is a two-terminal device that conducts current in one direction and blocks it in the opposite direction.

• A rectifier is a device that converts alternating current (AC) to direct current (DC) by using diodes.

• An amplifier is an electronic device that increases the amplitude ...read more

Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

• Analyze user behavior and preferences to understand their needs and preferences

• Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

• Optimize search functionality to ensure accurate and relevant results

• Collaborate with restaurants to improve their online presence and menu offerings

• Leverage cust...read more

SQL query to get top 100 Uber drivers by city

• Join drivers and users tables on city

• Aggregate driver ratings and count of rides

• Order by rating and count of rides

• Limit to top 100

An infinite loop is a loop that runs indefinitely without stopping.

• It can cause a program to crash or freeze.

• It is usually caused by a logical error in the loop condition.

• Example: while(true) { //code }

• Example: for(;;) { //code }

To find the count of visitors and new visitors that came today in a database management system (DBMS).

• Use a query to filter the visitors based on the current date.

• Count the total number of visitors using the COUNT function.

• To find new visitors, compare the current date with the date of their first visit.

• Use the DISTINCT keyword to count only unique new visitors.

As of 2021, India's GDP growth rate is approximately 9.2% and its dollar value is around $3.05 trillion.

• India's GDP growth rate is one of the highest among major economies.

• The GDP growth rate indicates the rate at which the country's economy is expanding.

• The dollar value of India's GDP represents the total economic output in terms of US dollars.

• The GDP growth rate and dollar value are subject to change as new data becomes available.

The 4 P's of marketing are Product, Price, Place, and Promotion.

• Product: Refers to the goods or services offered by a company.

• Price: The amount customers are willing to pay for the product.

• Place: The location or channel through which the product is made available to customers.

• Promotion: The marketing activities used to communicate and promote the product.

To approach a customer for selling a costly new phone, I would focus on highlighting the unique features, benefits, and value it offers.

• Understand the customer's needs and preferences

• Highlight the unique features and benefits of the phone

• Emphasize the value and long-term benefits of investing in a high-quality phone

• Offer flexible payment options or financing plans

• Provide comparisons with other phones to showcase the superiority of the new phone

• Offer a trial period or money-ba...read more

Need is a necessity or desire for something, while demand is the willingness and ability to pay for it.

• Need is a basic requirement for survival or to fulfill a goal, while demand is the desire for a product or service backed by purchasing power.

• Need is a subjective feeling, while demand is an objective measure of the market.

• Need can exist without demand, but demand cannot exist without need.

• Example: People need food to survive, but not everyone has the demand for expensive go...read more

The number of tennis balls that can fit in a school bus depends on the size of the bus and the size of the tennis balls.

• The size of the school bus and the size of the tennis balls are important factors to consider.

• The shape of the tennis balls and how they are packed also affects the number that can fit.

• Assuming an average school bus size and tennis ball size, approximately 50,000 tennis balls can fit in a school bus.

Sort and remove duplicates to ensure availability of products for Blinkit and Zepto campaigns throughout the day in Python.

• Sort the products list for each campaign

• Remove duplicates from the sorted list

• Repeat the process for both Blinkit and Zepto campaigns

The order of execution of SQL clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

• The SELECT clause is executed first to retrieve the desired columns from the table.

• The FROM clause is executed next to specify the table(s) from which the data is retrieved.

• The WHERE clause is executed after the FROM clause to filter the rows based on specified conditions.

• The GROUP BY clause is executed to group the rows based on specified columns.

• The HAVING clause is executed after the ...read more

The current Sensex of India is constantly changing and can be checked on financial news websites.

• Sensex is the stock market index of the Bombay Stock Exchange (BSE) in India.

• It represents the performance of the top 30 companies listed on the BSE.

• As of now, the Sensex is constantly fluctuating due to various economic factors.

• One can check the current Sensex value on financial news websites like Moneycontrol, Economic Times, etc.

Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

• Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

• Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

• Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

• Linear Regression is sensitive to outliers while Logistic Regression is robust...read more

Citi bank should set up its offices in major cities like Mumbai, Delhi, and Bangalore.

• Citi bank should consider the economic and political stability of the region.

• The bank should also consider the availability of skilled workforce and infrastructure.

• Major cities like Mumbai, Delhi, and Bangalore have a large customer base and a well-established financial sector.

• Setting up offices in multiple cities can help the bank reach a wider audience and diversify its operations.

I would analyze the cost structure and pricing strategy to identify the root cause of decreasing profit.

• Analyze the cost structure to identify any cost increases that may be impacting profit margins

• Review pricing strategy to ensure it is aligned with market demand and competition

• Evaluate sales mix to determine if there are any products or services that are less profitable

• Consider implementing cost-cutting measures or adjusting pricing strategy to improve profitability

Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

• Bias-Variance trade-off is a fundamental concept in machine learning.

• High bias models are simple and have low variance, but are inaccurate.

• Low bias models are complex and have high variance, but can overfit the data.

• Examples of high bias models are linear regression and decision trees with few nodes.

• Examples of lo...read more