Exams

Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Warning

Arabic, Indonesian, and Russian versions of this exam will retire on February 28, 2023.

Candidates for this exam should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.

Important

The English language version of this exam will be updated on February 6, 2023. Please download the study guide in the “Tip” box for details on upcoming changes. If a localized version of this exam is available, it will be updated approximately eight weeks after this date. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of this exam are not updated on this schedule.

Passing score: 700. Learn more about exam scores.

Tip

Part of the requirements for: Microsoft Certified: Azure Enterprise Data Analyst Associate

Related exams: none

Go to Learn Profile

Schedule exam

  • DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

    Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Russian, Arabic (Saudi Arabia), Chinese (Traditional), Italian, Indonesian (Indonesia)

    Retirement date: none

    This exam measures your ability to accomplish the following technical tasks: implement and manage a data analytics environment; query and transform data; implement and manage data models; and explore and visualize data.

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

    for Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

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

Skills measured

  • The English language version of this exam will be updated on February 6, 2023. Review the study guide linked in the preceding “Tip” box for details about the skills measured and upcoming changes.
  • Implement and manage a data analytics environment (25–30%)
  • Query and transform data (20–25%)
  • Implement and manage data models (25–30%)
  • Explore and visualize data (20–25%)

Two ways to prepare

Items in this collection

There may be certifications and prerequisites related to "Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI"

  • Microsoft Certified: Azure Enterprise Data Analyst Associate

    Azure enterprise data analysts perform advanced data analytics at scale, such as cleaning and transforming data, designing and building enterprise data models, incorporating advanced analytics capabilities, integrating with IT infrastructure, and applying development lifecycle practices.

Exam resources

Certification poster

Check out an overview of fundamentals, role-based and specialty certifications.

Exam Replay

See two great offers to help boost your odds of success.

Support for certification exams

Get help through Microsoft Certification support forums. A forum moderator will respond in one business day, Monday-Friday.

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.