Exam Ref 70-767 Implementing a SQL Data Warehouse



Bookstore > Books > Exam Ref 70-767 Implementing a SQL Data Warehouse

Price$31.25 - $34.53
Rating
AuthorsJose Chinchilla, Raj Uchhana
PublisherMicrosoft Press
Published2017
Pages288
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509306471
ISBN-139781509306473
EBook Hardcover Paperback

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 solutions.

This 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.

Exam 70-767 focuses on skills and knowledge required for working with relational database technology.


  1. (2 books)


4 5 29

Similar Books


Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions, 2nd Edition

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions, 2nd Edition

by Michael Washam, Rick Rainey, Dan Patrick, Steve Ross

Prepare for the newest versions of Microsoft Exam 70-533 - and help demonstrate your real-world mastery of implementing Microsoft Azure Infrastructure as a Service (IaaS). Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the ...

Price:  $31.61  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions

Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions

by Michael Washam, Rick Rainey

Prepare for Microsoft Exam 70-533 - and help demonstrate your real-world mastery of Microsoft Azure infrastructure solution implementation. Designed for experienced IT pros ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Specialist level.Exam 70-533 fo...

Price:  $42.30  |  Publisher:  Microsoft Press  |  Release:  2015

Exam Ref 70-761 Querying Data with Transact-SQL

Exam Ref 70-761 Querying Data with Transact-SQL

by Itzik Ben-Gan

Prepare for Microsoft Exam 70-761 - and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA le...

Price:  $34.25  |  Publisher:  Microsoft Press  |  Release:  2017

Exam Ref 70-764 Administering a SQL Database Infrastructure

Exam Ref 70-764 Administering a SQL Database Infrastructure

by Victor Isakov

Prepare for Microsoft Exam 70-764 - and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate effici...

Price:  $30.24  |  Publisher:  Microsoft Press  |  Release:  2017

Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

by Daniil Maslyuk

Prepare for Microsoft Exam 70-778 - and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the exp...

Price:  $31.30  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

by Chris Sorensen

Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. ...

Price:  $31.97  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition

Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition

by Orin Thomas

Prepare for Microsoft Exam 70-346, and demonstrate your real-world mastery of the skills needed to provision, manage, monitor, and troubleshoot Microsoft Office 365 identities and cloud services. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed...

Price:  $28.78  |  Publisher:  Microsoft Press  |  Release:  2017

Exam Ref 70-745 Implementing a Software-Defined DataCenter

Exam Ref 70-745 Implementing a Software-Defined DataCenter

by Jeff Graves, Joel Stidley

Prepare for Microsoft Exam 70-745 - and help demonstrate your real-world mastery of skills needed to build and manage software-defined infrastructure with Windows Server 2016 and System Center 2016 Virtual Machine Manager (SC VMM). Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical th...

Price:  $36.60  |  Publisher:  Microsoft Press  |  Release:  2017