EnFuse Solutions Data Management Associate Interview Questions and Answers

Basic python questions

Q1. Explain Order of execution in SQL
Ans. 
Order of execution in SQL determines the sequence in which different clauses are processed in a query.
• SQL query is processed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• FROM clause is processed first to retrieve data from tables.

• WHERE clause filters the data based on specified conditions.

• GROUP BY clause groups the data based on specified columns.

• HAVING clause filters the grouped data.

• SELECT ...read more
Answered by AI
Add your answer
Q2. Sumifs function
Add your answer
Q3. Boxplots?Histograms?
Add your answer

Q1. Joins and null value handling
Add your answer
Q2. Tableau server in depth
Ans. 
Tableau Server is a business intelligence tool that allows organizations to share and collaborate on data visualizations.
• Tableau Server is a platform for sharing and distributing Tableau workbooks and dashboards.

• It allows users to access and interact with visualizations through a web browser.

• Administrators can manage permissions, schedules, and data sources on Tableau Server.

• Tableau Server can be integrated with other ...read more
Answered by AI
Add your answer

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
Answered Anonymously
View 1 more amswer
Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Add your answer

Q1. Power bi and tableau
Add your answer

Python problem questions
SQL problem questions

Q1. 1. Difference between shallow copy and deep copy 2. How can you merge two dataframes with different column names 3. Regex question to find all the characters and numbers of particular length size 4. Spark ...read more
Ans. 
1. Shallow copy creates a new object but does not duplicate nested objects. Deep copy creates a new object and duplicates all nested objects. 2. Merging dataframes with different column names requires renaming columns. 3. Regex can be used to find characters and numbers of a specific length. 4. Spark fundamentals involve understanding distributed computing and data processing.
• Shallow copy: new object with same referenc...read more
Answered by AI
Add your answer

Q1. 1. Design data architecture for a particular scenario 2. Spark optimisation questions for the given scenario
Add your answer

Q1. This was my director round where all the business related ettiquitess, emotional quotient and plans to remain in the society.
Add your answer

Q1. Basic salary discussion and company policies
Add your answer

Q1. Tell me about your self
Add your answer
Q2. What is Vlookup with formula
Ans. 
Vlookup is a function in Excel that searches for a value in a table and returns a corresponding value in the same row.
• Vlookup stands for 'Vertical Lookup'

• It is used to find specific information in a table

• It requires a lookup value, a table array, column index number, and an optional range lookup

• Example: =VLOOKUP(A2, B2:C10, 2, FALSE) will search for the value in A2 in the table array B2:C10 and return the value in the ...read more
Answered by AI
Add your answer

Numerical reagioning l0gical

Age related solving cubes related

Discussion ingroup to solving problems