e-Zest Data Analyst Interview Questions and Answers

Coding test for all the student attending the first round, give your best practice every day all the best in your interview

Q1. What are your interest
Ans. 
My interests include data analysis, problem-solving, and continuous learning.
• Data analysis

• Problem-solving

• Continuous learning
Answered by AI
Add your answer
Q2. Java related question
Add your answer

Q1. What are SQL joins?
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them

• Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is normalisation?
Ans. 
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalisation involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy and inconsistencies

• It ensures data integrity and improves database performance

• Example: Splitting a customer table into separate tables for customer details and orders
Answered by AI
Add your answer

Q1. How to rotate a Matrix?
Ans. 
To rotate a matrix, transpose it and then reverse each row.
• Transpose the matrix by swapping elements across the diagonal

• Reverse each row of the transposed matrix to rotate it clockwise

• For example, to rotate a 3x3 matrix clockwise: [[1, 2, 3], [4, 5, 6], [7, 8, 9]] -> transpose -> [[1, 4, 7], [2, 5, 8], [3, 6, 9]] -> reverse rows -> [[7, 4, 1], [8, 5, 2], [9, 6, 3]]
Answered by AI
Add your answer

Q1. Mostly Dax and sql related questions
Add your answer
Q2. ETL related questions
Add your answer

Quantitive-train, boat ,speed and distance, profit lost ,permutation combination,
logical-blood relation ,seating arrangement ,coding and decoding,
verbal-sentence arrangement
total 20 questions-1/2 hr online test

Topic for Gd were on higher education vs job, ott vs theatre,social media

Q1. Resume base, palindrome, pattern strings
Add your answer
Q2. Logical questions on chess and ludo game logic behind it
Add your answer
Q3. Pattern question ,project
Add your answer

Q1. Explain the projects you worked on
Add your answer
Q2. Give the glance of your work and your role it.
Add your answer

Power bi SQL

Q1. Share details of your previous job.
Add your answer
Q2. What are your salary expectations?
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Where do you see yourself in 5 years?
Add your answer