SQL Server 2005 Analysis Services

SQL Server 2005 Analysis Services interview questions

<<Previous  Next>> What is SQL Server 2005 Analysis Services (SSAS)? SSAS gives the business data an integrated view. This integrated view is provided by combining online analytical processing (OLAP) and data mining functionality................ Read answer What are the new features with SQL Server 2005 Analysis Services (SSAS)? It offers interoperability with Microsoft office 2007. It eases data mining by offering better data mining algorithms and enables better predictive analysis................... Read answer What are SQL Server Analysis Services cubes? In analysis services, cube is the basic unit of storage. A cube has data collected from various sources that enables faster execution of queries. Cubes have dimensions and measures................ Read answer Explain the purpose of synchronization feature provided in Analysis Services 2005. Synchronization feature is used to copy database from one source server to a destination server. While the synchronization is in progress, users can still browse the cubes................. Read answer MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language, Explain MDX in SQL server 2005 Analysis services offers CASE and SCOPE statements. CASE returns specific values based upon its comparison of an expression to a set of simple expressions. It can perform............. Read answer Can you explain how to deploy an SSIS package? A SSIS package can be deployed using the Deploy SSIS Packages page. The package and its dependencies can be either deployed in a specified folder in the file system or in an instance of SQL server............... Read answer Can you explain the difference between the INTERSECT and EXCEPT operators? INTERSECT returns data value common to BOTH queries (queries on the left and right side of the operand). On the other hand, EXCEPT returns the distinct data value from the left query (query on left side of the ................. Read answer What is the new error handling technique in SQL Server 2005? Previously, error handling was done using @@ERROR or check @@ROWCOUNT, which didn’t turn out to be a very feasible option for fatal errors. New error handling technique in SQL Server 2005 provides a TRY ............... Read answer What exactly is SQL Server 2005 Service Broker? Servive brokers allow build applications in which independent components work together to accomplish a task. They help build scalable, secure database applications. The brokers provide a message based .................. Read answer Explain the Service Broker components. Service broker components help build applications in which independent components work together to accomplish a task. These applications are independent, asynchronous and the components work together............. Read answer What is a breakpoint in SSIS? How is it setup? How do you disable it? Breakpoints allow the execution to be paused in order o review the status of the data, variables and the overall status of the SSIS package. Breakpoints in SSIS are set up through the BIDS wizard. In this wizard,.............. Read answer <<Previous  Next>> Also read What is XPath? XPath is a language for addressing an XML document's elements and attributes. As an example, say you receive an XML document that contains the details of a shipment and you want to retrieve the element/attribute values from the XML document......... How to transfer or export SQL Server 2005 data to Excel This chapter shows you how to create a package that can transfer data from a table in an SQL Server 2005 Server database to a Microsoft Excel Spreadsheet............ SQL Server 2005 XML support Explain the concepts and capabilities of SOAP. Explain the purpose of Native XML mode in SQL Server 2005. Native XML Access vs. SQLXML. Benefits of Native XML Access in SQL Server 2005. Limitation for Native XML Web Services. XML Data type implementation in SQL Server 2005 What is Untyped XML? Provide examples for : Create a table with a untype XML column, Insert into an untyped XML data type column What is typed XML? The XML data type comes with five methods. Explain them Differentiate between Untyped XML and Typed XML. Explain with an example how to apply defaults constraint to an XML data type column. You can add constraints to XML data type columns. Illustrate with an example. Describe in brief exporting and importing utility? Answer - The Bulk Copy is a command utility that transfer SQL data to or from a data file. This utility mostly used to transfer huge data to SQL server from other database.... Define Distributed Query and Linked Server? Answer - Distributed Query is a query which can retrieve data from multiple data sources including distributed data........ Define temporary and extended stored procedure. Answer - Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted...... Define Primary and Unique key. Answer - The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table..... Transferring a View from Oracle 10G XE to an SQL Server 2005 Database Here you will learn how to copy a table on an Oracle 10G XE database to a database on the SQL Server 2005. You will also learn how to install an Oracle 10G XE server and work with its database objects.