Multiple choice technology databases

SQL Server 2005 has the ability to improve business intelligence. Which features help to achieve this?

  1. (a) Data Migration

  2. (b) Improved analytical capabilities

  3. (c) Smaller Data engine

  4. (d) Superior Integration properties
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

SQL Server 2005 enhanced Business Intelligence through key capabilities. Data Migration via Integration Services (SSIS) enables ETL operations. Improved analytical capabilities come from Analysis Services (SSAS) with enhanced OLAP and data mining. Superior Integration properties refer to better integration with other applications and Office. A smaller data engine is not a BI feature.

Keep practicing — related questions