Thursday 25 February 2016

SSRS Interview Questions and Answers for Beginners

SSRS Interview Questions and Answers for Beginners

Question: What is SSRS?
SQL Server Reporting Service(SSRS) is a server-based report generation software systems from Microsoft.

Question: Why SSRS is used?
  1. Generate variety of reports.
  2. Admin use web based interface for generate the report.
  3. You can create very rich reports (Tabular / Matrix / Graphical/Interactive)
  4. Export in variaous format like Excel, PDF, word etc.
  5. It is faster and cheaper.
  6. Efficient reporting
  7. Security integrated

Question: Explain the Reporting Life Cycle of SSRS?
  1. Development of Reports: Design the reports by Developer.
  2. DBA Analyse: DBA check the security and schedule the time for generating the report.
  3. Report Delivery: After generating the report DBA check the list and handover to appropriate person.

Question: What are the Reporting Services components?
  1. Report Designer: Design the report.
  2. Report Sever: Execute the Report.
  3. Report Manager

Question: Difference between SQL Server Reporting Services and Crystal Reports?
SQL Server Reporting Services Crystal Reports
SSRS have a report server Processed by IIS
SSRS is available for Report history snapshots. Caching is available through cache server.
Custom Label NOT available. Custom Label are available

Question: What are different types of roles provided by SSRS?
  1. Browsers
  2. Content Manager
  3. My Reports
  4. Publishers
  5. Report Builder

Question: What are the three different part of RDL file?
  1. Data
  2. Design
  3. Preview

Question: What is RDL?
RDL is a file extension for an XML file used in SSRS.
MIME type: text/xml

Question: What are the different types of data sources in SSRS?
  1. Microsoft SQL Server
  2. OLEDB
  3. Oracle
  4. ODBC
  5. SQL Server Analysis Service
  6. XML
  7. Teradata
  8. Hyperion
  9. SAP Net weaver BI
  10. Report Server Model

Question: In Which format we can export SSRS Reports?
  1. HTML
  2. Excel
  3. PDF
  4. Tiff Image
  5. XML
  6. CSV

Question: What is report snapshot?
It is instance of a report for future reference and its save in server.

Question: What is Tabular Report in SSRS?
Simply display the data using table.
Tabular report is the simplest Report of the SSRS Report.

Question: What is a Matrix in SSRS?
Matrix allows us to create crosstab reports with the variables on rows and columns.

Question:What is Query parameter in SSRS?
SQL Qery can be accepted as parameters.Query parameters begin with the symbol i.e @.

Question: What is the chart in report?
Chart reports are for graphical representation of reports. pie charts and 3D chart are also available.

Question: What are data regions?
Data regions are report items that display repeated rows of summarized information from datasets.

Question: What is Report Builder?
Report Builder is a report authoring environment for business users.

Question: What are alternatives of SSRS at free of cost?
  1. Jasper Reports
  2. JFreeReport
  3. Pentaho
  4. Business Intelligence Reporting Tools
  5. DataVision

Question: What are the Types of SSRS?
  1. Parameterized reports
  2. Ad hoc reports
  3. Clickthrough reports
  4. Drillthrough reports
  5. Subreports
  6. Linked reports
  7. Snapshot reports
  8. Cached reports

Question: What is Data Set in report?
It is set of data which we want to show in report.

Question: What is the report model project?
It is used to create Adhoc reporting.

Question: What is RS.exe utility?
It is used for deploying the report on report server.