Scaler Academy Production Analyst Interview Questions and Answers

5 SQL Questions (Leetcode Level)

Uber is experiencing a decline in profits in the current quarter. How can this issue be addressed?

Q1. Simple SQL based questions on Joins , Self Joins, Window Functions, Group Concat etc.
Add your answer
Q2. Difference between Rank, Dense Rank and Row number.
Add your answer

Q1. SQL Questions on Windows Functions , Self Join Etc.
Add your answer
Q2. Case Study: Suppose there is a resume builder in Scaler. What metrics should we track on Resume builder.
Ans. 
Metrics to track on a resume builder in Scaler
• Number of resumes created

• Average time spent on creating a resume

• Percentage of resumes completed

• Number of templates used

• Feedback ratings from users
Answered by AI
Add your answer

Q1. Basic SQL Questions
Add your answer
Q2. What could be the root causes of the decline in transactions on an e-commerce platform?
Ans. 
Possible root causes of decline in e-commerce transactions
• Poor user experience leading to high bounce rates

• Lack of marketing efforts resulting in decreased traffic

• Technical issues causing website downtime or slow loading times

• Increased competition from other e-commerce platforms

• Changes in consumer behavior or preferences

• Security concerns leading to lack of trust in the platform
Answered by AI
Add your answer

General Case Study on real life topic

Q1. SQL - Easy to Medium
Add your answer

Q1. SQL - Hard + Logical Thinking + Case Study
Add your answer

Q1. SQL + Resume + HR
Add your answer

SQL questions, easy, medium, hard