Certification

Microsoft Certified: Azure Enterprise Data Analyst Associate

Demonstrate methods and practices for performing advanced analytics at scale with Microsoft Purview, Microsoft Azure Synapse Analytics, and Microsoft Power BI.

At a glance

Jump to

Overview

Warning

This certification will retire on April 30, 2024. You will no longer be able to earn this certification after this date. Certification renewal will be available for at least six months after the certification retires. Read the blog post.

As a candidate for this certification, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.

Your responsibilities for this role include performing 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.
  • Applying development lifecycle practices.

As a professional in this role, you:

  • Help collect enterprise-level requirements for data analytics solutions that include Azure and Power BI.
  • Advise on data governance and configuration settings for Power BI administration.
  • Monitor data usage.
  • Optimize performance of the data analytics solutions.

As an Azure enterprise data analyst, you collaborate with other roles, such as:

  • Solution architects
  • Data engineers
  • Data scientists
  • AI engineers
  • Database administrators
  • Power BI data analysts

As a candidate for this certification, you 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). You 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.

Skills measured

  • Implement and manage a data analytics environment
  • Query and transform data
  • Implement and manage data models
  • Explore and visualize data

Prepare for the exam

Practice for the exam

Exam Sandbox

Experience demo

Experience the look and feel of the exam before taking it. You'll be able to interact with different question types in the same user interface you'll use during the exam.

Take the exam

You will have 100 minutes to complete this assessment.

Exam policy

This exam will be proctored, and is not open book. You may have interactive components to complete as part of this exam. To learn more about exam duration and experience, visit: Exam duration and exam experience.

If you fail a certification exam, don’t worry. You can retake it 24 hours after the first attempt. For subsequent retakes, the amount of time varies. For full details, visit: Exam retake policy.

Need accommodations?

We offer a variety of accommodations to support you.

Learn More

This exam is offered in the following languages:

English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian

Schedule through Pearson Vue

Schedule exam

 

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

Renew your certification

Do you know that Microsoft role-based and specialty certifications expire unless they are renewed? Learn the latest updates to the technology for your job role and renew your certification at no cost by passing an online assessment on Microsoft Learn.

Learn more about renewing

Certification resources

Exam DP-500 study guide

Focus your studies as you prepare for the exam. Review the study guide to learn about the topics the exam covers, updates, and additional resources.

Certification poster

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

Exam Replay

Boost your odds of success with this great offer.

Support for credentials

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

Choose your Microsoft Credential

Microsoft Applied Skills or Microsoft Certifications? Choose the path that fits your career goals, desired skillset, and schedule.