Examen 70-455: Upgrade: Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer

Microsoft

Indien u reeds SQL 2005 BI bent gecertificeerd en u het upgrade examen 70-455 succesvol afrondt, beschikt u over de MCITP certificering Business Intelligence Developer 2008.

Doelgroep

Candidates for this exam are responsible for creating business intelligence (BI) solutions by using 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. This exam is intended for professionals who develop solutions by using the SQL Server 2008 BI tool suite.

Categorie

Microsoft SQL Server 2008

Tarief

€ 150,00 *
Exclusief € 28,00 administratiekosten indien u wel bij ons uw examen boekt, maar niet de bijbehorende training bij ons volgt.

Certificering / traject

Microsoft MCITP certificering

Inschrijven

Inschrijven voor examen 70-455 doet u via het online examenformulier.

Implementing an SSIS Solution

Implement control flow..This objective may include but is not limited to: checkpoints; debug control flow; transactions; implement the appropriate control flow task to solve a problem; data profiling and quality.
Implement data flow..This objective may include but is not limited to: debug data flow; implement the appropriate data flow components.
Implement package configurations

Configuring, Deploying, and Maintaining SSIS

Manage SSIS package execution..This objective may include but is not limited to: schedule package execution by using SQL Server Agent; execute packages by using DTEXEC; execute packages by using SQL Server Management Studio; execute packages by using the SSIS .NET API.
Configure SSIS security settings..This objective may include but is not limited to: MSDB database roles; package protection levels.
Identify and resolve issues related to SSIS solution deployment..This objective may include but is not limited to: validate deployed packages; deploy packages and dependencies between servers.

Implementing an SSAS Solution

Implement dimensions in a cube..This objective may include but is not limited to: translations; attribute relations; hierarchies.
Implement measures in a cube..This objective may include but is not limited to: measure groups.
Implement custom logic in a cube by using MDX. . This objective may include but is not limited to: actions; key performance indicators (KPI); calculated members; calculations.

Configuring, Deploying, and Maintaining SSAS

Configure permissions and roles in SSAS..This objective may include but is not limited to: server roles; SSAS database roles; cube roles; enable client application access; implement custom access to data.
Deploy SSAS databases and objects..This objective may include but is not limited to: Deployment Wizard; BIDS; SSMS; SSIS Analysis Services Execute DDL task.
Diagnose and resolve performance issues..This objective may include but is not limited to: use SQL Profiler; performance monitor counters; DMVs; Usage Based Optimization Wizard.

Implementing an SSRS Solution

Implement a report layout..This objective may include but is not limited to: apply conditional formatting; page configuration; headers and footers.
Implement report parameters..This objective may include but is not limited to: databound parameters; multi-value parameters.
Implement interactivity in a report..This objective may include but is not limited to: drilldown; drillthrough; interactive sorting.

Configuring, Deploying, and Maintaining SSRS

Configure report execution and delivery..This objective may include but is not limited to: subscriptions; report caching; schedules; snapshot history.
Install and configure SSRS instances.. This objective may include but is not limited to: deploy an SSRS Web farm.
Configure authentication and authorization for a reporting solution..This objective may include but is not limited to: configure server-level and item-level role-based security; configure Windows authentication and custom authentication.

Designing and Managing Reports

Design report architecture. This objective may include but is not limited to: linked reports, drill-down reports, drill-through reports, migration strategies, access report services API, sub reports, Code-Behind strategies.
Design a data acquisition strategy. This objective may include but is not limited to: data query parameters, creating appropriate SQL queries for an application (MDX queries), managing data rights and security, extracting data from Analysis Services, balancing query-based processing vs. filter-based processing, managing data sets through the use of stored procedures.
Define a report parameter strategy. This objective may include but is not limited to: report cache parameters, expressions, Code-Behind.

Designing Data Mining Models

Design a mining model and structure. This objective may include but is not limited to: assigning a data source, specifying filter properties, reconciling heterogeneous data sources, selecting a refresh strategy (partial or full).
Select data mining algorithms. This objective may include but is not limited to: sequence, clustering, time series, neural net, association, classification, decision tree.

Administering a BI Solution

Maintain server health. This objective may include but is not limited to: Resource Governor, performance counters, Analysis Server dynamic management views (DMV).
Design a backup strategy. This objective may include but is not limited to: offsite backup, setting up SSAS backup, Reporting Services backup (databases and keys).
Plan and manage upgrades. This objective may include but is not limited to: data migration, code migration, data security, parallel systems.

Designing the BI Architecture

Design integration between data visualization components. This objective may include but is not limited to: MOSS, SSRS, SSAS, designing Excel PivotTable reports, application architecture (Microsoft ASP.NET, Web Service, MicrosoftReportViewer Windows Forms control), Windows Mobile, other data visualization tools (Microsoft ProClarity, Microsoft PerformancePoint).
Design the data warehouse. This objective may include but is not limited to: datamarts, integrating legacy data, creating a dimensional model (star schema, snowflake, matrix bridge, conformed dimensions), utilizing upsert in design (TSQL-merge).
Design a security strategy. This objective may include but is not limited to: cube, project, reports (security roles, folders, field-level security), encryption keys, SQL services accounts management, encrypted data transmission, SSIS vs. SQL server authentication issues (derail Trojan attacks).

Designing and Deploying SSIS Packages

Design control flow. This objective may include but is not limited to: tasks and precedence constraints, fuzzy logic control, maintenance tasks, accessing remote data (Web services, FTP), using appropriate variables, data profile.
Design data flow. This objective may include but is not limited to: data transformation, blocking transformations (lookup task), extractions (design constraints), designing the load process, creating a package to load facts, creating an SSIS package to load dimension (SCD2), using capture CDC to locate changed data for SSIS.
Plan the deployment of SSIS packages. This objective may include but is not limited to: design the structure of packages, troubleshoot and design form problems with package, create a package that reports any errors to a log.

Designing an Analysis Services Database

Design cube architecture. This objective may include but is not limited to: creating and populating a cube, creating KPIs, actions, calculated members, drillthrough, designing SSAS aggregation, creating and manipulating dimensions (Ragged hierarchy, Flexible, Rigid, Semi-additive, Periodicity, Fact Relationships), selecting a processing mode.
Design and create business-driven Multidimensional Expressions (MDX) calculations. This objective may include but is not limited to: calculated measures, creating a named set in MDX.
Analyze cube performance. This objective may include but is not limited to: optimizing SSAS aggregation, query cube design.

Zie ook de Learning Catalog van Microsoft voor eventuele aanvullingen op de inhoud van dit examen.