Streak AI Data Engineering Analyst Interview Questions and Answers

First round of test consisted of sql questions , medium and easy level

Q1. Mostly sql questions like cumulative sum
Add your answer

Q1. This interview was more focused on the decision making in different scenarios
Add your answer

Q1. NANANANANANANANA
Add your answer
Q2. NANANANANANANANANA
Add your answer

Q1. NANANANAANANANA
Add your answer
Q2. NANANANANANANANANANA
Add your answer

Hackerrank test medium difficulty

Presenting the case study which was given as a take-home assignment

Q1. Result of different sql joins
Ans. 
SQL joins combine data from two or more tables based on a related column between them.
• Inner join returns rows that have matching values in both tables

• Left join returns all rows from the left table and the matched rows from the right table

• Right join returns all rows from the right table and the matched rows from the left table

• Full outer join returns all rows when there is a match in either left or right table
Answered by AI
Add your answer

Q1. Joins, case when
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.
• Joins are used to retrieve data from multiple tables based on a related column

• Case when is used to perform different actions based on different conditions in SQL queries

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...read more
Answered by AI
Add your answer

Q1. Joins, SQL query execution
Add your answer
Q2. Simple Sals Question - SQL
Add your answer