Ernst & Young Manager Interview Questions and Answers

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. Facts and dimensions are components of a star schema used in data warehousing.

• Normalization involves breaking down data into smaller, more manageable tables to reduce redundancy and improve data integrity.

• Facts are numerical data that can be analyzed, such as sales revenue or quantity sold.

• Dimensions are ...read more

I handle risk by conducting thorough risk assessments, developing mitigation strategies, and closely monitoring potential risks.

• Conducting thorough risk assessments to identify potential risks

• Developing mitigation strategies to minimize the impact of risks

• Closely monitoring potential risks and adjusting strategies as needed

Use CROSS JOIN to combine all rows from both tables

• Use CROSS JOIN to combine all rows from both tables

• Filter the results based on other conditions if needed

Random Forest is like a group decision-making process where multiple opinions are combined to make a final decision.

• Random Forest is a machine learning algorithm that builds multiple decision trees and merges them together to get a more accurate and stable prediction.

• Each decision tree in the Random Forest is trained on a random subset of the data and features, and then the final prediction is made by averaging th...read more

Estimating baseline of a demand prediction model involves analyzing historical data and trends to establish a starting point for future predictions.

• Collect and analyze historical demand data to identify patterns and trends

• Use statistical methods such as moving averages or exponential smoothing to calculate a baseline

• Consider external factors like seasonality, promotions, and market trends that may impact demand

• Val...read more

High availability orchestrator is a tool that ensures continuous availability of critical systems and applications.

• HA orchestrator is used to minimize downtime and ensure business continuity.

• It monitors the health of systems and applications and automatically switches to a backup system in case of failure.

• Examples of HA orchestrators include Kubernetes, Docker Swarm, and Apache Mesos.

• Orchestrator API is a set of p...read more

Data modeling techniques are used to create a visual representation of data and its relationships.

• Data modeling helps in understanding the data and its structure.

• It involves identifying entities, attributes, and relationships.

• Techniques include ER modeling, UML modeling, and dimensional modeling.

• Normalization is used to eliminate data redundancy.

• Data modeling is important for database design and development.