XYZ Consultants India Data Manager Interview Questions and Answers

IT WAS Difficult and i gave up

Q1. Linked list search binary
Add your answer
Q2. Array search and traverse
Add your answer

Q1. Questions related to ml what is co relation personal questions rate yourself in excel What do you know about company.
Add your answer

Q1. Python basic codes
Add your answer
Q2. SQL query of aggregate function
Ans. 
SQL query using aggregate functions to perform calculations on a dataset
• Use aggregate functions like SUM, AVG, COUNT, MIN, MAX to perform calculations on a dataset

• Group data using GROUP BY clause to apply aggregate functions on specific groups

• Filter data using HAVING clause after applying aggregate functions
Answered by AI
Add your answer

English, quant, logical reasoning

Q1. Wacc, coc, beta
Add your answer
Q2. Coc, equity, capm
Add your answer

Q1. What is p value?
Ans. 
A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.
• A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

• A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.

• A p-value less than the significance level indicates st
Answered by AI
Add your answer
Q2. Tell the output a**2
Ans. 
The output of a**2 is the square of the value of a.
• The output is the value of a multiplied by itself

• For example, if a = 3, then the output would be 9 (3*3)
Answered by AI
Add your answer
Q3. Difference between append() and concat
Ans. 
append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.
• append() is a method used to add rows to a DataFrame.

• concat() is a function used to combine multiple DataFrames along a particular axis.

• append() modifies the original DataFrame, while concat() returns a new DataFrame.

• Example: df1.append(df2) vs pd.concat([df1, df2])
Answered by AI
Add your answer

Q1. Explain error handling in PySpark
Ans. 
Error handling in PySpark involves using try-except blocks and logging to handle exceptions and errors.
• Use try-except blocks to catch and handle exceptions in PySpark code

• Utilize logging to record errors and exceptions for debugging purposes

• Consider using the .option('mode', 'PERMISSIVE') method to handle corrupt records in data processing
Answered by AI
Add your answer

Q1. Data Warehousing related questions
Add your answer

Q1. Data Modelling related questions
Add your answer

Q1. Asked about skillsets & tools used in the current job. I was asked basic questions on SQL & Tableau
Add your answer

Detailed interview on SQL, Tableau & Alteryx