SSRS Interview Questions 1

· 1 min read

SSRS · General

Questions:Notes:
What is SSRS?SSRS stands for SQL Server Report Services. It is the component of Microsoft SQL Server 2008 that provides an enterprise-ready and extensible presentation layer for the Microsoft business intelligence platform to develop, manage and deliver reports.
What are the stages of the Report Life Cycle?The stages of the Report Cycle include: Authoring /Development i. Development and creation of a report Management i. Optimization and Security Delivery / User Access i. Deployment and Delivery through Emails, Shared Folders, etc. Subscriptions.
What happens during Requirement Gathering?Ask questions such as: What is the data source? OLTP? SSRS? Analytical DB? What kind of business questions do you want to answer? How should this data be presented? In what form?
What are the main components of SSRS?The main components of SSRS include: Report Designer Report Builder Report Server Report Manager
What types of Reports does SSRS support?The types of Reports include: Managed Reports Ad Hoc Reports Embedded Reports
What are Managed Reports?A Managed Report is for users who know how to use all of the aspects of the reporting tool. They are Enterprise Reports that are managed by the SQL Developers up until the finished product. These users know the structure of the underlying data and they know how to retrieve the data. These reports are code based for developers. You use the Report Designer to make Managed Reports.

Share this post