Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-767 Implementing a SQL Data Warehouse certification exam. Exam Ref 70-767 Implementing a SQL Data Warehouse 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. Coverage includes: Designing and implementing an effective data warehouse, including dimension tables, fact tables, indexes, storage, partitioning, and more Establishing successful processes for extracting, transforming, and loading data (ETL) with SQL Server Integration Services (SSIS) and Transact-SQL (T-SQL) Integrating solutions that encompass cloud data and big data, using Polybase Integrate, Hadoop Integrate, the Azure Blob service, and related tools Ensuring high levels of data quality with a Data Quality Services (DQS) knowledge base and a Master Data Services (MDS) model Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pro's job role For more information on Exam 70-767 and the MCSA: SQL 2016 Business Intelligence Development credential, visit microsoft.com/learning.