Exam Ref 70-767 Implementing a SQL Data Warehouse

Exam Ref 70-767 Implementing a SQL Data Warehouse

3 reviews
Published by Microsoft Press
Published Nov, 2017
ISBN 10 1509306471
ISBN 13 9781509306473
Pages 288
QR code for Exam Ref 70-767 Implementing a SQL Data Warehouse

Description of Exam Ref 70-767 Implementing a SQL Data Warehouse


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

Table of Contents


Chapter 1 Design and implement a data warehouse
Chapter 2 Extract, transform, and load data
Chapter 3 Build data quality solutions

Related Books

Arduino Android Blueprints

Arduino Android Blueprints

Ajax and REST Recipes: A Problem-Solution Approach (Expert's Voice)

Ajax and REST Recipes: A Problem-Solution Approach (Expert's Voice)

Rule-Based Modeling and Computing on the Semantic Web: 5th International Symposium, RuleML 2011 - America, Ft. Lauderdale, FL, USA, November 3-5, 2011, Proceedings (Lecture Notes in Computer Science)

Rule-Based Modeling and Computing on the Semantic Web: 5th International Symposium, RuleML 2011 -...

Microsoft Power BI Cookbook: Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards

Microsoft Power BI Cookbook: Creating Business Intelligence Solutions of Analytical Data Models, ...

Speech and Language Processing for Human-Machine Communications: Proceedings of CSI 2015

Speech and Language Processing for Human-Machine Communications: Proceedings of CSI 2015

Ensemble Methods: Foundations and Algorithms (Chapman & Hall/CRC Data Mining and Knowledge Discovery Serie)

Ensemble Methods: Foundations and Algorithms (Chapman & Hall/CRC Data Mining and Knowledge Discov...