Copperpod Digital Data Analyst Interview Questions and Answers

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

The Technical coding round will tested me on mid to complicated python and SQL coding

Q1. The technical round delved into my ongoing projects and tech stack where moreover python, SQL, DSA, spark architecture were discussed.
Add your answer

Q1. The HR discussion was a wrap up highlighting the company's culture and values and salary discussion Overall the onboarding was seamless.
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

Hacker Rank Test that was not much hard

Q1. Basics of python, SQL and pyspark
Add your answer
Q2. Projects written in the resume
Add your answer

Q1. On databricks architecture
Add your answer
Q2. Previous project experience
Add your answer