Jose ChinchillaRaj Uchanna - Exam Ref 70-767 Implementing a SQL Data Warehouse

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 .

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

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 chapters organization. If an exam covers six major topic areas, for example, the book will contain six chapters.

Microsoft certifications distinguish you by proving your command of a broad set of skills and experience with current Microsoft products and technologies. The exams and corresponding certifications are developed to validate your mastery of critical competencies as you design and develop, or implement and support, solutions with Microsoft products and technologies both on-premises and in the cloud. Certification brings a variety of benefits to the individual and to employers and organizations.

Jose Chinchilla This book couldnt have been possible without the support and understanding from the entire editorial and production team, with special thanks to Trina MacDonald (Pearson) and Troy Mott (Backstop Media). It has been a long journey together.

Special thanks to my wife, Madeline, for providing me with the warmth, love and support that fueled the light in my life that allowed me to keep writing through many nights. To my children, Sofia, Stephanie and Sebastian, for filling my life with love and happiness and for reminding me everyday that there is so much out there to enjoy together.

Raj Uchhana My genuine appreciation for the dedication and patience of our publisher and editorial staff. Our editor, Trina MacDonald, a true professional and a friend all wrapped up in one, who orchestrated this book into existence. To Troy Mott, the Development Editor, for his tireless reviews and valuable suggestions. And to the Pearson Publishing house for giving us the privilege of spreading knowledge and learning. Finally, my gratitude to Jose Chinchilla, co-author, for all his assistance. He has genuine care and generosity for everyone.

Build your knowledge of Microsoft technologies with free expert-led online training from Microsoft Virtual Academy (MVA). MVA offers a comprehensive library of videos, live events, and more to help you learn the latest technologies and prepare for certification exams. Youll find what you need here:

https://www.microsoftvirtualacademy.com

Throughout this book are addresses to webpages that the author has recommended you visit for more information. Some of these addresses (also known as URLs) can be painstaking to type into a web browser, so weve compiled all of them into a single list that readers of the print edition can refer to while they read.

Download the list at https://aka.ms/examref767/downloads.

The URLs are organized by chapter and heading. Every time you come across a URL in the book, find the hyperlink in the list to go directly to the webpage.

Weve made every effort to ensure the accuracy of this book and its companion content. You can access updates to this bookin the form of a list of submitted errata and their related correctionsat:

https://aka.ms/examref767/errata

If you discover an error that is not already listed, please submit it to us at the same page.

If you need additional support, email Microsoft Press Book Support at .

Please note that product support for Microsoft software and hardware is not offered through the previous addresses. For help with Microsoft software or hardware, go to