MS SQL Server 2012 Exam 70-460;Business Intelligence Developer 2008 to MCSE: Business Intelligence

Barely Passed!

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.

#2. Hotspot

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.

70-460

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.

Advertisements

Published by

Derek Dai

focusing DB, Big Data and BI tech.

3 thoughts on “MS SQL Server 2012 Exam 70-460;Business Intelligence Developer 2008 to MCSE: Business Intelligence”

  1. Hi Derek,

    Confused now… I thought the path to the SQL 2012 BI MCSE was through exams 461, 462, 463, 466 and 467. Where does this 460 fit in? Is that ONLY if you are considering an upgrade from your 2008 certs?

    Scott.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s