If you wait until 2 minutes into this 80s hair band song, you will get what comes to mind when I started studying for this test. I think I first heard it when I was introduced to the band Metal Rose last year, but I can’t find their cover of it. Anyway, this is the last exam of the series, the Data Warehouse one. This is the test that online all of the DBA types don’t like because you have to know about Building a Data Warehouse, SSIS, and ETL. Here’s a link to the http://www.microsoft.com/learning/en-us/exam-70-463.aspx
I thought this was the most fun. After all this is the BI exam, which is what I like to do and as an added bonus I thought the Microsoft training book was really good. If you are studying for the exam or interested in Data warehousing in SQL Server, I think it is a good read.
Is it worth it?
The question I get asked about certifications is: Are they worth it? I have been thinking about that and I the answer I have is, I don’t know. Personally, I find that if I have a reason to go learn something, I will. Studying for an exam provides a reason. The exam is like a bowling pin, it is a target to knock down. If I didn’t study for this test would I have become interested figuring out how to apply Master Data Management? Probably not, but that’s the sort of thing I got out of it. A test is just a reason to learn new things about SQL Server and the piece of paper and the logos, is an added bonus. I downloaded my Official Logos and Paper copy of the cert just to make it official. I even framed it.
I now have a process for how I can pass the tests, which involves me creating my own book in word, and studying it. This is the first time that I found the book to be the best source on the topic, so I just wrote down the pages that I thought I should study in my notes. This time I remembered to list all of the web pages that I copied so that anyone could see where the original text came from. I thought I’d share it, as I am feeling good about being done with this as cert. If you find it helpful, let me know.
Design and implement a data warehouse (11%)
Extract and transform data (23%)
Load data (27%)
Configure and deploy SSIS solutions (24%)
Build data quality solutions (15%)
Data aficionado et SQL Raconteur