Optum Business Analyst Interview Questions and Answers

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

Find the heavier ball out of 8 using a weighing balance in minimum and maximum attempts.

• Divide the balls into 3 groups of 3, 3, and 2.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group.

• If one group is heavier, weigh two balls from that group against each other.

• If they balance, the heavier ball is the remaining one.

• If one ball is heavier, that is the answer.

• In the worst...read more

In 3 attempts, the heavier ball can be found using the weighing balance.

• Divide the balls into 3 groups of 3, 3, and 5 balls.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group. Weigh two balls from the third group against each other to find the heavier one.

• If they don't balance, the heavier ball is in the heavier group. Take two balls from the heavier group and weigh th

Use a binary search approach to find the heavier ball among 'n' balls using a weighing balance.

• Divide the 'n' balls into two equal groups and weigh them on the balance.

• If one group is heavier, repeat the process with that group.

• If both groups weigh the same, the heavier ball is among the remaining unweighed balls.

• Continue dividing and weighing until the heavier ball is found.

The number of soft drinks sold in J&K on a particular day depends on various factors such as population, demand, availability, and marketing strategies.

• The population of J&K can be a factor in determining the potential number of soft drink sales.

• The demand for soft drinks can vary based on factors such as weather, events, and cultural preferences.

• The availability of soft drinks in J&K, including distribution channels a...read more

Estimating the market size of 4K and 8K display screens.

• Analyze sales data and market research reports

• Consider the adoption rate of 4K and 8K technology

• Evaluate the market demand from various industries (entertainment, gaming, advertising, etc.)

• Assess the pricing and availability of 4K and 8K displays

• Factor in the growth potential and competition in the market

The Indian deodorant market is a growing industry with a large consumer base and increasing demand for premium and natural products.

• The deodorant market in India has been experiencing steady growth over the years.

• The market is driven by factors such as increasing disposable income, urbanization, and changing lifestyles.

• There is a growing awareness among consumers about personal hygiene and grooming, leading to higher d...read more

Approximately 50,000 tractors are sold in Haryana every year.

• Consider the population of Haryana and the number of farmers in the state.

• Look at the agricultural output of Haryana and the demand for tractors in the region.

• Take into account the number of tractor dealerships in Haryana and their sales figures.

• Research the sales figures of major tractor manufacturers in Haryana.

• Assume a growth rate based on the previous yea...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 exact number of Facebook users worldwide is constantly changing, but as of October 2021, there are over 2.8 billion monthly active users.

• As of October 2021, Facebook reported having over 2.8 billion monthly active users.

• The number of Facebook users is constantly changing as new users join and others deactivate or delete their accounts.

• Facebook's user base is spread across different countries and demographics.

• The nu...read more

VLOOKUP is a function in Excel used to search for a value in the first column of a range and return a corresponding value from another column.

• VLOOKUP stands for vertical lookup.

• It is commonly used to find specific data in large datasets.

• The function takes four arguments: lookup value, table array, column index number, and range lookup.

• VLOOKUP is case-insensitive and requires an exact match or an approximate match.

• The f...read more