Zupee Data Analyst Interview Questions and Answers

Q1. What is the difference between Union and Union all ?
Ans. 
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
• Union removes duplicate rows from the result set, while Union all includes all rows.

• Union sorts the result set, while Union all does not.

• Union is slower than Union all because it performs a distinct operation.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FRO
Answered by AI
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Contained aptitude test with both numericals as well as coding questions

It was a one on one round

Q1. Final discussion
Add your answer
Q2. If ready to relocate
Ans. 
Yes, I am open to relocation for the right opportunity.
• I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.

• I am open to exploring new cities and cultures.

• I understand that relocation may come with some challenges, but I am prepared to face them.

• I am excited about the prospect of working with a new team and contributing to the success of the company.
Answered by AI
Add your answer

SQL based leetcode medium and hackerrank

Python take home EDA case study assessment

Q1. SQL based questions
Add your answer
Q2. Guesstimate on estimating # users on the application
Ans. 
Estimate the number of users on the application based on market research, user demographics, and industry trends.
• Consider the total addressable market (TAM) for the application

• Analyze user demographics and behavior to estimate adoption rate

• Look at industry benchmarks and competitor data for reference

• Use surveys, focus groups, and user feedback to gather insights

• Consider factors like market saturation, growth potential,
Answered by AI
Add your answer

Q1. Write a sql query
Ans. 
SQL query to retrieve employee names and their salaries from a table
• Use SELECT statement to retrieve data

• Specify the columns you want to retrieve (employee names and salaries)

• Specify the table name where the data is stored
Answered by AI
Add your answer
Q2. Formula of vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
• VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...read more
Answered by AI
Add your answer

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Ans. 
ACID properties ensure data integrity in DBMS: Atomicity, Consistency, Isolation, Durability.
• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that multiple transactions can be executed concurrently without affecting each other.

• Durability ensures that once...read more
Answered by AI
Add your answer

Q1. HR question and family background
Add your answer

It was a coding round with sql ,python questions , few aptitude questions

Q1. They asked few questions sql and python and few questions - depending on the role
Add your answer
Q2. BASIC SQL WHAT YOU HAD WRITTEN IN THE CODE
Add your answer

Q1. They asked me few questions related to sql
Add your answer
Q2. BASIC PYTHON QUESTIONS LIKE WHAT YOU HAVE WRITTEN IN THE CODE
Add your answer

Q1. About yourself , your hobby etc
Add your answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo