|
This exam tests knowledge and understanding of the data modeling techniques used in design of Data Warehousing and Business Intelligence applications.
You will be tested in these areas:
- The basics of Entity-Relationship (ER) and dimensional modeling
- Purpose and benefits of dimensional modeling
- Basic concepts and terminology of dimensional modeling
- Understanding facts and dimensions
- Understanding dimensional schemas
- Understanding hierarchies
- Various advanced topics in dimensional modeling, including slowly-changing and rapidly-changing dimensions, casual dimensions, multi-valued dimensions, junk dimensions, etc.
The exam consists of 25 carefully crafted questions of different kinds and degrees of difficulty. This removes the element of luck that is common in exams that consist entirely of multiple choice questions. You are required to complete the exam in one sitting in 50 minutes. You are allowed three attempts to achieve a passing score of 70%. Each attempt at an exam, however, will present you with a different set of questions than previous attempts.
The exam is intended to be quite challenging and requires reasonable mastery of the course material. We recommend that you take DW and BI Data Modeling course by Rick Sherman and review it multiple times before taking the exam.
Once you pass the exam, you will receive a Certificate of Education documenting that you have demonstrated mastery of the topic. Further, the exam counts towards CIMP – Data Modeling and Metadata Management certification track and can be used as an elective exam in any other CIMP track. Click here to learn more about CIMP.
|
 |
Additional Information |
 |
 |
Number of Questions:
25
Time Limit:
50 Minutes
Passing Score:
70%
|
 |
 |
 |
 |
|