整理一些與70-463這個科目考試相關的資料:

試題領域

  • 設計和實作資料倉儲 (11%)
  • 擷取和轉換資料 (23%)
  • 載入資料 (27%)
  • 設定和部署 SSIS 解決方案 (24%)
  • 建置資料品質解決方案 (15%)
Major TopicsPercent WeightSub-topics
Design and Implement a Data Warehouse11<ul><li>Design and implement dimensions</li><li>Design and implement fact tables</li></ul>
Extract and Transform Data23<ul><li>Define connection managers</li><li>Design data flow</li><li>mplement data flow - Manage SSIS package execution</li><li>Implement script tasks in SSIS</li></ul>
Load Data27<ul><li>Design control flow</li><li>Implement package logic by using SSIS variables and parameters</li><li>Implement control flow</li><li>Implement data load options</li><li>Implement script components in SSIS</li></ul>
Configure and Deploy SSIS Solutions24<ul><li>Troubleshoot data integration issues</li><li>Install and maintain SSIS components</li><li>Implement auditing, logging, and event handling</li><li>Deploy SSIS solutions</li><li>Configure SSIS security setting</li></ul>
Build Data Quality Solutions15<ul><li>Install and maintain Data Quality Services</li><li>Implement master data management solutions</li><li>Create a data quality project to clean data</li></ul>

AdventureWorks2012

AdventureWorks2012 範例資料庫的下載網址:
http://msftdbprodsamples.codeplex.com/releases/view/55330

AdventureWorks2012 OLTP

線上交易用的 AdventureWorks databases 有二種版本:

  • AdventureWorks2012_Data.mdf : for case-insensitive
  • AdventureWorks2012_CS_Data.mdf : for case-sensitive

另外也提供使用腳本安裝的版本:

  • AdventureWorks 2012 OLTP Script.zip : for case-insensitive
  • AdventureWorks 2012 CS OLTP Script.zip : for case-sensitive

AdventureWorksLT2012 則是精簡版的 AdventureWorks2012 .

AdventureWorks DW

AdventureWorks DW 是資料倉儲用的範例資庫,下載回來的範例資料庫檔,檔名為 AdventureWorksDW2012_Data.mdf ,安裝方法可參考以下網址: 下載與安裝 SQL Server 2012 範例程式,以 Adventure Works 資料庫為例

參考書目