ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What are Sql Reporting Services and  analysis services? Can 
u Explain
 Question Submitted By :: Dinesh Gupta
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are Sql Reporting Services and analysis services? Can u Explain
Answer
# 1
Sql Reporting Services :
-----------------------

Full Reporting Life Cycle Support
SQL Server Reporting Services supports the full reporting 
life cycle, including:

• Report authoring. Report developers can create reports to 
be published to a report server by using Microsoft or other 
design tools that use Report Definition Language (RDL), an 
XML-based industry standard used to define reports. 
 
• Report management. Report definitions, folders, and 
resources are published and managed as a Web service. 
Managed reports can be executed either on demand or on a 
specified schedule, and are cached for consistency and 
performance. New in SQL Server 2005 Reporting Services, 
administrators can use SQL Server Management Studio to 
organize reports and data sources, schedule report 
execution and delivery, and track reporting history. 
 
• Report delivery. SQL Server Reporting Services supports 
both on-demand (pull) and event-based (push) delivery of 
reports. Users can view reports in a Web-based format or in 
e-mail. 
 
• Report security. SQL Server Reporting Services implements 
a flexible, role-based security model to protect reports 
and reporting resources. The product includes extensible 
interfaces for integrating other security models as well.

Analysis Services :
------------------

SQL Server 2005 Analysis Services (SSAS) provides, for the 
first time, a unified and integrated view of all your 
business data as the foundation for all of your traditional 
reporting, online analytical processing (OLAP) analysis, 
Key Performance Indicator (KPI) scorecards, and data mining.
 
Is This Answer Correct ?    0 Yes 0 No
Selvaraj.v
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the advantages of using sql server over ms access or why should one use sql instead of ms access Impetus1
what is the difference between sql query and google query? TCS2
select empid empname from employee What is the result for the about query?  3
Hi..here i would like to know the Backup and Restore models? HCL2
What are cursors?  7
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? Yardi-Software2
What is the default value of CHAR type? Bosch6
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables? HP1
what is diffence between replicaion and logshipping?  1
how to know description of a table in sqlserver 2000  6
What are the steps you will take to improve performance of a poor performing query? HCL1
What is lock escalation?  1
How can i change the column name. HCL6
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer. Satyam3
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?  2
How to find the date and time of last updated table?  3
IN Vs OR operator which is best to use sql server.  3
select top 5 * from emp order by newid() my question is , how this query get executed?  2
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
Advantages and Disadvantages of Cursor? Zenith4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com