**Questions are mostly constructive around the projects that you worked

Python Interview
1. professional summary
2. some questions on what you elaborated as your projects
3. how to identify duplicate records from a table (example: customer table where multiple
times customer records are duplicated)
4. same question as above but without using any analytical functions
5. give an example query with group by syntax (post example he tried asking some extension
questions on top of the example)
6. shared his screen and showed some data and asked some queries to extract specific things
7. what are the joins u have used?
8. Give me some example scenarios where you have used joins? why did you used specific join
there and questions around your explanation
9. what is AWS Redshift?
10. what is a Datawarehouse?
11. Why did you people create a data lake in your Project? (Specific to my explanation of
previous project)
12. why did we create DataMart? (Then deep dive into some of the project related works)
13. familiarities with views and CTE
14. questions on Tableau Custom SQL
15. asked to elaborate any dashboard and how did the requirements come and how did we
approached (as I have experience in tableau)
16. some questions on R shiny code which i have worked. asked to elaborate the use case and
some discussion around it
17. what is your experience with API’s?
18. asked some questions around request library
Tableau Interview
1. Tell me about your last project with briefly
2. What are the Dashboards are prepared in your last project?
3. How many types of Databases your connected and what is those Data bases?
4. What are the challenges faced in your last project and how you overcome that?

5. What is Row level security and why we need to use it

6. User filter in tableau and steps
7. Difference between dimensions and measures
8. Filters in Tableau
9. If we have 2 different data sources without any relationships or common attributes
how to merge 2 tables in tableau
10. In General what type of dashboards you have developed and give some example
11. Please prepared briefly about the partition functions and where it will used.
12. Preparing datamodel with different database tables in Tableau.
13. What Tableau charts to be used for different scenarios?
Below questions are very common which customer is asking very frequently.

[Link] we have 10 records in table A and 5 unique records in table B. what should be the output
for left outer join and right outer join. Candidate should be able to write the Query for the
same and output of it. Customer is asking this same questions many times with minor tweak.
 2nd scenario what if table B has all null records , 3rd scenario what if all records are matching,
4th scenario what if only 2 records match in table B.
2. how to join two tables with foreign key and query for the same
3. Fetch Two topmost employee whose salary is highest in department A.
4. Fetch topmost employee whose salary is highest in 4 different department (A , B , C, D)
5. use of Not in , Substring, ltrm, rtrim,
6. how to fetch only first 3 char from Priyanka or any name and query for the same.
7. table a: 5 records , table b: 6 records and table c: 7 records. if we join a left b then what
would be the output if all are unique records. Output for B Join C.

SQL:
14. difficult scenario you have faced.
15. Customer ID column was unique and Customer name column has some duplicates how will
find duplicates from the customer column?
16. And how will remove the duplicates from the Customer name column?
17. What is the query to merging for two tables?
18. How to write the query for between the Months and Days.
19. What is the query for create partition table?
20. Customer ID column was unique and Customer name column has some duplicates how will
find duplicates from the customer column?
21. Difference between Snowflake schema and Star schema
22. Previous projects and metrics involved.
23. Row Level security application
24. Finding rolling sum using SQL
25. suppose we have a table in snowflake, we want to create multiple workbooks from the
same, and other resources also can use the same table. what will be your approach.
26. how relationship is beneficial
27. live vs extract
28. what is the mechanism of increamental refresh.
29. join scenarios, write the queries for inner , left , right, cross join.
30. how do you optimize performance.
31. suppose there is value missmatch in dashboard, what will be your approach? what will you
do if a logic changed or a new table has been provide to use instead of the old table already
in use?
32. i have a table, i want another column added which will show me the max salary per
department.
write the query and explain.
gave 2 tables . where table a has 19 records and table b has 25 [Link] me the query and
give the number of records it will give in all joins , and explain the mechanism.
33. what is table snapshot?
34. what is stored proc. what it does?
35. what is view? why we use [Link]
36. couple of questions from snowflake.
37. have you worked on ETL ?

38. Join types in SQL, different between join and union

What will be output for inner join, left outer join, right outer join and for below table :

INNER JOIN: No. of records = (2*1)+(1*1) = 3 rows

Left outer join: No. of records = (2*1)+(1*1)+1= 4 rows

RIGHT outer JOIN: No. of records = (1*2)+(1*1)+1+1= 5 rows

For cross join: output (4*4) = 16

QA Interview Questions

1. Tell me about yourself.

 2. Tell me about your current project.
3. How to validate power BI dashboard
4. write a query for self-join
5. Write a query category wise sum of revenue
6. Write a query whose revenue greater than 200
7. Write a query category wise total revenue and who is having revenue greater than 500
8. Types of joins
9. Normalization

24th Apr Renuka

[Link] is normalization
2. in a table how do I identify the uniqueness in the table

[Link] have different roles which employee was hired first in that role
[Link] the roles in the employee table… # of employes for each role with min of 2 employees only to
be displayed

5.D isplay Role Name from Employee Table, wherein in every Role, there should be minimum of 2
employees
[Link] tableau , if I hv to pull for every role which employee was hired first in that role , hw wil we do it
tableau
7.

8. Query to change rows to columns as above

9. In tableau what is the complecated thing u hv developed so far
10. Employee Id and employee name concatenated with first letter of the role Ex.. Nagaveena D
11.

24th apr Krupa

 1. Understanding the concepts of DW?
2. Create models etc . ex on usecase which u hv worked on .. any challenges u faced
3. Dimensions facts tables??

4.

1. to give list of employees arranged in the order of month

2. what is unbounded preceeding
[Link] to gives max salary of an employee and eraned in which month

[Link] each employees when is the latest hike, previous salary and the % of hike he received

[Link] of Views , SPs,?

[Link] recent dashboard you have worked on where more of calculations involved ?
[Link] is the approach to carete a data source ? hw do u go about it ? for ex.. need
approach for below scenario…
We have customer, sales, product tables . which customer is making high sales by region ?
And to check were there any sales that deviated from the average baseline(average mean)
of it

8. when we run a view it runs in back end and custom sql runs on Sql engine. Which is better
option u think and why ?
9. what kind of chart u would prefer to show sales over time
10.
One of the dashboard view in a given time range
How do u bring the colour coding ?
Explain different types of dashboard actions you have worked on?

And couple of scenario question son dashboard actions

What is your approach on fine tuning the dashboard ?

Worked on any kind of different charts like donut chart etc . have you ever tried?

25th Apr – Renuka

1. what is SDLC
2. what is diff between OLTP and OLAP
3.

3. Employees which are occurring more than once

4. Who was the employeewho has hired first by the role
5. Write the query to display above years m revenue to colums
How do use this tableau
5.
How do we achievev below Criteria in Tableau

6. How do you implement row level security in tableau

7. 500 region 500 ppl . 1 person is assigned to 1 region . how do u create groups in this
case
8. Diff between cross join and full outer join
9. Material view
10. Diff btw union and union all
11. Complicated thing u hv implemented in tableau
12. Row level security by region
13. Where hv u used luk up fn
14.