10times Business Development Associate Interview Questions and Answers

25 mcq, 3 sql queries, 90min

SQL based coding round (Online Assignment)

Q1. SQL query to print gold members of zomato
Ans. 
SQL query to print gold members of zomato
• Use SELECT statement to retrieve data from the database

• Filter the results using WHERE clause to only include gold members

• Specify the table and column names where the membership status is stored

• Example: SELECT * FROM zomato_members WHERE membership_type = 'gold'
Answered by AI
Add your answer

It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.

Q1. They give you some questions and you have to write sql queries for them
Add your answer

Q1. You are given case study and come sql questions based on that
Add your answer

Q1. What do I do in my existing job?
Add your answer
Q2. Why do you want to leave your existing job?
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Why would you like to join our organisation?
Add your answer

SQL test coding assessment which I am yet to give

Coding test like I interst

Q1. Tell me about yourself.
Add your answer

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Q1. Introduction and explain any one of the projects plus what was the analytics you used
Ans. 
Implemented a project to optimize marketing campaigns using predictive analytics
• Developed a predictive model to identify the most effective marketing channels

• Utilized data from past campaigns to train the model

• Used techniques such as regression analysis and decision trees to analyze the data

• Generated insights on customer behavior and preferences to improve campaign targeting
Answered by AI
Add your answer
Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Add your answer