相關主題
商品描述
Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package.
Focus on the expertise measured by these objectives:
• Design, and implement, and maintain a data warehouse
• Extract, transform, and load data
• Build data quality solutionsThis Microsoft Exam Ref:
• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse.
Implementing a SQL Data Warehouse
About the Exam
Exam 70-767 focuses on skills and knowledge required for working with relational database technology.
About Microsoft Certification
Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management
Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification.
See full details at: microsoft.com/learning
商品描述(中文翻譯)
準備 Microsoft 考試 70-767 – 並幫助展示您在管理資料倉儲方面的實際技能掌握。此考試針對提取、轉換、加載（ETL）資料倉儲開發人員，這些開發人員負責創建商業智慧（BI）解決方案。他們的職責包括資料清理以及 ETL 和資料倉儲的實施。讀者應具備安裝和實施主資料服務（Master Data Services, MDS）模型的經驗，使用 MDS 工具，並創建主資料管理器資料庫和網頁應用程式。讀者應了解如何設計和實施 ETL 控制流程元素，並使用 SQL Server 整合服務（SQL Server Integration Services, SSIS）包進行工作。
專注於這些目標所測量的專業知識：
• 設計、實施和維護資料倉儲
• 提取、轉換和加載資料
• 建立資料品質解決方案
這本 Microsoft 考試參考：
• 按考試目標組織其內容
• 提供策略性、假設情境以挑戰您
• 假設您具備關聯資料庫技術和增量資料提取的工作知識，以及設計 ETL 控制流程、使用和除錯 SSIS 包、從多個來源訪問和導入或導出資料的經驗，並管理 SQL 資料倉儲。
實施 SQL 資料倉儲
關於考試
考試 70-767 專注於與關聯資料庫技術相關的技能和知識。
關於 Microsoft 認證
通過此考試可獲得 Microsoft 認證專業人員（Microsoft Certified Professional, MCP）或 Microsoft 認證解決方案助理（Microsoft Certified Solutions Associate, MCSA）認證的學分，這證明您在資料倉儲管理方面的專業知識。
通過此考試以及考試 70-768（開發 SQL 資料模型）可獲得 Microsoft 認證解決方案助理（MCSA）SQL 2016 商業智慧（BI）開發認證的學分。
查看完整詳細資訊：microsoft.com/learning
