Exam Ref 70-767 Implementing a SQL Data Warehouse - Softcover

Chinchilla, Jose

Softcover

ISBN 10: 1509306471 ISBN 13: 9781509306473

Publisher: Microsoft Press, 2017

Synopsis

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.

About this title

About the Author

Jose Chinchilla is the President of Agile Bay. He writes and speaks about SQL Server administration and performance, data warehousing, business intelligence, predictive analytics and big data. Raj Uchhana is an enterprise data architect specializing in business intelligence, enterprise data warehousing, and Microsoft's Power BI. Raj can be reached at: Raj@BusinessIntelligenceNow.com

Edition details

• Publisher: Microsoft Press
• Publication date: 2017
• ISBN 10: 1509306471
• ISBN 13: 9781509306473
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 288