Exams

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server

Important

This exam retired on January 31, 2021. For currently available options, please refer to the Browse Certifications and Exams page.

 
This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

Important

As of February 18, 2016, this exam includes content covering both SQL Server 2012 and 2014. Please note that this exam does not include questions on features or capabilities that are present only in the SQL Server 2012 product. For more information, please download and review this document.

Part of the requirements for: MCSE: Data Management and Analytics

Related exams: none

Go to Learn Profile

Schedule exam

  • 70-466: Implementing Data Models and Reports with Microsoft SQL Server

    Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)

    Retirement date: **

    This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

    Price based on the country or region in which the exam is proctored.

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    for Implementing Data Models and Reports with Microsoft SQL Server

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Skills measured

  • Build an analysis services multidimensional database (35-40%)
  • Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database (15-20%)
  • Build a tabular data model (15-20%)
  • Build a report with SQL Server Reporting Services (SSRS) (25-30%)

Download exam skills outline

Two ways to prepare

Items in this collection

  • Learning paths or modules are not yet available for this certification

There may be certifications and prerequisites related to "Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server"

  • MCSE: Data Management and Analytics

    Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data - both on-premises and in cloud environments.

Exam resources

Exam Replay

Boost your odds of success with this great offer.

Your certifications

Review and manage your scheduled appointments, certificates, and transcripts.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Certified Trainers and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.