Microsoft

Implementing a Data Warehouse with SQL Server 2012 (70-463)

(70-463) / ISBN : 978-1-61691-227-7
Lessons
TestPrep
341 Reviews
Get A Free Trial

Skills You’ll Get

The Microsoft SQL Server certification is targeted at Extract-Transform-Load(ETL) and Data Warehouse Developers who can create Business Intelligence (BI) solutions. The MCSA 70-463 exam validates that the candidate has the skills and knowledge required to work with software installation (IS, management tools), development box and server; and installation of specifics for remote package execution.
Download Course Outline

1

Data Warehousing

  • Understanding Data Warehouses
  • Implementing Fact Tables
  • Implementing Dimensions
  • Summary
  • Chapter Essentials
2

SQL Server Integration Services

  • Integration Issues
  • Installing SSIS
  • Configuring SSIS Security Settings
  • Deploying Packages
  • SSIS Auditing and Event Handling
  • Extracting, Transforming, and Loading Data
  • Summary
  • Lesson Essentials
3

Data Quality Solutions

  • Understanding Data Quality Concerns
  • Installing Data Quality Services
  • Using Master Data Services
  • Cleaning Data
  • Summary
  • Chapter Essentials
A

Appendix A

  • Certification Objectives Map

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

There are no technical prerequisites for this certification.

USD 165

Microsoft

The exam consists of liner, fact based, drag and drop, hot area, and multiple-choice questions.

The exam contains 40-60 questions.

General Microsoft Certification exam retake policy

  1. If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam. At that time, candidates can log onto their certification dashboard and reschedule the exam themselves.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam a third time.
  3. A 14-day waiting period is also imposed between the third and fourth attempts and fourth and fifth attempts.
  4. A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is eligible to retake the exam 12 months from the date of their first attempt.
  5. To take a given exam more than five times per year or to have the time between attempts waived, a candidate must have experienced one of the errors listed below and request an exception from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests must include the following information:
    • Candidate ID
    • First/Last Name
    • Email associated with your Candidate ID
    • Exam Registration ID
    • Exam Number
    • Description of error
    • Pearson VUE case number

Exam retake exceptions will be granted for the following reasons:

  • Failure due to lab crash
  • Failure due to Internet connectivity issues
  • Failure due to equipment failure

For life

Know more about the 70-463

Implementing a Data Warehouse with SQL Server 2012 (70-463)

$159.99

Buy Now

Related Courses

All Courses