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.

Best Related Posts are Following:

1. PHP HTML5 video streaming examples.
2. What is Composer in php? - Manage the Dependencies.
3. Hadoop Basic Interview Questions and Answer.
4. Hadoop - Understanding Hadoop Architecture.
5. MongoDB Interview Questions and Answers.
6. Manage SPF Record - How to add SPF Record?.
7. How do you parse and process HTML in PHP.
8. Edit an commit message in Github Repository - Commands.
9. How do you disable browser Autocomplete on web form field / input tag?.
10. Web Development Project Manager interview questions and answers.
11. How to create Dynamic XML Sitemap online.
12. What is UPnP in Skype?.
13. How to delete Content of File in windows.
14. Difference between SSL and HTTPS.
15. SPDY Protocol - Improve the Speed of web page.
16. Difference Between Hadoop and Big-Data.

Google App Engine Free Hosting

Question: What is Google App Engine?
Google App Engine is a platform as a service (PaaS).
It provides cloud computing platform for developing and hosting web applications in Google-managed data centers.
It is also know as GAE.


Question: When comes stable version of Google App Engine?
1.9.26 / 4 September 2015


Question: Which Programming languages support by GAE ?
Python, Java, Go, PHP and coming others

Question: What is Offical website for GAE?
http://cloud.google.com/appengine


Question: Why GAE is used?
It is used to develop the Web Application, APIs for Mobile, Web Application.


Question: What are different built-in services available?

1. NoSQL datastores
2. memcache
3. user authentication API

Question: What are benefits of using GAI

1. Load Balancing
2. Health Checks
3. Application logging
4. Automatic Scaling
5. Automated Security Scanning

Question: What are different IDE available with GAE
Eclipse, IntelliJ, Maven, Git, Jenkins, and PyCharm.


Question: Is it free?
Yes, It is free upto few Level.
Check here for details https://cloud.google.com/appengine/


Question: What is Difference between Google Apps and Google App engine(GAE) ?
Google Apps: It is Web-based hosted software-as-a-service (SaaS).
For Example: gmail.com, Gtalk, Google calender

Google App engine: It is a platform-as-a-service (PaaS).
Here you can host your Website and Website APps.
For Example: It is similar to Amazon Elastic Compute Cloud (EC2).


Question: What are the steps to start with Google App Engine?

1. Download the App Engine SDK for PHP
2. Creating a Simple Request Handler
3. Create the Configuration File
4. Testing the Application
5. Iterative Development
6. Uploading the application
7. Done

For Details : https://cloud.google.com/appengine/docs/php/



Question: How to start the PHP development in Google Engine App?

1. Registering an app on GAE. https://appengine.google.com/
2. Download the Google App Engine from https://cloud.google.com/appengine/downloads#Google_App_Engine_SDK_for_PHP
3. Starting a project with IDE
4. create main.php and app.yaml files
5. Test your application
6. Upload to Server

http://www.sitepoint.com/google-app-engine-php-getting-started/
for PHP, You have to install Python 2.7 Version From https://www.python.org/downloads/release/python-2711/


Question: Where can i check my PHP Code?
http://localhost:8080/

Best Related Posts are Following:

1. PHP HTML5 video streaming examples.
2. What is Composer in php? - Manage the Dependencies.
3. Hadoop Basic Interview Questions and Answer.
4. Hadoop - Understanding Hadoop Architecture.
5. MongoDB Interview Questions and Answers.
6. Manage SPF Record - How to add SPF Record?.
7. How do you parse and process HTML in PHP.
8. Edit an commit message in Github Repository - Commands.
9. How do you disable browser Autocomplete on web form field / input tag?.
10. Web Development Project Manager interview questions and answers.
11. How to create Dynamic XML Sitemap online.
12. What is UPnP in Skype?.
13. How to delete Content of File in windows.
14. Difference between SSL and HTTPS.
15. SPDY Protocol - Improve the Speed of web page.