New book: Exam Ref 70-767 Implementing a SQL Data Warehouse

  • Article

We’re happy to announce the availability of Exam Ref 70-767 Implementing a SQL Data Warehouse (ISBN 9781509306473), by Jose Chinchilla and Raj Uchhana.

Purchase from these online retailers:

Microsoft Press Store Amazon Barnes & Noble Independent booksellers – Shop local

Overview

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.

Introduction

This Exam Ref is the official study guide for the new Microsoft 70-767 Implementing a SQL Data Warehouse certification exam. It offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully build modern data warehouses to support advanced business intelligence solutions.

The 70-767 exam focuses on the key elements of Data Warehousing using SQL Server 2016. It covers fundamental data modeling concepts, logical and physical database design and implementation. SQL Server Integration Services (SSIS) is covered in detail to provide IT professionals with a strong understanding of the SSIS control flow tasks and data flow transformations to support a ETL solution to load a data warehouse.

Master Data Services (MDS) and Data Quality Services (DQS) installation, configuration and development are also covered with step-by-step instructions to maintain master data and data quality solutions.

This book covers every major topic area found on the exam, but it does not cover every exam question. Only the Microsoft exam team has access to the exam questions, and Microsoft regularly adds new questions to the exam, making it impossible to cover specific questions. You should consider this book a supplement to your relevant real-world experience and other study materials. If you encounter a topic in this book that you do not feel completely comfortable with, use the “Need more review?” links you’ll find in the text to find more information and take the time to research and study the topic. Great information is available on MSDN, TechNet, and in blogs and forums.

Organization of this book

This book is organized by the “Skills measured” list published for the exam. The “Skills measured” list is available for each exam on the Microsoft Learning website: https://aka.ms/examlist.

Each chapter in this book corresponds to a major topic area in the list, and the technical tasks in each topic area determine a chapter’s organization. If an exam covers six major topic areas, for example, the book will contain six chapters.

Important: How to use this book to study for the exam

Certification exams validate your on-the-job experience and product knowledge. To gauge your readiness to take an exam, use this Exam Ref to help you check your understanding of the skills tested by the exam. Determine the topics you know well and the areas in which you need more experience. To help you refresh your skills in specific areas, we have also provided “Need more review?” pointers, which direct you to more in-depth information outside the book.

The Exam Ref is not a substitute for hands-on experience. This book is not designed to teach you new skills.

We recommend that you round out your exam preparation by using a combination of available study materials and courses. Learn more about available classroom training at https://www.microsoft.com/learning. Microsoft Official Practice Tests are available for many exams at https://aka.ms/practicetests. You can also find free online courses and live events from Microsoft Virtual Academy at https://www.microsoftvirtualacademy.com.

This book is organized by the “Skills measured” list published for the exam. The “Skills measured” list for each exam is available on the Microsoft Learning website: https://aka.ms/examlist.

Note that this Exam Ref is based on publicly available information and the author’s experience. To safeguard the integrity of the exam, authors do not have access to the exam questions.

About the authors

JOSE CHINCHILLA is Microsoft Certified Professional with dual MCITP certifications on SQL Server Database Administration and Business Intelligence Development. His career focus for the last 15+ years has been in Database Modeling, Data Warehouse and ETL Architecture, OLAP Cube Analysis, Master Data Management, Data Quality Frameworks and Big Data solutions. Jose has extensive experience in the architecture, development and implementation of both on-premise and Microsoft Azure cloud based Data Analytics solutions in several Fortune 500 companies. Jose has spoken at national and regional technical conferences such as PASS Summit, SQL Saturday, 24 Hours of PASS and other events such as Code Camps. He is the founder and CEO of Agile Bay, Inc and serves as President of the Tampa Bay Business Analytics User Group. Jose enjoys boating with his family and working on classic muscle cars.

RAJ UCHHANA is an enterprise data architect specializing in business intelligence, enterprise data warehousing, and Microsoft's Power BI. He's also an author, innovator and entrepreneur with more than 25 years of experience. He has also worked on Massively Parallel Processing (MPP) systems such as Analytics Platform System (formerly Parallel Data Warehouse), on which he built a 50TB data warehouse using hybrid and Kimball methodologies. Raj can be reached at Raj@BusinessIntelligenceNow.com or at https://BusinessIntelligenceNow.com.