MSBI Interview Questions and Answers
These Interview Questions Involves Microsoft BI(SSIS,SSAS,SSRS) Q1).MSBI Characteristics Ans: Criteria Result Analytics Dashboards, guided navigation and drill down Type of Solution End-to-end Business solution with extended ETL User-friendly Ease of installation, use, maintenance Get a detailed understanding of the advantages of MSBI over other business intelligence tools. Q2). Define Query parameter in SSRS? Ans: Query parameters is revealed in the query of the datasources that are to be included into the SQL script’s where clause of the SQL that can accept parameters. Query parameters begin with the symbol @. Q3). What are the Reporting Service Constituents in SSRS? Ans: A.Report Manager : A Web-based administration tool for managing the Report Server. B Report Server : Provides services for implementation and delivery of reports. C. Report Designer : A place where we can create report. Q4). What do you und...