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 (6)   |   Related Tips: More > Professional Development Certifications

Attend our free MSSQLTips Webcast - How to Simplify Routine SQL Server Administration Tasks


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:


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     



Wednesday, October 11, 2017 - 8:46:05 AM - Daniel Back To Top

You need to read a lot. You need to read at least 10 books and check troubleshooting problems.


Tuesday, October 10, 2017 - 6:59:26 PM - Khurram Back To Top

HI Rafael, 

I am currently using exam 70-463 book as a reference and the urls identified in this page. I do not know if that is sufficient enough or not. I planned to give the exam by the end of this month, however, some other thing came up and its not as easy as it seems so I have decided to give it by the end of next month. 

If you have appeared for the exam, do share you experience

 

 


Tuesday, October 10, 2017 - 7:36:41 AM - Rafael Lima de Souza Back To Top

Hello,
I did an official course, but the teacher said that studying for MOC was not enough, that I needed to get the Exam Ref books. What do you think?


Tuesday, October 03, 2017 - 10:13:21 AM - Khurram Back To Top

I am preparing for the exam, however I am unable to find a reliable source for practice exams, can you please update which brain dumps (practice tests) can best be suitable. Microsoft doesn't have any thing related to that. 

 

 


Tuesday, September 26, 2017 - 11:59:47 AM - Daniel Back To Top

 

 You are correct. The Azure stuff was removed and now is included in other certifications.


Tuesday, September 26, 2017 - 11:31:35 AM - Khurram Back To Top

Hi Daniel,

Thank you for above mentioned list. However when I was looking at the "https://www.microsoft.com/en-us/learning/exam-70-767.aspx". There are only 3 skills domains

1. Design, implement and maintain a datawarehouse (35%-40%)

2. Extract, transfrom, and load Data (40%-45%)

3. Build Data Quality Solutions (15%-20%)

There are no mentioning of Azure Related stuff   "Integrate solutions with cloud data and big data" . Further to this,  the updated list is also mentioned at http://download.microsoft.com/download/9/3/6/9367DBBC-1716-4E52-80FA-C65E0F56223F/OD_767_Changes.pdf. 

Now, I am confused as If I am looking the correct material for reference or is there an overlap.  

Kindly advice 

 

 

 

 

 


Learn more about SQL Server tools