Hungry Jack's Data Analyst Interview Questions and Answers

Round duration - 90 Minutes
Round difficulty - Medium

5-9pm

Q1. 
Sliding Window Maximum Problem Statement
You are given an array/list of integers with length 'N'. A sliding window of size 'K' moves from the start to the end of the array. For each of the 'N'-'K'+1 possi...read more
Ans. 
The problem involves finding the maximum element in each sliding window of size 'K' in an array of integers.
• Iterate through the array and maintain a deque to store the indices of elements in the current window.

• Remove indices from the deque that are outside the current window.

• Keep the deque in decreasing order of element values to easily find the maximum element in each window.
Answered by AI
Add your answer

Round duration - 45 Minutes
Round difficulty - Medium

Timing was Morning-noon
Interviewer was super friendly. 
He even helped me at places I got Stuck

Q1. Can you explain a complex joins problem related to database management systems (DBMS)?
Ans. 
Explaining a complex joins problem in DBMS
• Discussing the use of different types of joins like inner join, outer join, self join, etc.

• Explaining how to handle null values and duplicates during joins

• Demonstrating a scenario where multiple tables need to be joined based on different keys
Answered by AI
Add your answer

Round duration - 15 Minutes
Round difficulty - Easy

Easiest HR round ever.
Just 15 mins after the technical interview round

Mettle test on quant and machine learning

Q1. How will you handle an office emergency
Add your answer
Q2. What are your strengths
Add your answer

Q1. How would you decide if a person can be a customer of a private jet company
Ans. 
To determine if a person can be a customer of a private jet company, factors such as income level, travel frequency, and location must be considered.
• Consider the individual's income level to determine if they can afford private jet services

• Evaluate the person's travel frequency to see if they would benefit from the convenience of private jet travel

• Take into account the person's location and travel destinations to asses
Answered by AI
Add your answer

Q1. Mostly ask questions on sql.
Add your answer

Q1. Difference between Sum and SUMX in DAX
Ans. 
SUM calculates the total of a column, while SUMX calculates the total of an expression evaluated for each row.
• SUM is used to calculate the total of a column in a table

• SUMX is used to calculate the total of an expression evaluated for each row in a table

• SUMX is often used with iterators like FILTER or RELATEDTABLE to perform calculations on a row-by-row basis
Answered by AI
Add your answer
Q2. How do you use Group By in Power Query?
Ans. 
Group By in Power Query is used to aggregate data based on a specific column or columns.
• Select the column(s) you want to group by

• Go to the 'Transform' tab and click on 'Group By'

• Choose the aggregation type and column to aggregate on

• Rename the new column if needed
Answered by AI
Add your answer

Q1. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot

• List is defined using square brackets [], tuple using parentheses ()

• Example: list - [1, 2, 3], tuple - (1, 2, 3)
Answered by AI
Add your answer
Q2. Nth highest salary
Ans. 
To find the Nth highest salary in a dataset, you can use SQL query with ORDER BY and LIMIT.
• Use SQL query with ORDER BY and LIMIT to sort the salaries in descending order and select the Nth row.

• For example, to find the 3rd highest salary in a table 'employees', you can use: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2, 1
Answered by AI
Add your answer

Q1. What is SQL server Architecture?
Ans. 
SQL Server Architecture refers to the structure and components of the SQL Server database management system.
• SQL Server Architecture consists of three main components: Database Engine, SQL Server Agent, and SQL Server Browser.

• The Database Engine is responsible for storing, processing, and securing data.

• SQL Server Agent handles automation tasks, scheduling jobs, and managing alerts.

• SQL Server Browser helps clients locate...read more
Answered by AI
Add your answer