Dhwani Rural Information Systems Data Analyst Interview Questions and Answers

• Q1. Spark optimizations
  Add Answer
• Q2. Pyspark quetions
  Add Answer

• Q1. Intro about yourself
  Add Answer
• Q2. About the project
  Add Answer

Easy and moderate level question

Given a relevant topic and discussion on it

• Q1. Introducd yourself
  Add Answer
• Q2. Why do you want to join us
  Add 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

• Q1. Tell about your project
  Add Answer

Check whether a string is a valid parenthesis or not.