商品描述
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 考試，並幫助展示您在管理資料倉庫方面的實際技能。這個考試適用於創建商業智能解決方案的 Extract, Transform, Load (ETL) 資料倉庫開發人員。他們的責任包括數據清理、ETL 和資料倉庫實施。讀者應該具有安裝和實施主數據服務 (MDS) 模型、使用 MDS 工具以及創建主數據管理器數據庫和 Web 應用程序的經驗。讀者應該了解如何設計和實施 ETL 控制流元素，並使用 SQL Service Integration Services 包進行工作。
專注於這些目標所衡量的專業知識：
• 設計、實施和維護資料倉庫
• 提取、轉換和加載數據
• 構建數據質量解決方案
這本 Microsoft "考試參考書"：
• 根據考試目標組織其內容
• 提供策略性的假設情境來挑戰您
• 假設您具有關聯式數據庫技術和增量數據庫提取的工作知識，以及設計 ETL 控制流、使用和調試 SSIS 包、從多個來源訪問和導入或導出數據，以及管理 SQL 資料倉庫的經驗。
實施 SQL 資料倉庫
關於考試
考試 70-767 著重於與關聯式數據庫技術相關的技能和知識。
關於 Microsoft 認證
通過此考試將為您賺取 Microsoft 認證專業 (MCP) 或 Microsoft 認證解決方案聯盟 (MCSA) 認證，以展示您在資料倉庫管理方面的專業能力。
通過此考試以及考試 70-768 (開發 SQL 資料模型) 將為您賺取 Microsoft 認證解決方案聯盟 (MCSA) SQL 2016 商業智能 (BI) 開發認證。
詳細資訊請參閱：microsoft.com/learning
