Always Learning

Advanced Search

Exam Ref 70-767 Implementing a SQL Data Warehouse

Exam Ref 70-767 Implementing a SQL Data Warehouse

Jose Chinchilla, Raj Uchhana

Nov 2017, Paperback, 288 pages
ISBN13: 9781509306473
ISBN10: 1509306471
Special online offer - Save 30%
Was 31.99, Now 22.39Save: 9.60
  • Print pagePrint page
  • Email this pageEmail page
  • Share

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.

1. Design and Implement a Data Warehouse
2. Extract, Transform, and Load Data
3. Integrate Solutions with Cloud Data and Big Data
4. Build Data Quality Solutions

  • Authoritative and complete MCSA Exam 70-767 preparation content, straight from Microsoft
  • Covers data warehouse design and implementation; ETL processes; integration with cloud data and big data; and ensuring data quality
  • Organized by exam objectives for efficient study
  • Strategic, what-if scenarios challenge you as an exam candidate, helping you master the big-picture thinking the exam demands
  • Contains up-to-date exam preparation tips from a leader in the worldwide Microsoft BI and SQL Server communities

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