ZS Business Technology Associate Interview Questions, Process, and Tips

Prepare some guesstimate questions and some SQL questions

Basic aptitude test but the key was time management.

Q1. Basic questions related to English, essay writing, they test your listening and speaking skills.
Add your answer

In the coding test, they asked questions related to Python and SQL query writing

Q1. The technical interview was online which happened on the superset platform. The first question was to introduce yourself. Then 3 questions on puzzles (gfg), 3 questions from SQL query writing and then some...read more
Add your answer

Sql and Data Engineering based.

Q1. Asked about sql basics
Add your answer

Logical, verbal, quant questions

SQL questions, 1 coding question

Q1. Tell me about yourself.
Add your answer

45 minutes, Logical Reasoning, Basic Mathematics, etc.

Q1. Different types of joins in SQL
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns rows when there is a match in either table
Answered by AI
Add your answer
Q2. What are some of the window functions and their use?
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Some common window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• They are used to calculate running totals, moving averages, and cumulative sums.

• Window functions require an OVER clause to define the window of rows that the function will operate on.
Answered by AI
Add your answer

Case Study was mostly around concepts of SQL

Q1. How many traffic lights are there in New Delhi (Guesstimate)
Ans. 
There are approximately 1,000 traffic lights in New Delhi.
• New Delhi is a large metropolitan city with heavy traffic, so there are likely many traffic lights.

• The number of traffic lights can vary based on the size of the city and the traffic flow.

• An estimate of around 1,000 traffic lights is reasonable for a city like New Delhi.
Answered by AI
View 1 more answer
Q2. Questions around college projects
Add your answer

Round 1 was case study round which was through hackerrank followed by 2 technical rounds. First technical round had basic sql and puzzles. Second technical was more of advanced sql.

Q1. Rank dense rank and row num difference
Ans. 
Dense rank assigns consecutive integers to rows with the same value, while rank leaves gaps in the ranking sequence.
• Dense rank assigns the same rank to rows with the same value, with no gaps in the ranking sequence.

• Rank leaves gaps in the ranking sequence for rows with the same value.

• ROW_NUMBER() assigns a unique sequential integer to each row in the result set.
Answered by AI
Add your answer
Q2. Rolling sum question
Add your answer

Q1. Basic questions
Add your answer