Schedule exam
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.
Microsoft 70-463日本語 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 |
| Exam Number: | 70-463 |
| Available Languages: | Chinese (Simplified), English, French, Japanese, German, Portuguese (Brazil) |
| Exam Price: | USD 165 |
| Passing Score: | 700 |
| Real Exam Qty: | 40–60 |
| Exam Format: | Drag and drop, Multiple choice, Case studies |
| Exam Duration: | 120 minutes |
| Related Certifications: | MCSA: SQL Server 2012/2014 MCSE: Business Intelligence (retired path) MCSE: Data Platform (retired path) |
| Certificate Validity Period: | Retired (certification option no longer available after January 31, 2021) |
| Sample Questions: | Microsoft 70-463日本語 Sample Questions |
| Exam Way: | Delivered through Pearson VUE or Certiport testing centres |
| Pre Condition: | Recommended at least 2 years’ experience working with relational databases and T-SQL |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/answers/questions/68613/mcsa-retiring-jan-2021-equivalent-certification |
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.
Part of the requirements for: MCSA: SQL Server 2012/2014
Reference: https://www.microsoft.com/en-us/learning/exam-70-463.aspx
Microsoft 70-463日本語 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Extract, Transform, and Load Data | 20–25% | - Design data flow and control flow - Define connection managers |
| Topic 2: Load Data | 25–30% | - Use SSIS variables and parameters - Implement ETL logic |
| Topic 3: Build Data Quality Solutions | 15–20% | - Implement Data Quality Services (DQS) - Implement Master Data Services (MDS) |
| Topic 4: Configure and Deploy SSIS Solutions | 20–25% | - Implement logging, auditing, and error handling - Deploy SSIS packages |
| Topic 5: Design and Implement a Data Warehouse | 10–15% | - Implement a dimensional model - Design dimensions and fact tables |
We're so confident of our products that we provide no hassle product exchange.


By Marico

