Dhwani Rural Information Systems Data Analyst Interview Questions and Answers

Q1. How many swift cars in mumbai?
Ans. 
The exact number of Swift cars in Mumbai is not available, but it is a popular choice among car owners in the city.
• Swift cars are a common sight on the roads of Mumbai.

• Maruti Suzuki, the manufacturer of Swift cars, has a strong presence in the city.

• The number of Swift cars in Mumbai is constantly changing due to sales and purchases.

• One can see multiple Swift cars in popular areas like Bandra, Andheri, and South Mumbai.
Answered by AI
Add your answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

First round was a coding test online with screen monitoring

Q1. Hacker rank code for no reason for de
Ans. 
The question is unclear and requires further clarification.
• Request for more information on the specific requirements of the code.

• Ask for clarification on the purpose of the code.

• Determine the programming language to be used.
Answered by AI
Add your answer
Q2. Python sort element of string array by alphabet weightage and resolve all 23 test cases that nobody can
Ans. 
Sort string array elements by alphabet weightage in Python and pass 23 test cases.
• Use the sorted() function with key parameter to sort elements by weightage

• Define a function to calculate weightage of each character

• Test the function with various test cases to ensure accuracy
Answered by AI
Add your answer

Q1. Spark, AWS, Python
Add your answer

Q1. Python, SQL, Spark
Add your answer

Q1. Salary discussion
Add your answer

Q1. General Interview
Add your answer

BASIC PYTHON AND SQL

Q1. Questions based on past experience
Add your answer
Q2. My roles and responsibilities
Add your answer

Q1. Easy HR questions
Add your answer

You will receive a test link in which you will have 4 mcq ,1 python problem and 1 sql question

Q1. This was also coding round on hackerrank with one moderator
Add your answer

Python, SQL questions were in the initial round of hiring process.

Q1. ML, DL & knowledge about Cloud were main focus of the interview.
Add your answer
Q2. Questions around your resume
Add your answer

One python coding question and one sql coding questions and MCQ questions

Q1. --difference between rdd, dataframe and dataset.
Ans. 
RDD is a distributed collection of objects, DataFrame is a distributed collection of rows with schema, and Dataset is a distributed collection of objects with schema.
• RDD is a low-level abstraction in Spark that represents an immutable distributed collection of objects. It lacks the optimization that DataFrames and Datasets provide.

• DataFrame is a distributed collection of data organized into named columns. It provides a...read more
Answered by AI
Add your answer