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.
Bạn đang xem 14. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P142 PDF