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
|
Selection | File type icon | File name | Description | Size | Revision | Time | User |
| Configuring, Deploying, and Maintaining SSAS |
---|
Selection | File type icon | File name | Description | Size | Revision | Time | User |
| Configuring, Deploying, and Maintaining SSIS |
---|
Selection | File type icon | File name | Description | Size | Revision | Time | User |
| Configuring, Deploying, and Maintaining SSRS |
---|
Selection | File type icon | File name | Description | Size | Revision | Time | User |
Selection | File type icon | File name | Description | Size | Revision | Time | User |
Selection | File type icon | File name | Description | Size | Revision | Time | User |
Selection | File type icon | File name | Description | Size | Revision | Time | User |
|