Add office photos
Mu Sigma logo
Engaged Employer

Mu Sigma

Verified
2.6
based on 992 Reviews
Video summary
Filter interviews by
Designation
Fresher
Experienced
Skills

70+ Mu Sigma Interview Questions and Answers

Updated 21 Jan 2025
Popular Designations

Q1. Stats- Significance of Mean and Standard Deviation. Normal distribution, percentage distribution for every SD in Normal distribution

Ans.

Explanation of significance of mean and standard deviation in normal distribution.

  • Mean represents the central tendency of the data while standard deviation measures the spread of the data.

  • In a normal distribution, approximately 68% of the data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.

  • These percentages can be used to calculate the probability of a data point falling within a certain range of...read more

Add your answer
right arrow

Q2. The sales of apple is going down. What might be the cause?

Ans.

The cause of decreasing sales of apple.

  • Seasonal fluctuations

  • Increased competition

  • Change in consumer preferences

  • Supply chain issues

Add your answer
right arrow
Mu Sigma Interview Questions and Answers for Freshers
illustration image

Q3. Guestimate: Estimate the number of sweet shops in your city

Ans.

There are approximately 500 sweet shops in my city.

  • The number of sweet shops may vary depending on the size of the city.

  • Factors such as population density and cultural preferences may also affect the number of sweet shops.

  • A rough estimate can be made by dividing the population by the number of sweet shops per capita in similar cities.

  • Alternatively, a survey or data analysis of existing sweet shops can provide a more accurate estimate.

Add your answer
right arrow

Q4. What are the methods used to store and analyze data before the existence of tools such as Excel

Ans.

Before Excel, data was stored and analyzed using manual methods.

  • Data was stored in physical files such as paper documents or index cards.

  • Analysis was done manually using tools such as calculators or statistical tables.

  • Data was often organized using charts or graphs.

  • Data entry was done by hand, which was time-consuming and prone to errors.

Add your answer
right arrow
Discover Mu Sigma interview dos and don'ts from real experiences

Q5. how you would fix the ticket price for a play in an auditorium

Ans.

Ticket price for a play in an auditorium

  • Analyze the production cost and expected revenue

  • Consider the target audience and their willingness to pay

  • Research the ticket prices of similar plays in the area

  • Offer discounts for early bird or group bookings

  • Adjust the price based on demand and availability

Add your answer
right arrow

Q6. What's the CI/CD workflow that's followed in your team?

Ans.

Our team follows a CI/CD workflow that includes automated testing, code reviews, and continuous integration.

  • Automated testing is run on every code change to catch bugs early.

  • Code reviews are conducted before merging changes to ensure code quality.

  • Continuous integration is used to automatically build and test code changes in a shared repository.

  • Deployment pipelines are set up to automate the release process.

  • Version control is used to track changes and manage codebase effective...read more

Add your answer
right arrow
Are these interview questions helpful?

Q7. What is the difference between data and data source?

Ans.

Data is the information collected and stored, while data source is the origin or location from which the data is obtained.

  • Data is the raw facts and figures that are collected and stored for analysis.

  • Data source is the location or system from which the data is collected, such as a database, sensor, or survey.

  • Examples of data sources include customer surveys, website analytics, and social media platforms.

Add your answer
right arrow

Q8. Design a document managed storage like google drive as an E2E solution.

Ans.

Design a document managed storage like Google Drive as an E2E solution.

  • Implement user authentication and authorization for secure access.

  • Create a user-friendly interface for uploading, organizing, and sharing documents.

  • Include features like version control, file syncing, and search functionality.

  • Utilize cloud storage for scalability and accessibility.

  • Implement encryption for data security.

  • Integrate with third-party apps for enhanced functionality.

Add your answer
right arrow
Share interview questions and help millions of jobseekers 🌟
man with laptop

Q9. Difference between authorization and authentication ?

Ans.

Authentication verifies the identity of a user, while authorization determines what actions a user is allowed to perform.

  • Authentication confirms the identity of a user through credentials like passwords or biometrics.

  • Authorization determines the level of access or permissions a user has once their identity is confirmed.

  • Authentication is the process of logging in, while authorization is the process of granting or denying access to resources.

  • Example: Logging into a bank account...read more

Add your answer
right arrow

Q10. Why is Power BI and Tableau used for?

Ans.

Power BI and Tableau are used for data visualization and business intelligence purposes.

  • They help in creating interactive dashboards and reports.

  • They allow users to analyze and explore data in a visual format.

  • They can connect to various data sources and transform data for analysis.

  • They provide features like data filtering, sorting, and aggregation.

  • They enable users to share insights and collaborate with others.

  • Example: Power BI can be used to create a sales dashboard that sho...read more

View 1 answer
right arrow

Q11. Why do you want to work with analytical data?

Ans.

I am passionate about uncovering insights and patterns in data to drive informed decision-making.

  • I enjoy working with numbers and finding trends in data sets.

  • Analyzing data allows me to make strategic decisions based on evidence rather than intuition.

  • I find satisfaction in solving complex problems using statistical methods and algorithms.

Add your answer
right arrow

Q12. difference between Stats and Data analysis

Ans.

Stats focuses on summarizing and interpreting data, while data analysis involves exploring and drawing insights from data.

  • Statistics involves collecting, organizing, analyzing, and interpreting data to make informed decisions.

  • Data analysis involves cleaning, transforming, and visualizing data to discover patterns, trends, and insights.

  • Statistics uses mathematical formulas and techniques to summarize data, such as mean, median, and standard deviation.

  • Data analysis uses tools l...read more

Add your answer
right arrow

Q13. LLD for an authentication and authorization system

Ans.

LLD for an authentication and authorization system

  • Separate modules for authentication and authorization

  • Use of secure hashing algorithms for storing passwords

  • Role-based access control implementation

  • Audit logging for tracking user actions

  • Integration with external identity providers

Add your answer
right arrow

Q14. Explain what i did in house price model

Ans.

I developed a predictive model to estimate house prices based on various factors.

  • Collected and cleaned data on house features, location, and sale prices

  • Performed exploratory data analysis to identify key variables impacting house prices

  • Built and trained machine learning models such as linear regression or random forest

  • Evaluated model performance using metrics like RMSE or R-squared

  • Used the model to make predictions on new data and assess accuracy

Add your answer
right arrow

Q15. What is data science, and why are you interested in this company?

Ans.

Data science involves extracting insights from data to make informed decisions. I am interested in this company because of its reputation for using cutting-edge data science techniques.

  • Data science is the process of analyzing and interpreting complex data to make informed decisions

  • It involves using various techniques such as machine learning, statistical analysis, and data visualization

  • Companies use data science to improve decision-making, optimize processes, and gain a compe...read more

Add your answer
right arrow

Q16. order of executuion of SQL query

Ans.

SQL queries are executed in a specific order to ensure accurate results.

  • SQL queries are executed in the following order: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

  • The SELECT clause is always executed first to retrieve the specified columns.

  • The FROM clause is then executed to specify the tables from which to retrieve data.

  • The WHERE clause filters the rows based on specified conditions.

  • The GROUP BY clause groups the rows based on specified columns.

  • The HAVING clause filter...read more

Add your answer
right arrow

Q17. What is Data and Why Mu Sigma

Ans.

Data is information collected and analyzed for decision-making. Mu Sigma is a leading analytics company.

  • Data is raw facts and figures that can be processed to gain insights.

  • Mu Sigma is a data analytics company that helps businesses make data-driven decisions.

  • Data can come in various forms such as structured, unstructured, and semi-structured.

  • Mu Sigma uses advanced analytics techniques like machine learning and AI to extract valuable insights from data.

  • Data is essential for bu...read more

Add your answer
right arrow

Q18. What is the difference between random forest and decision tree

Ans.

Random forest is an ensemble learning method that uses multiple decision trees to make predictions, while a decision tree is a single tree-like structure that makes decisions based on features.

  • Random forest is a collection of decision trees that work together to make predictions.

  • Decision tree is a single tree-like structure that makes decisions based on features.

  • Random forest reduces overfitting by averaging the predictions of multiple trees.

  • Decision tree can be prone to over...read more

Add your answer
right arrow

Q19. Explain regression. What is database. What is machine learning.

Ans.

Regression is a statistical method to analyze the relationship between variables. A database is a collection of organized data. Machine learning is a field of AI that enables systems to learn from data.

  • Regression is a statistical technique used to understand the relationship between variables.

  • A database is a structured collection of data that is stored and accessed electronically.

  • Machine learning is a subset of artificial intelligence that focuses on developing algorithms and...read more

Add your answer
right arrow

Q20. No. of coffees sold by CCD in a day

Ans.

The number of coffees sold by CCD in a day varies depending on the location, day of the week, and time of day.

  • The number of coffees sold may be higher on weekdays than weekends

  • The number of coffees sold may be higher in the morning than in the afternoon or evening

  • The number of coffees sold may vary depending on the location of the CCD outlet

  • The number of coffees sold may be affected by seasonal factors such as weather

  • The number of coffees sold may be influenced by promotional...read more

Add your answer
right arrow

Q21. No. of crows in Mumbai?

Ans.

It is impossible to accurately determine the number of crows in Mumbai.

  • There is no official census of crows in Mumbai.

  • Crows are highly mobile and can move between different areas of the city.

  • The population of crows can fluctuate based on factors such as food availability and weather conditions.

  • Estimates of the number of crows in Mumbai range from a few thousand to several hundred thousand.

Add your answer
right arrow

Q22. case steady of vodafone idea

Ans.

Vodafone Idea is a telecom company in India facing financial challenges due to intense competition and regulatory issues.

  • Vodafone Idea is struggling to compete with other telecom companies in India such as Reliance Jio and Bharti Airtel.

  • The company has a large debt burden and has been unable to raise funds due to regulatory issues.

  • Vodafone Idea has been losing subscribers and market share due to poor network quality and customer service.

  • The Indian government has recently anno...read more

Add your answer
right arrow

Q23. What problem does ML solve

Ans.

ML solves complex problems by analyzing data and making predictions or decisions based on patterns and trends.

  • ML can solve problems related to prediction, classification, clustering, anomaly detection, and recommendation.

  • Examples include predicting customer churn, classifying spam emails, clustering similar customer segments, detecting fraudulent transactions, and recommending products based on user behavior.

  • ML can automate tasks that are too complex or time-consuming for hum...read more

Add your answer
right arrow

Q24. No. of swifts sold in Mumbai

Ans.

I don't have the available data to answer this question.

  • Sorry, I don't have access to the sales data for swifts in Mumbai.

  • Without the data, it's impossible to provide an accurate answer.

Add your answer
right arrow

Q25. python code using recursion

Ans.

Python code using recursion

  • Recursion is a technique in which a function calls itself to solve a problem

  • Base case is important to prevent infinite recursion

  • Example: Factorial calculation using recursion - def factorial(n): return 1 if n == 0 else n * factorial(n-1)

Add your answer
right arrow

Q26. Do you know to write formal emails?

Ans.

Yes, I am proficient in writing formal emails.

  • Use a professional tone and language

  • Include a clear subject line

  • Address the recipient respectfully

  • Proofread for grammar and spelling errors

  • Sign off appropriately with your name and contact information

Add your answer
right arrow

Q27. What is inheritance?

Ans.

Inheritance is the mechanism in object-oriented programming where a new class inherits attributes and methods from an existing class.

  • Inheritance allows for code reusability and promotes the concept of hierarchical classification.

  • The class that is being inherited from is called the parent class or superclass, while the class that inherits is called the child class or subclass.

  • Subclasses can add new attributes or methods, or override existing ones from the superclass.

  • Example: A...read more

Add your answer
right arrow

Q28. why musigma? 

Ans.

I chose MuSigma because of its reputation as a leading analytics firm and its focus on innovation and problem-solving.

  • MuSigma has a strong track record of delivering impactful solutions to clients across industries.

  • The company values creativity and encourages employees to think outside the box.

  • MuSigma provides ample opportunities for professional growth and development.

  • The company culture is collaborative and supportive, with a focus on teamwork and knowledge-sharing.

  • MuSigma'...read more

Add your answer
right arrow

Q29. Different types of Sql joins

Ans.

Different types of SQL joins include inner join, left join, right join, and full outer join.

  • Inner join: Returns rows when there is a match in both tables

  • Left join: Returns all rows from the left table and the matched rows from the right table

  • Right join: Returns all rows from the right table and the matched rows from the left table

  • Full outer join: Returns rows when there is a match in either table

Add your answer
right arrow

Q30. Types of Joins in SQL

Ans.

Types of joins in SQL include inner join, left join, right join, and full outer join.

  • Inner join: Returns rows when there is a match in both tables

  • Left join: Returns all rows from the left table and the matched rows from the right table

  • Right join: Returns all rows from the right table and the matched rows from the left table

  • Full outer join: Returns rows when there is a match in either table

Add your answer
right arrow

Q31. Approach to a problem statement

Ans.

My approach to a problem statement involves understanding the problem, gathering data, analyzing the data, and developing a solution.

  • Understand the problem statement thoroughly

  • Gather relevant data and information

  • Analyze the data to identify patterns and insights

  • Develop a solution based on the analysis

  • Test and refine the solution as needed

Add your answer
right arrow

Q32. What is the summary of the TED Talk featured in the YouTube video that was shown during the interview?

Ans.

The TED Talk discussed the impact of artificial intelligence on society and the importance of ethical considerations in AI development.

  • Speaker emphasized the need for ethical guidelines in AI to prevent negative consequences.

  • Discussed examples of AI bias and discrimination in algorithms.

  • Highlighted the potential benefits of AI in various industries.

  • Suggested ways to ensure responsible AI development and deployment.

Add your answer
right arrow

Q33. Back propagation in neural network

Ans.

Back propagation is a supervised learning algorithm used to train neural networks.

  • It is used to adjust the weights of the neural network to minimize the error between the predicted output and the actual output.

  • It involves propagating the error backwards from the output layer to the input layer, and adjusting the weights accordingly.

  • It uses the chain rule of calculus to calculate the gradient of the error with respect to the weights.

  • It is an iterative process that continues un...read more

Add your answer
right arrow

Q34. Write a query to find the nth largest salary ?

Ans.

Query to find the nth largest salary in a database table.

  • Use the ORDER BY clause to sort the salaries in descending order.

  • Use the LIMIT clause to specify the nth largest salary.

  • Consider handling cases where there may be ties for the nth largest salary.

Add your answer
right arrow

Q35. Reverse the string

Ans.

Reverse a given string

  • Use built-in functions like reverse() or loop through the string

  • Create a new string and add characters in reverse order

  • Handle edge cases like empty string or single character

Add your answer
right arrow

Q36. What is Linked list, explain doubly traversable linked list.

Ans.

A linked list is a data structure that stores a sequence of elements. A doubly traversable linked list allows traversal in both directions.

  • Linked list is a collection of nodes where each node contains a data field and a reference to the next node.

  • Doubly traversable linked list has an additional reference to the previous node.

  • Traversal can be done in both directions using the next and previous references.

  • Example: Doubly linked list can be used to implement a browser's forward ...read more

Add your answer
right arrow

Q37. What is cost function

Ans.

A cost function is a mathematical formula used to measure the cost of a particular decision or set of decisions.

  • Cost function helps in evaluating the performance of a model by measuring how well it is able to predict the outcomes.

  • It is used in optimization problems to find the best solution that minimizes the cost.

  • Examples include mean squared error in linear regression and cross-entropy loss in logistic regression.

Add your answer
right arrow

Q38. Q. What is joints? Q. What is linear search? Q. What is your hobby?

Ans.

Joints are connections between bones that allow movement and provide support to the body.

  • Joints are found throughout the body, such as the knee, elbow, and shoulder.

  • They are made up of bones, cartilage, ligaments, and synovial fluid.

  • Joints enable various types of movements, including flexion, extension, rotation, and abduction.

  • Different types of joints include hinge joints, ball-and-socket joints, and pivot joints.

  • Joint problems can lead to conditions like arthritis and joint...read more

Add your answer
right arrow

Q39. Guesstimate: Potatoes sold in South India

Ans.

Guesstimate the number of potatoes sold in South India.

  • Consider the population of South India and their consumption habits.

  • Research the average per capita consumption of potatoes in India.

  • Take into account the demand for potatoes in various industries like restaurants, hotels, and households.

  • Consider the potato production and import/export data in South India.

  • Factor in the seasonal variations in potato consumption.

  • Consult with agricultural experts or market analysts for more ...read more

Add your answer
right arrow

Q40. Tell me about Chennai.. its 4 yrs u have been here so you might have gain much about this place..tel me a few u liked and disliked!

Add your answer
right arrow

Q41. What is joints and what is your hobby?

Ans.

I'm not sure how joints relate to data science, but my hobby is playing guitar.

  • Joints can refer to the connection between two bones in the body or the way two things are connected or joined together.

  • Playing guitar is a hobby that helps me relax and unwind after a long day of working with data.

  • While seemingly unrelated to data science, playing an instrument can actually improve cognitive function and creativity, which can be beneficial in the field.

Add your answer
right arrow

Q42. What is mean, median, mode, etc?

Ans.

Mean, median, and mode are measures of central tendency used in statistics.

  • Mean is the average of a set of numbers. It is calculated by adding all the numbers and dividing by the total count.

  • Median is the middle value in a set of numbers. It is calculated by arranging the numbers in order and finding the middle value.

  • Mode is the most frequently occurring value in a set of numbers.

  • These measures are used to describe the typical or central value of a set of data.

  • For example, if...read more

Add your answer
right arrow

Q43. Explain the recent project

Ans.

Developed a predictive model for customer churn in a telecom company

  • Collected and cleaned customer data including usage patterns and demographics

  • Used machine learning algorithms such as logistic regression and random forest

  • Evaluated model performance using metrics like accuracy and AUC-ROC curve

Add your answer
right arrow

Q44. Tell me something you know about the current technologies in demand.

Add your answer
right arrow

Q45. explain the 4 pillars of oops concepts in java with examples

Ans.

The 4 pillars of OOPs concepts in Java are Abstraction, Encapsulation, Inheritance, and Polymorphism.

  • Abstraction: Hiding implementation details and showing only necessary information. Example: Abstract class

  • Encapsulation: Wrapping data and code into a single unit. Example: Private variables and methods

  • Inheritance: Acquiring properties and behavior of a parent class. Example: Child class inheriting from a parent class

  • Polymorphism: Ability of an object to take many forms. Examp...read more

Add your answer
right arrow

Q46. Video analysis. Summarize the video in bullet points.

Ans.

Video analysis involves summarizing the content of a video in bullet points.

  • Identify key themes or topics discussed in the video

  • Highlight important events or moments

  • Note any key statistics or data presented

  • Summarize the main conclusions or takeaways

  • Include any notable visuals or graphics shown

Add your answer
right arrow

Q47. What do you know about mu Sigma?

Ans.

Mu Sigma is a data analytics and decision sciences company that helps organizations make data-driven decisions.

  • Mu Sigma was founded in 2004 and is headquartered in Chicago, Illinois.

  • They provide services in areas such as marketing analytics, supply chain analytics, and risk analytics.

  • Mu Sigma has worked with Fortune 500 companies across various industries to help them leverage data for better decision-making.

  • The company uses a proprietary platform called muApt for analytics a...read more

Add your answer
right arrow

Q48. What is Mitre attack framework and explain its tactics?

Add your answer
right arrow

Q49. why mu sigma and diff bwten desicion and data science

Ans.

Mu Sigma is a decision sciences and analytics company that focuses on solving complex business problems using data science.

  • Mu Sigma is a company that specializes in decision sciences and analytics, using data science to solve complex business problems.

  • Decision sciences involve making strategic decisions based on data analysis, while data science focuses on extracting insights from data using various techniques.

  • Mu Sigma combines decision sciences and data science to provide ac...read more

Add your answer
right arrow

Q50. What kinds of data have you worked with

Ans.

I have worked with various types of data including customer demographics, sales figures, website traffic, and social media engagement.

  • Customer demographics

  • Sales figures

  • Website traffic

  • Social media engagement

Add your answer
right arrow

Q51. explain the difference between equals and == difference in java

Ans.

Equals method compares the content of objects while == compares the reference of objects in Java.

  • Equals method is used to compare the content of two objects in Java.

  • == operator is used to compare the reference of two objects in Java.

  • Equals method is overridden in most of the classes to provide meaningful comparison.

  • Example: String s1 = new String("Hello"); String s2 = new String("Hello"); s1.equals(s2) will return true while s1 == s2 will return false.

Add your answer
right arrow

Q52. Preferred Location

Ans.

I am open to working in any location that offers opportunities for growth and learning.

  • Open to relocation for the right opportunity

  • Interested in diverse locations for new experiences

Add your answer
right arrow

Q53. sort by and order by difference

Ans.

Sort by is used to arrange data in a specific order, while order by is used to specify the sorting order in SQL queries.

  • Sort by is used in programming languages to arrange data based on a specific criteria

  • Order by is used in SQL queries to specify the sorting order of the result set

  • Sort by is more commonly used in programming languages like Python, while order by is used in SQL queries

Add your answer
right arrow

Q54. Problem statement of a case that needs solutions.

Ans.

Develop a predictive model to identify potential customers for a new product launch.

  • Define the target variable and features to be used in the model

  • Collect and preprocess relevant data for training the model

  • Select an appropriate machine learning algorithm and train the model

  • Evaluate the model's performance using metrics like accuracy, precision, and recall

  • Use the model to predict potential customers for the new product launch

Add your answer
right arrow

Q55. What you know about Pharma industry?

Ans.

The Pharma industry is involved in the research, development, production, and marketing of pharmaceutical drugs.

  • Pharma industry focuses on developing and producing medications for various health conditions.

  • It involves extensive research and clinical trials to ensure the safety and efficacy of drugs.

  • Pharmaceutical companies market their products to healthcare professionals and consumers.

  • Regulatory bodies such as the FDA oversee the approval and monitoring of pharmaceutical pro...read more

Add your answer
right arrow

Q56. What is JIT compilation

Ans.

JIT compilation stands for Just-In-Time compilation, a technique used by some programming languages to improve performance.

  • JIT compilation compiles code at runtime instead of ahead of time

  • It can improve performance by optimizing code based on runtime information

  • JIT compilation is used in languages like Java, .NET, and JavaScript

  • Examples of JIT compilers include HotSpot for Java and V8 for JavaScript

Add your answer
right arrow

Q57. What is subjects in observable

Ans.

Subjects in observable are streams of data that emit values over time.

  • Subjects are both an observer and an observable

  • They can multicast data to multiple subscribers

  • They can emit new values using next() method

  • Example: BehaviorSubject, ReplaySubject, AsyncSubject

Add your answer
right arrow

Q58. How to increase the revenue of a company

Ans.

To increase revenue, a company can focus on increasing sales, reducing costs, expanding into new markets, and improving customer satisfaction.

  • Increase sales through targeted marketing and sales strategies

  • Reduce costs by optimizing operations and negotiating better deals with suppliers

  • Expand into new markets by conducting market research and developing new products or services

  • Improve customer satisfaction by providing excellent customer service and addressing customer feedback...read more

Add your answer
right arrow

Q59. Abt prjct and which tools u have used

Ans.

I have worked on a project analyzing customer behavior using Python, SQL, and Tableau.

  • Utilized Python for data cleaning and analysis

  • Used SQL for querying databases

  • Created visualizations in Tableau to present findings

Add your answer
right arrow

Q60. what fifo? diff btwn fifo and lifo

Ans.

FIFO stands for First In, First Out. LIFO stands for Last In, First Out.

  • FIFO is a method for organizing and manipulating a data buffer, where the first element added is the first to be removed.

  • LIFO is a method where the last element added is the first to be removed.

  • FIFO is like a queue, while LIFO is like a stack.

  • Example: In a FIFO queue, if elements A, B, and C are added in that order, they will be removed in the same order.

  • Example: In a LIFO stack, if elements X, Y, and Z a...read more

Add your answer
right arrow

Q61. Joins in SQL, order of execution

Ans.

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

  • Joins are executed after the FROM clause and before the WHERE clause in SQL queries.

  • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

  • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Add your answer
right arrow

Q62. Difference between list and tuple

Ans.

List is mutable and can be changed, while tuple is immutable and cannot be changed.

  • List is defined using square brackets [], while tuple is defined using parentheses ().

  • Elements in a list can be modified, added, or removed, while elements in a tuple cannot be changed once defined.

  • Lists are typically used when the order of elements matters and when elements need to be modified, while tuples are used when immutability is desired.

  • Example: list_example = [1, 2, 3], tuple_example ...read more

Add your answer
right arrow

Q63. explain hadoop ecosystem

Ans.

Hadoop ecosystem is a collection of open-source software tools used for distributed storage and processing of big data.

  • Hadoop Distributed File System (HDFS) for storage

  • MapReduce for processing

  • Apache Hive for data warehousing

  • Apache Pig for data analysis

  • Apache Spark for real-time processing

  • Apache HBase for NoSQL database

  • Apache Kafka for real-time data streaming

Add your answer
right arrow

Q64. explain YARN architecture

Ans.

YARN architecture is a resource management layer in Hadoop ecosystem for job scheduling and cluster resource management.

  • YARN stands for Yet Another Resource Negotiator.

  • It consists of ResourceManager, NodeManager, ApplicationMaster, and Container.

  • ResourceManager manages resources and schedules applications.

  • NodeManager runs on each node and manages resources available on that node.

  • ApplicationMaster negotiates resources with ResourceManager and monitors application execution.

  • Con...read more

Add your answer
right arrow

Q65. optimization techniques

Ans.

Optimization techniques are methods used to improve the efficiency and performance of data processing.

  • Use indexing to speed up data retrieval

  • Implement caching to reduce redundant computations

  • Utilize parallel processing for faster execution

  • Optimize algorithms for better performance

  • Use data compression techniques to reduce storage space

Add your answer
right arrow

Q66. python code for data frames

Ans.

Python code for data frames in pandas library

  • Import pandas library

  • Create a data frame using pd.DataFrame()

  • Access and manipulate data using various methods like loc, iloc, and groupby

Add your answer
right arrow

Q67. Sql order of execution

Ans.

SQL order of execution determines the sequence in which different clauses are processed in a query.

  • SQL order of execution: FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY.

  • Joins are processed before WHERE clause.

  • Aggregate functions are processed after WHERE clause but before SELECT clause.

  • Subqueries are processed from innermost to outermost.

Add your answer
right arrow

Q68. Explain K8s Architecture

Ans.

K8s Architecture refers to the structure and components of Kubernetes, an open-source container orchestration platform.

  • Kubernetes follows a master-slave architecture with a master node and multiple worker nodes.

  • Master node components include API server, scheduler, controller manager, and etcd.

  • Worker nodes run pods which contain containers.

  • Kubernetes uses labels and selectors to manage and organize resources.

  • K8s architecture allows for scalability, high availability, and autom...read more

Add your answer
right arrow

Q69. Explain Jenkins pipeline

Ans.

Jenkins pipeline is a set of plugins that allow for the automation of building, testing, and deploying code.

  • Jenkins pipeline is defined as a suite of plugins that support implementing and integrating continuous delivery pipelines.

  • It allows for defining the entire build process as code, which can be version controlled and shared.

  • Pipeline stages can include building, testing, deploying, and other tasks, with each stage being customizable and scriptable.

  • Pipeline scripts can be w...read more

Add your answer
right arrow

Q70. Pharma in United States

Ans.

Pharma industry in the United States is a major player in the global market, with a focus on research, development, and regulation of pharmaceutical products.

  • The United States is home to many pharmaceutical companies such as Pfizer, Merck, and Johnson & Johnson.

  • The FDA (Food and Drug Administration) plays a crucial role in regulating the pharmaceutical industry in the US.

  • Research and development in the pharma sector is a key driver of innovation and growth.

  • The US pharma marke...read more

Add your answer
right arrow

Q71. random forest tell me

Ans.

Random forest is an ensemble learning method used for classification and regression tasks.

  • Random forest is a collection of decision trees that are trained on random subsets of the data.

  • Each tree in the random forest independently predicts the target variable, and the final prediction is made by averaging the predictions of all trees.

  • Random forest is known for its high accuracy and ability to handle large datasets with high dimensionality.

  • It is also capable of handling missing...read more

Add your answer
right arrow

Q72. Likes nd dislike

Ans.

I enjoy reading, hiking, and trying new foods. I dislike rude people and cold weather.

  • Likes: reading, hiking, trying new foods

  • Dislikes: rude people, cold weather

Add your answer
right arrow

Q73. explain oops concept

Ans.

OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.

  • OOP focuses on creating objects that interact with each other to solve problems.

  • Key concepts include classes, objects, inheritance, polymorphism, and encapsulation.

  • Classes are blueprints for creating objects, while objects are instances of classes.

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

  • Polymorp...read more

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Mu Sigma

based on 175 interviews
Interview experience
3.8
Good
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

Ernst & Young Logo
3.4
 • 653 Interview Questions
Mahindra & Mahindra Logo
4.1
 • 401 Interview Questions
American Express Logo
4.2
 • 191 Interview Questions
ABB Logo
4.1
 • 160 Interview Questions
Zomato Logo
3.8
 • 150 Interview Questions
TVS Motor Logo
4.0
 • 137 Interview Questions
View all
Recently Viewed
SALARIES
Mu Sigma
INTERVIEWS
Serco
No Interviews
LIST OF COMPANIES
EXL Service
Locations
REVIEWS
CorroHealth
No Reviews
REVIEWS
Mu Sigma
No Reviews
INTERVIEWS
Serco
No Interviews
REVIEWS
Mu Sigma
No Reviews
REVIEWS
CorroHealth
No Reviews
REVIEWS
CorroHealth
No Reviews
SALARIES
CorroHealth
Top Mu Sigma Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter