Top 21

Prep plan

Updated weekly · Last refresh Aug 30

D

Disney+HotStar Business Analyst Interview Questions

The questions to prepare for a Disney+HotStar Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

21questions

~3htotal time

Track your progressSign up free to work through all 21 questions and resume where you left off.

Start practicing free →

1

SQL & Data ManipulationStart here. 11 questions + 3 drills · ~118 min

Analytics and Case Study for HotstarMedium

Assesses intermediate SQL capability and ability to apply it to analytics and case studies.

analyticscase studysqlDDisney+HotStar

SQL for Daily Active RetentionMedium

Tests SQL skills for computing retention metrics from user activity data.

sql queryData Analysisuser retentionDDisney+HotStar

SQL, Business Case, Resume FitMedium

Evaluates breadth of SQL and business case reasoning based on your background.

sqlDDisney+HotStar

Top Content by Watch TimeMedium

Rank Disney+ Hotstar content by monthly watch time using aggregation, joins, and ROW_NUMBER().

Window FunctionsData Analysisquery optimizationDDisney+HotStar

DAU by Content CategoryEasy

Calculate daily unique viewers for Disney+ Hotstar Sports content using a filtered join and COUNT(DISTINCT).

sql queryData AnalysisDDisney+HotStar

Top 10 Users by Watch TimeMedium

Rank the top 10 Disney+ Hotstar users in India by January watch time using a CTE, LEFT JOIN, and aggregation.

sql queryData Analysisuser engagementDDisney+HotStar

More SQL & Data Manipulation questions with a free account

2

Strategy3 questions · ~24 min

Investigating Viewership DropsHard

Tests structured root-cause analysis for a sudden change in Disney+HotStar engagement metrics.

root cause analysisDDisney+HotStar

Boost Engagement for Light ViewersMedium

Evaluates strategy for improving engagement among a targeted viewer segment on Disney+HotStar.

DDisney+HotStar

More Strategy questions with a free account

3

Behavioral & Leadership4 questions · ~32 min

More Behavioral & Leadership questions with a free account

4

More topics3 questions · ~24 min

Prioritize Competing Research DeadlinesEasy

Explain how you prioritize competing research tasks with different deadlines, business impact, and stakeholder needs.

Trade-offsRoadmappingScope ManagementDDisney+HotStar

Designing Recommendation Effectiveness MetricsMedium

Assesses metric design for measuring impact of recommendations on Disney+HotStar.

DDisney+HotStar

Measuring Original Series Launch SuccessMedium

Assesses product analytics thinking for evaluating launch outcomes on Disney+HotStar.

success metricsDDisney+HotStar

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan

The finish line: interview-readyComplete all 21 questions plus 3 hands-on drills to finish this plan.