This SQL BI exam(the most challenging one I ever met) includes 2 sections as well and your final score is the lower one. For example, in my case, I got 900 in BI solution design section but 700 in Reports section. My final score, the lowest one in this series, was 700, if there were one more wrong in reports section, I have to re-take this exam.
Anyway, still a good news that I obtained all SQL Server 2012 certificates available in market( SQL 2012 MCM not yet published).
Something for your reference.
There are 2 sections as well and it scores separately. Your final score is the lower one. if it is less than 700, you have to pay usd150 again if you intend to retake it.
Question types are pretty same as 70-459. There are four types,
#1. Drag and Drop
For example, you are given 7 boxes. In every box, it is an action. The question requests you to achieve the function how to make cube online as soon as possible. So you need to place the right boxes from left side to right side in a correct sequence.
Partition–>Storage setting–>Bring online as soon as possible.
Given a cube edit UI, please spot which button is the right place to configure “change user” or which measure aggregation is for average. These are the real questions I met this morning.
#3. multiple choice, could be only one choice or tow choices are correct. It tells you clears.
#4. Case study.
This time, my memory serves me accurately. 3 cases studies and each follows 5 multiple questions.
All questions(Totally 49 questions for both sections) today came to me in this sequence.
- Case study #1, foll0wed by five multiple-choice questions
- 9 other questions
- then case study #2 and #3, each followed by 5 multiple-choice questions.(Eg. according to requirement, how to archive the HA for SSAS, how to re-estatblish reporting service subscription)
- then 15 other questions.
Hope this information for the potential exam takers is helpful. Any other questions, please leave comments or email. Will help and reply as soon as possible.