Sonata Software Solutions,Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Capgemini, Hyderabad interview Questions

       I gathered Sonata Software Solutions, Bangalore Company’s interview questions in Dec 2013. 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?

(2)   Tell me about your current project?

(3)   Out of 3 tools, which one is more comfortable?

(4)   What do you mean by type 2 SCD?

(5)   What do you mean by type 1 SCD?

(6)   What do you mean by type 3 SCD?

(7)   What is a surrogate key in the data warehouse?

(8)   What is degenerated dimension?

(9)   You have a cube created? I want to process only latest changes? Which processing option do we have to use?

(10) What are rigid and flexible attribute relationships?

(11) How do you deploy a cube from development environment to production environment?

(12) When you take a backup which back up file will get generated? i.e. extension?

(13) When you create a cube what are the steps do we need to follow?

(14) How do you add a semi additive measure? What makes a measure become semi additive measure? What is the unique property which makes a measure become semi additive measure? What do you mean by semi additive measure?

(15) Have you created calculated members ever?

(16) What do you mean by Named set?

(17) Have you written any MDX script?

(18) I have a tabular report. The have multiple columns in the tabular report. I want to give access to users to sort the data when user clicks on the column?

(19) What is the drill down report?

(20) I want to show a user name in the report? How can we achieve that?

(21) What are the control flow tasks which we have in SSIS?

(22) I have a package with one data flow task. The data flow task I am transferring the data into the sqlserver? Now, I want to log the information in the Sqlserver like package Name, machine Name, and task Name. How can we achieve this?

(23) I want to use the custom log and store the information in the custom table in sqlserver which I have created?

(24) Have you used look up Transformation?

(25) What are the partial connection manager and full connection manager in look up Transformation?

(26)  What is full cache, partial cache and no cache in the look up transformation?

(27) I have 100 records in my source. Now, I want to move first 25 records in the destination A and next 50 records in destination B and last 25 records in destination C. How can you do that?

(28) How do you apply package configurations in SSIS?  If you apply, XML configuration then what will be the file extension?

(29) Have you used CTE?

(30) Suppose I want to query the data from the Oracle database. But, I want to query from sqlserver? How can you do that?