Myantra Data Analyst Interview Questions and Answers

Q1. Load data from hdfs using python
Ans. 
Use PyArrow library to load data from HDFS in Python
• Install PyArrow library using pip install pyarrow

• Use pyarrow.hdfs.connect to connect to HDFS

• Use pyarrow.parquet.read_table to read data from HDFS
Answered by AI
Add your answer
Q2. Query to find the top three salaried employees of each department
Ans. 
Query to find the top three salaried employees of each department
• Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary

• Partition the data by department and order by salary in descending order

• Filter the results to only include rows where the row number is less than or equal to 3
Answered by AI
Add your answer

Q1. Explain Data types in SQL?
Ans. 
Data types in SQL define the type of data that can be stored in a column of a table.
• Data types include integer, float, text, date, boolean, etc.

• Each data type has specific properties and constraints.

• Examples: INT for integers, VARCHAR for variable-length character strings.
Answered by AI
Add your answer
Q2. Explain the difference between DBMS and RDBMS?
Ans. 
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
• DBMS stands for Database Management System, which is a software system that allows users to interact with a database.

• RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

• RDBMS e...read more
Answered by AI
Add your answer

Q1. SQL Query of case when then statement
Ans. 
SQL query using CASE WHEN THEN statement
• Use CASE WHEN statement to create conditional logic in SQL queries

• Syntax: SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result3 END AS new_column_name FROM table_name

• Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS age_group FROM customers
Answered by AI
Add your answer
Q2. SQL Query of join
Ans. 
SQL query to join tables based on a common key
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to be joined in the ON clause

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
Add your answer

Q1. Questions on DBMS,ML,SQL,PLSQL,OOPS
Add your answer
Q2. What is polymorphism
Ans. 
Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to be used for different data types or classes.

• Examples include method overloading and method overriding in object-oriented programming.
Answered by AI
Add your answer
Q3. Polymorphism is abstraction in object oriented lagnguage used for providing too may forms to single entity
Add your answer
Q4. What is the major issue you faced inml project
Add your answer
Q5. What is your biggest strength
Add your answer

Logical question math

Learn oops it's very important

40 questions are there. The que have different categories. Reasoning , critical thinking

Q1. Tell me about your self
Add your answer
Q2. Question based on the resume
Add your answer
Q3. What are the project you have done?
Add your answer

It is conducted using Hakerrank ,20-60 mins duration