Radical Software Data Analyst Interview Questions and Answers

Q1. Join, window function excel vlookup, sumif,count etc.
Add your answer

Q1. Self introduction
Add your answer
Q2. About Hobbies
Add your answer

Q1. Find second max salary of employee by department in sql
Ans. 
Find second max salary of employee by department in SQL
• Use GROUP BY clause to group employees by department

• Use MAX() function to find the maximum salary

• Use subquery to find the second maximum salary
Answered by AI
Add your answer
Q2. Find second max salary 9f employee by department using python pandas dataframe
Ans. 
Find second max salary of employee by department using pandas dataframe
• Group the dataframe by department

• Sort the salaries in descending order

• Select the second highest salary for each department
Answered by AI
Add your answer
Q3. Python code to download file from aws s3 to local using boto3
Ans. 
Python code to download file from aws s3 to local using boto3
• Install boto3 library using pip

• Create an S3 client using boto3

• Use the download_file method to download the file from S3 to local
Answered by AI
Add your answer
Q4. Write word count program in pyspark
Ans. 
A program to count the number of words in a text file using PySpark.
• Read the text file using SparkContext

• Split the lines into words using flatMap

• Map each word to a tuple of (word, 1)

• Reduce by key to count the occurrences of each word

• Save the output to a file
Answered by AI
Add your answer

Q1. Explain anyone algorithm
Ans. 
Random Forest is an ensemble learning algorithm that builds multiple decision trees and merges them together to get a more accurate and stable prediction.
• Random Forest is a popular algorithm used for both classification and regression tasks.

• It creates multiple decision trees during training and combines their predictions to improve accuracy.

• Random Forest is less prone to overfitting compared to a single decision tree.

• E...read more
Answered by AI
Add your answer

Reasonging, isssues, maths, science, socila

Q1. Challanges, issues
Add your answer
Q2. Challanges2, issues
Add your answer

6 mcqs and 2 sql questions

Q1. Difference between having and where in sql
Ans. 
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: S
Answered by AI
Add your answer
Q2. Sql joins and it types
Add your answer
Q3. Window functions and subqueries
Add your answer
Q4. Sql scenario question based on joins
Add your answer
Q5. Kpi's and metrics
Add your answer

Q1. Business problem related to case study
Add your answer

Q1. Join, window function excel vlookup, sumif,count etc.
Add your answer