Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Exam material for the Microsoft 70-767 - Implementing a SQL Data Warehouse

By:   |   Read Comments   |   Related Tips: More > Professional Development Certifications

SQL Server Conference Giveaway - click to learn more


I am planning to take the Microsoft 70-767 exam which is focused on Data Warehouse using ETLs, implementing a data warehouse design, interacting with Azure technologies (Big Data, Azure DW, etc.) and maintaining the data with Data Quality Services (DQS). It seems very difficult to me. Do you have tips for this exam?


Yes. We are here to help. This tip is part of our SQL Server Professional Development Certifications Tips.

What is the Microsoft 70-767 certification exam?

It is an exam about creating a data warehouse using ETLs (Extract, Transform and Load), implement a data warehouse design, interact with Azure technologies (Big Data, Azure DW, etc.) and maintain the data with Data Quality Services (DQS).

Who should take the exam?

This is oriented to Business Intelligence (BI) developers, ETL developers and administrators.

Is it an exam oriented to SQL Server 2016?

Yes. 75% is SQL Server 2016 on-premises. 25% is about Azure Big Data, Azure SQL Data Warehouse and related topics.

Which SQL Server 2012/2014 exam is similar to this one?

It is similar to the exam 70-463. However, it added the Integrate with Cloud data and big data chapter and additional changes.

Is this exam difficult?

Yes. It requires learning several topics. If you already took the 70-463 exam, you will suffer only with Azure (which is cool and fantastic, but it requires time to learn all the topics). If you do not have experience in Business Intelligence technologies, you will need to study a lot. It requires a lot of knowledge to design and work with SQL Server Integration Services (SSIS), table design, performance, etc.

Which books would you recommend for this exam?

There are some books that may be helpful

Beware that the Azure world is constantly changing. Some books that are up to date now may be obsolete tomorrow. Make sure to have the latest edition and read the latest changes in the Azure SQL world.

Are there some courses for this exam?

Can you provide some links to study?

Of course. Here you have some links:

Design and implement a data warehouse

Extract, transform, and load data

Integrate solutions with cloud data and big data

Build data quality solutions

Next Steps

There are several links that will be useful to you:

Last Update:

signup button

next tip button

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 

SQL tips:

*Enter Code refresh code     

Learn more about SQL Server tools