We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-446 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2005 |
| Exam Number: | 70-446 |
| Passing Score: | 700 (on a 1000-point scale) |
| Available Languages: | English, Japanese, Simplified Chinese, German, French |
| Real Exam Qty: | 40-60 |
| Related Certifications: | Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 Microsoft Certified IT Professional (MCITP): Business Intelligence |
| Exam Price: | USD 125 (varies by region) |
| Certificate Validity Period: | Legacy certification (retired, no longer actively renewed) |
| Exam Duration: | 120-150 |
| Exam Format: | Multiple Choice, Case Studies, Build List / Order, Simulation-based questions |
| Recommended Training: | Microsoft SQL Server 2005 BI Training Resources |
| Exam Registration: | Pearson VUE Exam Registration Microsoft Certification Portal (historical/legacy) |
| Sample Questions: | Microsoft 70-446 Sample Questions |
| Exam Way: | Proctored exam delivered via authorized testing centers (Pearson VUE) |
| Pre Condition: | Recommended: Basic knowledge of Microsoft SQL Server 2005, relational databases, and data warehousing concepts. Prior Microsoft certification (MCTS/MCSE equivalent knowledge) recommended but not strictly required. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/ |
Microsoft 70-446 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Designing Data Warehouse Solutions | - Fact and dimension table design - Data staging and ETL strategy - Dimensional modeling (star and snowflake schemas) |
| Security and Deployment Design | - Backup and disaster recovery planning - Authentication and authorization models - Deployment strategies for BI solutions |
| Planning and Designing a BI Solution | - Scalability and availability planning - Selecting BI architecture (OLAP vs OLTP integration) - Business requirements analysis for BI systems |
| Designing Reporting Solutions with SSRS | - Report design and delivery methods - Performance tuning of report execution - Security and access control for reports |
| Designing OLAP and SSAS Solutions | - MDX query design considerations - Aggregation strategies and partitioning - Cube design and dimensional modeling in SSAS |
| Designing ETL Processes with SSIS | - Performance optimization for SSIS packages - Data extraction and transformation workflows - Error handling and data cleansing |
By Buck
