Ubisoft Entertainment Data Analyst Interview Questions and Answers

Contained aptitude test with both numericals as well as coding questions

It was a one on one round

Q1. Final discussion
Add your answer
Q2. If ready to relocate
Ans. 
Yes, I am open to relocation for the right opportunity.
• I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.

• I am open to exploring new cities and cultures.

• I understand that relocation may come with some challenges, but I am prepared to face them.

• I am excited about the prospect of working with a new team and contributing to the success of the company.
Answered by AI
Add your answer

Q1. What is the difference between Union and Union all ?
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Q1. Write a sql query
Ans. 
SQL query to retrieve employee names and their salaries from a table
• Use SELECT statement to retrieve data

• Specify the columns you want to retrieve (employee names and salaries)

• Specify the table name where the data is stored
Answered by AI
Add your answer
Q2. Formula of vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
• VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...read more
Answered by AI
Add your answer

Q1. How to read parquet and csv file in spark .
Ans. 
To read parquet and csv files in Spark, use SparkSession's read method with appropriate options.
• Create a SparkSession object

• Use the read method of SparkSession to read parquet files with .parquet() method

• Use the read method of SparkSession to read csv files with .csv() method

• Specify options like header, delimiter, inferSchema, etc. as needed

• Load the data into a DataFrame for further processing
Answered by AI
Add your answer
Q2. How to check second highest sallery.
Ans. 
To check the second highest salary, use the SQL query with ORDER BY and LIMIT.
• Use SQL query with ORDER BY clause to sort salaries in descending order.

• Use LIMIT 1,1 to select the second highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Answered by AI
Add your answer

Q1. Resume based questions on past experience
Add your answer
Q2. Case study based questions
Add your answer

Q1. Resume based questions,
Add your answer
Q2. Moderate SQL Coding question
Add your answer
Q3. Case study based questions
Add your answer

Q1. General HR related questions
Add your answer

Q1. Managerial & Aptitude questions
Add your answer

Q1. Managerial discussion about role & industry
Add your answer

Q1. Leetcode sql question
Add your answer
Q2. "Pandas and NumPy question."
Add your answer

Q1. Asked AP related questions
Add your answer
Q2. Related to Resume and scenerios
Add your answer

Online call where we have to answer

Q1. Gaming consoles which I have played
Ans. 
I have played on various gaming consoles including PlayStation, Xbox, Nintendo, and PC.
• PlayStation

• Xbox

• Nintendo

• PC
Answered by AI
Add your answer