Deloitte SQL Data Analyst Interview Questions and Answers

Q1. What is spark,explain its ecosystem
Add your answer
Q2. What are transformations, and how many types of transformations exist?
Add your answer
Q3. Explain about spark job process and its planning
Add your answer
Q4. What are the concepts of coalesce and repartition in data processing?
Add your answer
Q5. Explain about oom and driverhead memory
Add your answer
Q6. What is data skewness
Add your answer

Q1. Sql order of execution
Ans. 
SQL order of execution determines the sequence in which different clauses are processed in a query.
• SQL query is parsed and validated first

• Next, the query optimizer creates an execution plan

• Execution plan includes steps like table scans, index scans, joins, etc.

• Finally, the query is executed and results are returned
Answered by AI
Add your answer
Q2. Sql question on finding highest salary for each employee where employees and department table are given in each department.
Add your answer

Normal aptitude round

Q1. SQL 4 QUESTION 1 BASIC 3 INTERMIDATE
Add your answer
Q2. DATA WAREHOUSE DETAILS ITS IMP THEY WORK ON THIS SO ASK ALL INFO ABOUT THIS
Add your answer

Q1. Project related discussions
Add your answer
Q2. Meduim level SQl and DSA
Add your answer

Q1. This was data modelling round
Add your answer
Q2. Design a uber data model
Ans. 
Uber data model design for efficient storage and retrieval of ride-related information.
• Create tables for users, drivers, rides, payments, and ratings

• Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

• Establish relationships between tables using foreign keys

• Implement indexing for faster query performance
Answered by AI
Add your answer

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Q1. What is DSA , sorting , difference between array and linked list
Ans. 
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
• DSA stands for Data Structures and Algorithms

• Sorting is the process of arranging data in a particular order

• Arra...read more
Answered by AI
Add your answer
Q2. Written a SQL query
Add your answer

Q1. Coding question like add numbers
Add your answer
Q2. Experience on your project
Ans. 
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
• Developed predictive models to forecast customer behavior and optimize marketing strategies

• Conducted market research to identify trends and opportunities for growth

• Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Answered by AI
Add your answer

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

Maxium sub string and reverse a string

Basic English, Quants and Statistics

Easy, relevant to pandemic

Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level
Add your answer

Q1. Behavioural Questions
Add your answer
Q2. Statistics Case Study
Add your answer