MCTS: SQL Server 2008, Business Intelligence Development and Maintenance

Candidates for this exam are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:

• One to two years of experience working with the Microsoft .NET Framework
• Two to three years of experience using SQL Server 2005 BI components
• Six months to one year of experience using SQL Server 2008
• Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
• Experience using Microsoft SQL Server Management Studio (SSMS)
• Knowledge of relational and multi-dimensional database schemas
• Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
• Experience creating and deploying a data mining model in SSAS
• Experience writing relational and multi-dimensional database queries
• Experience creating and deploying SQL Server Reporting Services (SSRS) reports
• Experience authoring and deploying SQL Server Integration Services (SSIS) packages
• Experience debugging, monitoring, and troubleshooting BI solutions