Study material for exam 70-767 Implementing a SQL Data Warehouse

By:   |   Comments (9)   |   Related: 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:



sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips


Comments For This Article




Monday, July 15, 2019 - 8:40:41 AM - Abdulmuttalib Kabani Back To Top (81748)

"Integrate solutions with cloud data and big data" has been excluded.

As of March 2017, this exam was updated. To learn more about these changes and how they affect the skills measured, please download and review the exam 70-767 change document.

https://www.microsoft.com/en-us/learning/exam-70-767.aspx

Wednesday, November 7, 2018 - 7:55:11 AM - David Phu Back To Top (78180)

 Very helpful tips.  Thanks

 

 

Thursday, March 8, 2018 - 7:12:49 PM - Blair Back To Top (75378)

Looking at the link to slowly changing dimensions

http://datawarehouse4u.info/SCD-Slowly-Changing-Dimensions.html

 

This website explains a type 6 being a combination of type 1,2 and 3.

However the Kimbal website states that type 6 only includes type 1 and 2.

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/type-6/

 

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

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 (67172)

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 (67150)

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 3, 2017 - 10:13:21 AM - Khurram Back To Top (66844)

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 (66624)

 

 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 (66619)

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 

 

 

 

 

 














get free sql tips
agree to terms