Learn more about SQL Server tools

mssqltips logo
giveaway
 

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

Problem

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?

Solution

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:






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





More SQL Server Solutions











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