WHICH OF THE FOLLOWING IS THE SQL SERVER COMPONENT THAT PROVIDES T...

14. Which of the following is the SQL Server component that provides the ser-

vices for creating, processing, and managing OLAP and data mining?

A. Business Intelligence Developer Studio

B. SQL Server Management Studio

C. Windows PowerShell 2.0

D. SQL Server Database Engine

E. Analysis Services

Correct Answer & Explanation: E, Analysis Services. The SQL Server Database

Engine contains the services to manage and process relational and XML data.

Business Intelligence Developer Studio is used for managing all SQL Server

2008 components, including relational database and business intelligence (BI).

SQL Server Management Studio is used for administering and managing all

SQL Server 2008 components. Windows PowerShell 2.0 is a command-line

shell and Microsoft scripting language.