Certification Update: SQL Server 2014

Larry Kaye

To help students stay current with upcoming release of SQL Server 2014, all MCSE-level SQL exams (464 through 467) will be updated on April 24, 2014 to cover solutions based on both SQL Server 2012 and 2014 products.

The MCSA: SQL Server 2012 credential and associated exams (461/462/463) will remain in market without alterations.  No MCSA: SQL Server 2014 credential will be released.

Details on the exam updates, in the form of side-by-side comparisons of exam objectives, are now available for review through the "content covering SQL Server 2014" link in the Skills Measured section of each Exam Detail web page:

Please note that, while the exam numbers will not change, the product version (2012) will be removed from the titles of the exams.  Updated Microsoft Official Courseware (MOC) will be available in May 2014.

Whether you have started on the path to earning your certification or are just about to begin, we recommend that you continue moving forward. For certifications on SQL Server 2012, the exams you take now will still count towards your certification.

 For the latest information on upcoming changes to the certifications and related exams, please review our SQL Server FAQ.

  • Mark Fitzgerald (Fitz)
    | |

    Just a few questions related to the timing and content of the documents as linked.

    1. In the 70-464 document outlining the changes under the heading of create and alter tables there is a requirement to "Implement on-line tables", is this supposed to be "In-Memory OLTP tables"?

    2. In the 70-465 document outlining the changes under the heading of design tables there is a requirement for "common store indexes", is the supposed to be "columnstore indexes"?

    3. In the 70-465 document (and the original web page) one of the subheadings is "Design database, schema and object security parameters", should "parameters" be replaced with "permissions"?

    4. In the 70-467 document  a requirement to know about "balanced data distributor" has been added.  Is this transform to be added as standard in a future release or is the exam to cover possible add-ins to the core products?

    5. How is MSL looking for the SQL instructors to cover the SQL 2014 materials within the SQL 2012 classes given that delegates who will take the exams after 24/04/2014 will be tested on subjects not covered in the courses?  This is a consequence of the SQL 2014 courses not being available when the exams change over.

    Mark Fitzgerald

  • Larry Kaye
    | |

    Hi, Mark:

    Thanks for the feedback.

    Regarding Points 1-4:

    - I couldn't find the verbiage you mentioned in Point 1 - please leave another comment with the full objective text you see.

    - I have submitted your questions on Points 2-4 to our exam development team and will provide feedback when received.

    Regarding Point 5:

    - Per my response to your similar question in our forum:

    For the period between exam and course update releases, we encourage both MCTs and their students to utilize the MVA Jump Start courses on SQL Server 2014 features found here:


    Also, as we get closer to product launch, virtual labs will be available here:



  • Mark Fitzgerald (Fitz)
    | |

    Hi Larry,

    Following each of the links on this page leads to the related exam page.  The PDF documents that are linked on each of these pages "Starting April 24, 2014, the questions on this exam will include content covering SQL Server 2014.", is where the issues can be seen.

    1. Implement database objects (30-35%)

    Create and alter tables (complex statements)

    Added sub-tasks:

     create calculated columns

     implement partitioned tables, schemas, and functions

     implement column collation

     implement On-Line OLTP <--- In-Memory OLTP?


  • Kiran Ala
    | |


    Do we have to re-take 464 and 465 for SQL 2014 ,If we already have a MCSE -SQL Data Platform? Do we have an upgrade path to the SQL 2014 from SQL 2012(MCSE-SQL Data Platform)?

  • Larry Kaye
    | |


    Per your inquiry, I have confirmed with our exam development team:

    1. Should read "In-Memory OLTP"

    2. Should read "columnstore indexes"

    3. Should read "permissions"

    4. The exam can cover possible add-ins to the core products. The balanced data distributor is available for download at: www.microsoft.com/.../details.aspx

    Thanks for your feedback - I will be making the appropriate updates to our documentation.

  • Larry Kaye
    | |


    If you already have the MCSE: Data Platform credential, you do not have to re-take Exams 464 and 465.   We will be providing an update on recertification requirements within the next few months.  

    There are no SQL Server 2012 to 2014 upgrade exams currently planned.  However, you will be able to obtain details on the new features from the Microsoft Virtual Academy Site (mva.microsoft.com).  Once at the site, select SQL Server under the Courses By Products heading, and, then, select the 2014 tab for a list of relevant training.


  • Davin Mickelson
    | |

    Hi, Larry.

    The MCSE: Business Intelligence title is interesting to me.

    It sounds like I could hurry and pass the two Pro exams (70-466 and 70-467) before April to take them while they are SQL 2012 exams. However, I have plenty of time to take the first three MCSA exams. I wonder how much time I would have...

    I know the three-year recertification timer will start when I pass the fifth exam. That could be in 2015, if I choose. Am I correct or is Microsoft planning some kind of time window that will require me to pass all required exams in a certain period?

    Are we getting closer to the recertification specs being finalized?

    Thank you again in advance, Larry.

  • Davin Mickelson
    | |

    Sorry - I missed your answer right above my comment about recertification.


  • Dennis
    | |

    What about the upgrade exam for Transition Your MCITP on SQL Server 2008 to MCSE: Data Platform Exam 70-459 and its BI counter part 70-460?  Will they be upgraded with SQL 2014?  Or will they be retired (I read that earlier some where)?

  • Larry Kaye
    | |

    @Davin - Yes, you are correct that your recertification period will begin once you have passed all of the component exams.

    @Dennis - We are currently evaluating exams 70-459 and 70-460 for update.  I will provide more details when available.

  • Mazhar Samo
    | |

    Hi Larry,

    I have got my 459 exam booked this week. Should I expect any questions related to SQL 2014?


  • Larry Kaye
    | |


    Per my previous post, we are currently evaluating exams 70-459 and 70-460 for updates to include SQL Server 2014 content.  At this time, the exams remain focused solely on SQL Server 2012.


  • a10c7c0f-5b02-471c-a821-9aad71230a1a


    is it worth waiting until the 2014 questions have been added instead of completing the 464 and 465 exams now or is it better to do the 2012 version now and have to take any update exams later? I think I would prefer to just get the 2014 version but if the MCSE will not show the version then I might as well just do the 2012 exams.


  • John Deardurff (Regional Lead - USA)

    That is a mixed question Charles. The SQL cert will still be the same, but they will remove the version from the title. And with the SQL Server titles, Microsoft requires to recertify every three years anyway. Might as well do it now... You are going to have to do it again in 3 years anyway.

  • Dennis
    | |

    Are the exams exams 70-459 and 70-460 going to be retired as I read someone in the past?  Or will they be valid for their respective SQL certifications?

View All