The below list of 65 TOP MSBI Interview Questions and Answers for freshers free download
1. What is MS BI (Microsoft Business Intelligence)?
2. What are the tools in MS BI?1. What is MS BI (Microsoft Business Intelligence)?
3. What is SSIS? How it related with SQL Server?
4. What are the tools associated with SSIS?
5. What are the differences between DTS and SSIS?
6. What is a workflow in SSIS ?
7. What is the control flow?
8. What is a data flow?
9. How does Error-Handling work in SSIS?
10. What is environment variable in SSIS?
11. What are the Transformations available in SSIS?
12. How to log SSIS Executions?
13. How do you deploy SSIS packages?
14. What are variables and what is variable scope ?
15. Can you name five of the Perfmon counters for SSIS and the value they provide?
16. What is Analysis Services? List out the features?
17. What is UDM? Its significance in SSAS?
18. What is the need for SSAS component?
19. Explain the TWO-Tier Architecture of SSAS?
20. What are the components of SSAS?
21. What is FASMI ?
22. What languages are used in SSAS ?
23. How Cubes are implemented in SSAS ?
24. What is the difference between a derived measure and a calculated measure?
25. What is a partition?
26. While creating a new calculated member in a cube what is the use of property called non-empty behavior?
27. What is a RAGGED hierarchy?
28. What are the roles of an Analysis Services Information Worker?
29. What are the different ways of creating Aggregations?
30. What is WriteBack? What are the pre-conditions?
31. What is processing?
32. Name few Business Analysis Enhancements for SSAS?
33. What MDX functions do you most commonly use?
34. How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?
35. How in MDX query can I get top 3 sales years based on order quantity?
36. How do you extract first tuple from the set?
37. How can I setup default dimension member in Calculation script?
38. Diff b/w script task & script component and its advantages?
39. What is a Master package?
40. Difference b/w Cube-Deploy and Process?
41. What is the use of data source view?
42. diff b/w calculated members and calculated measures?
43. What are the types of parameters in SSRS?
44. Difference b/w view and materliazed view?
45. What is Hyperion?
46. What do you mean by conditional reports?
47. what is the difference between OLAP and ETL tools?
48. What is OLAP?
49. What is MOLAP?
50. What is DOLAP?
51. What is ROLAP?
52. What is HOLAP?
53. Can anyone explain about Auditing in BO XI R2?What is the use of it??
54. Why we can't create an aggregate on an ODS Object?
55. How do you define multiple queries in a document?
56. What is a Universe?
57. What is Business Intelligence?
58. How do we enhance the functionality of the reports in BO?
59. What are dashboards?
60. Explain the concepts and capabilities of Business Intelligence?
61. Name some of the standard Business Intelligence tools in the market?
62. Explain the Dashboard in the business intelligence?
63. Explain the SQL Server 2005 Business Intelligence components?
64. Explain the advantages of Business Performance Management?
65. What is the main use of business content? How data can be loaded into business content after installation?
No comments:
Post a Comment