Jul 23, 2015

SSRS Interview Questions & Answers (Part-6)

Q: Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Yes we can. SQL Server Express Edition with Advanced Services support Reporting Services. These is the free version.

Q: What are the limitations in SSRS on SQL Server express edition?
Microsoft offers reporting services free as part of SQL Server Express with Advance Services edition. But it has the following limitations:
  • Management Studio cannot be used to administer report server
  • Report Models will not be available
  • Report Builder is not available
  • Caching, History and Delivery of Report is not available.
  • SQL Server agent is not available
  • No scheduling is possible
  • Remote server database is not available for Report Data Source (Local SQL Server is a only option,)
  • We cannot store the report server database on a remote server (it has to be local only)
  • Reports can be rendered only in Excel, PDF, Image formats only
  • Reporting Services will not be able to use more than 1 GB of RAM
  • No Subscriptions (Standard and Data Driven) can be made
  • Can not be integrated with Share Point
  • Can not implement Role based security
  • Only named instances is supported
  • Scale-out Report Servers will not be available

Q: What are the tools available in market as an Alternative to SQL Server Reporting Services?
  • Non-Open Source:
    • Actuate
    • Hyperion (BRIO)
    • BusinessObjects
    • Oracle Express OLAP
    • Qlikview
    • Cognos
    • Informatica Power Analyzer
    • Proclarity
    • IntelliView
    • Dundas Chart for .NET
    • MS-Excel
    • SAS
    • MicroStrategies
    • Pentaho
  • Open Source:
    • Jasper Reports
    • JFreeReport
    • BIRT (Business Intelligence Reporting Tools)
    • OpenReport
    • DataVision
    • Pentaho

Q: How to deploy the Report?
We can deploy SSRS report in three ways.
  • Using Visual Studio: In visual studio we can directly deploy the report through Solution explorer by providing the report server URL in project properties at Target Server URL. As our choice this will deploy entire project or single report as.
  • Using Report Server: We can directly go to the report server and deploy the report by browsing the report from the disk location of server.
  • Creating the Utility: SQL server provides the facilities to Create a customize utility to deploy the report.

Q: What are the new features of SQL Server 2008 R2 reporting service?
The SQL Server 2008 R2 has introduced a lot of new features. Some of them are given below:
  • New Report Types – Table, Matrix, List, Chart, and Sub report
  • Some New Tools is added to report designer Toolbox
  • Report Data Panel – built in page numbers
  • Report Builder 3.0

Q: What are the new features of SQL Server 2012 reporting service?
The SQL Server 2012 has introduced a lot of new features. Some of them are given below:
  • Power View – interactive data exploration
  • SharePoint integration
  • Introduction to Data Alerts
  • SQL Server Data tool
  • New rendering extensions (supports MS Office 2010)
  • Project Crescent is being introduced

Q: How to backup SQL Server Reporting Services ?
There are mainly three things, which should be backed up as part of reporting services backup
  • Report Server Databases, which can be backed up by SQL server backup and restore method.
  • SQL Server Reporting Services Configuration, SQL Server Reporting Services Configuration is saved in config files, which can be copied as part of backup. look for other to know config files and there location.
  • Encryption Keys backup, use SQL Server Reporting Services Configuration tool to backup symmetric keys.

Q: What is the web service used for reporting services?
Reporting Service Web Service used in SSRS. By accessing this web service you can access all report server component and also get the report deployed on report server.

Q: What is a cache in SSRS?
Report server can lay up a copy of processed report in a memory and return the copy when a user opens the report. This server memory is known as cache and the process is called caching.

Q: Can you always create a cache of a report?
No, you can create a cache of a report only when certain requirements, such as having credentials stored in the Report Server, are met.

    Choose :
  • OR
  • To comment
No comments:
Write Comments