Interview Questions -4

1) Tell me about yourself?

2) Which schema will be good for performance wise? Snow Flake Schema

3) Write a query to display top 3 employees by salary?

ELECT  *FROM 

    (

    SELECT *FROM emp 

    ORDER BY Salary desc

    )

WHERE rownum <= 3

ORDER BY Salary ;

4) Write a query to display 3rd highest salary in an emp table?

 

Select TOP 1 Salary as '3rd Lowest Salary' 

from (SELECT DISTINCT TOP 3 Salary from Employee ORDER BY Salary ASC) 

a ORDER BY Salary DESC 

 Select TOP 1 Salary as '3rd Highest Salary' 

from (SELECT DISTINCT TOP 3 Salary from Employee ORDER BY Salary DESC) 

a ORDER BY Salary ASC 

5) Have you worked on Tabcmd? what and all yu have done?

6) how do you refresh an extract from the Tableau server using Tabcmd and what are the different arguments or parameters 

we need to pass to it?

7) what is a filter and what is an action filter? 

8) what is data blending and how do you customize the common field for data blending?

9) I have a dimension called products and i have to display top 5 products and the remaning as others? In a single

 view ..how do you do that?

10) what is adhoc analysis or reporting? 

11) I have a database and i have to setup the environment for my customers who willdo the adhoc analysis? How do you do that?

12) Can i pass the parameters to an URL?

13) How do you setup the User security filters in Tableau?

14) what is a data source? Have you ever sseen a datasource in tableau server?

15) what are all the different steps you will take to improve the performance?

16) how do you improve the performance of calculation fields?

17) can i use parameters on  a secondary source (data blending) columns?

18) when you publishing the workbook..do you need to sign on to Tableau server?