SentinelOne Business Development Associate Interview Questions and Answers

Q1. Find 3rd highest salary using SQL
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
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

8 SQL questions with increase in complexity and 1 case study

Q1. SQL and Statistics screaning
Add your answer

Q1. Business case studies, guess estimates, little technical
Add your answer

Q1. Complete profile screaning, Checking if candidate is suited for the role, case studies, guess estimates
Add your answer

Q1. Why sudden job change plan
Add your answer
Q2. Why Swiggy and what values did you see before applying
Ans. 
I chose Swiggy for its innovative technology, market leadership, and growth potential.
• Swiggy's cutting-edge technology in the food delivery industry stood out to me

• The company's strong market presence and leadership position were appealing

• I was impressed by Swiggy's rapid growth and expansion in the market

• Swiggy's customer-centric approach and focus on quality service were values I admired
Answered by AI
Add your answer

Q1. Ques.1 How many delivery boy have called customers more than 5 times?
Ans. 
The number of delivery boys who called customers more than 5 times is not provided.
• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.
Answered by AI
View 5 more answers
Q2. Question 2. Count distinct uniques names from the table
Ans. 
To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.
• Use SELECT DISTINCT to retrieve unique names

• Specify the name column in the SELECT statement

• Example: SELECT DISTINCT name FROM table_name

• Store the result in an array of strings
Answered by AI
Add your answer

Hackerrank SQL questions and one case study question

Q1. SQL questions related to rank, dense rank, joins
Add your answer
Q2. Flipkart wants to replace its payment options from credit card to upi. so what will be the null and the alternate hypothesis for this. and what will be the metrics to check
Ans. 
Formulating hypotheses for Flipkart's payment option transition from credit cards to UPI.
• Null Hypothesis (H0): There is no significant difference in transaction success rates between credit card and UPI payments.

• Alternate Hypothesis (H1): UPI payments have a significantly higher transaction success rate compared to credit card payments.

• Metrics to check: Transaction success rate, average transaction time, customer satis...read more
Answered by AI
Add your answer

Q1. Your uber rating is 4.2. for your first 80 rides. uber has started a new scheme where they give additional 10% of to those customers who have a rating of 4.5 and above. what is the minimum number of trips ...read more
Ans. 
The minimum number of trips required to achieve a rating of 4.5 is 20.
• To calculate the minimum number of trips required, we need to find the difference between the current rating and the desired rating.

• Since the desired rating is 4.5 and the current rating is 4.2, the difference is 0.3.

• Each trip contributes to the rating, so we need to divide the difference by the rating increment per trip.

• The rating increment per trip...read more
Answered by AI
View 5 more answers
Q2. Flipkart's this week sales was lesser than last week. there was no schemes run by its competitors. so what metrics will you check and also come up with a framework for it
Ans. 
Analyzing Flipkart's sales drop requires examining various metrics and frameworks to identify underlying issues.
• 1. Sales Trends: Compare daily sales data from this week to last week to identify specific days with significant drops.

• 2. Customer Traffic: Analyze website/app traffic to see if there was a decrease in visitors, indicating potential issues in attracting customers.

• 3. Conversion Rate: Check if the conversion ra...read more
Answered by AI
Add your answer
Q3. Myntra which is only offline now wants to make its presence offline. using myntra data, which city will it open the outlet
Ans. 
Myntra should analyze customer data, sales trends, and demographics to choose the best city for its offline outlet.
• Analyze customer demographics: Identify cities with a high concentration of Myntra's target audience, such as young professionals.

• Sales trends: Look at online sales data to find cities with the highest sales volume, indicating strong brand presence.

• Competitor analysis: Evaluate cities where competitors hav...read more
Answered by AI
Add your answer