Xchange, Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies.
       I attended Xchange software company's interview in March 2012.  I have given all the questions which I faced during interview. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt !! ALL THE BEST!!

(1)Tell me about yourself in terms of roles and responsibilities?

(2) How to create a cube in SSAS? Explain detailed steps from creation to deployment?

(3) What is a hierarchy? How many types of hierarchies do you have in SSAS?

(4) What is a huge data migration means in your project?

(5) How did you load 1 tera byte data from source system to target system?

(6) What is the bottle necks did you faced while moving the data from source to target?

(7) Have you applied partitioning in your project? Have you used database partitions?

(8) Have you used profiler and perfMonitor tools? Why did you use profilers in your project?

(9) What are the performance problems & have you faced when migrating the data from source to target?

(10) How to get top 3 student marks from the below table

Student Id	Marks
1	100
2	100
3	200
4	300
5	400

(11) How to get employees whose salary is less than average salary of the employee to which he belongs to?

Emp name	Emp salary	Dept id
1	2000	1
2	3000	1
3	1000	1
4	5000	2
5	2000	2