MSBI Interview Questions- Part(2)

Session on 21-09-2013(F)

1. What Type of Connection Managers is used in ur project?
2. Transformations used in ur Project
3. What is use Merge Join
4. Sort Transformation is compulsory or not
5. How to eliminate duplicates
6. Audit information is useful or not
7. Event Handlers and used in ur project
8. Execute Sql Task, How to use in Real Time
9. Variables, Check Points in ur Project
10. How to check the data passing from source to destination correctly
11. Data viewers and Types
12. What is ur of User variables
13. Script Component and used in Project
14. Package Deployment
15. How do u do Package Configuration
16. How to u encryption data from one place to another place
17. What is CTE
18. What is Difference between Local and Global Temp Tables
19. How can u handle duplicate data using Temp tables or Another
20. How do u use Indexes and Types of Indexes
21. How long work with Mdx and SSAS
22. Aggregation and Partitions
23. Hierarchs and Types
24. Star and Snowflake Schemes
25. Report Builder and SSRS
26. Linked Reports and SubReports
27. Types of Reports
28. Types of Parameters
29. How to deleting options in report display at browser(only pdf)
30. Snapshots


Session on 24-09-2013(F)

1. Why is need of Data warehouse?
2. Package Optimization Methods
3. What type of source files are used in Project
4. How to Pull data in Data warehouse
5. How to Deploy the Report
6. What is Incremental Load
7. U create a variable in DataflowTask and used it Entire Package or not
8. U changes the scope of variable from Dataflowtask ->Package.