Microsoft Data and AI certification exams

Microsoft exams help you differentiate yourself and validate your knowledge and skills. Browse the exams below to explore ways to validate your skills.

Learn new skills and prepare for an exam

Browse Microsoft’s online or instructor-led training options to learn new skills that may better prepare you for your career and lay the foundation for success on our certification exams.

Practice for an exam

Are you prepared for exam day? Put your knowledge to the test with Microsoft Official Practice Tests.

Boost your career with a Microsoft certification

Demonstrate your expertise in Microsoft data and AI technologies by earning one of the new Data and AI role-based certifications or an MCSA in SQL, Cosmos DB, or Power BI.

Prepare and practice for a data certification exam


BETA

Designing and Implementing an Azure AI Solution

Exam AI-100

Learn more about exam AI-100

This exam is for the AI Engineer role and the Microsoft Certified: Azure AI Engineer Associate certification. Candidates for this exam analyze requirements for AI cloud-based and hybrid AI solutions, recommends appropriate tools and technologies, and implements solutions that meet scalability and performance requirements. Candidates are aware of the various components that make up the Microsoft Azure AI portfolio, related open source frameworks and technologies, and available data storage options. Candidates use their understanding of cost models, capacity, and best practices to architect and implement AI solutions. Candidates should have a working knowledge of basic statistics, data ethics, and data privacy.


Designing and Implementing a Data Science Solution on Azure

Exam DP-100

Learn more about exam DP-100

This exam is for the Data Scientist role and the Microsoft Certified: Azure Data Scientist Associate certification. Candidates for this exam apply scientific rigor and data exploration techniques to gain actionable insights and communicate results to stakeholders. Candidates use machine learning techniques to train, evaluate, and deploy models to build AI solutions that satisfy business objectives. Candidates use applications that involve natural language processing, speech, computer vision, and predictive analytics. Candidates serve as part of a multi-disciplinary team that incorporates ethical, privacy, and governance considerations into the solution. Candidates typically have background in mathematics, statistics, and computer science.


Implementing an Azure Data Solution

Exam DP-200

Learn more about exam DP-200

This is one of the exams for the Data Engineer role and the Microsoft Certified: Azure Data Engineer Associate certification. Candidates for this exam are Azure data engineers who are responsible for data related tasks that include ingesting, egressing, and transforming data from multiple sources using various services and tools. The Azure data engineer collaborates with business stakeholders to identify and meet data requirements while designing and implementing the management, monitoring, security, and privacy of data using the full stack of Azure services to satisfy business needs.


Designing an Azure Data Solution

Exam DP-201

Learn more about exam DP-201

This is one of the exams for the Data Engineer role and the Microsoft Certified: Azure Data Engineer Associate certification. Candidates for this exam are Azure data engineers who are responsible for data related tasks that include ingesting, egressing, and transforming data from multiple sources using various services and tools. The Azure data engineer collaborates with business stakeholders to identify and meet data requirements while designing and implementing the management, monitoring, security, and privacy of data using the full stack of Azure services to satisfy business needs.


Designing and Implementing Cloud Data Platform Solutions

Exam 70-473

This exam is for candidates who are interested in validating their skills in designing and implementing Microsoft data platform solutions. Candidates for this exam will have relevant work experience in on-premises and cloud-based platform solutions.

Exam 70-473 includes topics such as: Designing and implementing database solutions for SQL Server and SQL Database; managing database management systems security; designing for high availability, disaster recovery, and scalability; and monitoring and managing database implementations on Azure.

Learn more about exam 70-473Watch video about exam 70-473


Designing and Implementing Big Data Analytics Solutions

Exam 70-475

This exam is targeted towards data management professionals, data architects, data scientists, and data developers who design big data analytics solutions on Microsoft Azure. Candidates for this exam should have relevant work experience in big data analytics solutions.

Exam 70-475 includes such topics as: Designing big data batch processing and interactive solutions; designing big data real-time processing solutions; and operationalizing end-to-end cloud analytics solutions.

Learn more about exam 70-475Watch video about exam 70-475


Querying Data with Transact-SQL

Exam 70-761

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Exam 70-761 includes such topics as: manage data with Transact-SQL, query data with advanced Transact-SQL components, and program databases by using Transact-SQL.

Learn more about exam 70-761

Practice and Prepare

Online Training
Instructor-led Training
Self-paced Training
Practice
Exam Reference Book

Microsoft Press books and eBooks are available for preorder within 90 days of the book’s publication date.


Developing SQL Databases

Exam 70-762

This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

Exam 70-762 includes such topics as: design and implement database objects, implement programmability objects, manage database concurrency, and optimize database objects and SQL infrastructure.

Learn more about exam 70-762


Administering a SQL Database Infrastructure

Exam 70-764

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Exam 70-764 includes such topics as: configure data access and auditing, manage backup and restore of databases, manage and monitor SQL Server instances, and manage high availability and disaster recovery.

Learn more about exam 70-764


Provisioning SQL Databases

Exam 70-765

This exam is intended for architects, senior developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

Exam 70-765 includes such topics as: implement SQL in Azure, manage databases and instances, and manage storage.

Learn more about exam 70-765


Implementing a Data Warehouse Using SQL

Exam 70-767

This exam is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

Exam 70-767 includes such topics as: design, implement, and maintain a data warehouse; extract, transform, and load data; and build data quality solutions.

Learn more about exam 70-767


Developing SQL Data Models

Exam 70-768

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Exam 70-698 includes such topics as: design a multidimensional business intelligence (BI) semantic mode, design a tabular BI semantic model, develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX), and configure and maintain SQL Server Analysis Services (SSAS).

Learn more about exam 70-768


Analyzing Big Data with Microsoft R

Exam 70-773

Candidates for this exam are data scientists or analysts who process and analyze data sets larger than memory using R. Candidates should have experience with R, familiarity with data structures, familiarity with basic programming concepts (such as control flow and scope), and familiarity with writing and debugging R functions. Candidates should be familiar with common statistical methods and data analysis best practices. Candidates should also have a high-level understanding of data platforms, such as the Hadoop ecosystem, SQL Server, and core T-SQL capabilities.

Learn more about exam 70-773

Practice and Prepare

Instructor-led Training

Perform Cloud Data Science with Azure Machine Learning

Exam 70-774

Candidates for this exam are data scientists or analysts who use Azure cloud services to build and deploy intelligent solutions. Candidates have a good understanding of Azure data services and machine learning and are familiar with common data science processes such as filtering and transforming data sets, model estimation, and model evaluation. Candidates for this exam should have experience publishing effective APIs for knowledge intelligence.

Exam 70-774 includes such topics as: Prepare data for analysis in Azure Machine Learning and export from Azure Machine Learning; develop machine learning models; operationalize and manage Azure Machine Learning services; and use other services for machine learning.

Learn more about exam 70-774

Practice and Prepare

Online Training
Instructor-led Training
Exam Reference Book

Microsoft Press books and eBooks are available for preorder within 90 days of the book’s publication date.


Perform Data Engineering on Microsoft HD Insight

Exam 70-775

This certification exam is targeted towards data engineers, data architects, data scientists, and data developers who implement big data engineering workflows on HDInsight. Candidates for this exam should have relevant work experience in big data analytics solutions. Candidates should also be familiar with the features and capabilities of batch data processing, real-time processing, and interactive processing. Candidates who take this exam are expected to be able to apply the Microsoft cloud ecosystem to design and implement big data engineering workflows and to use open source technologies for strategic value-add.

Exam 70-775 includes such topics as: Administer and provision HDlnsight clusters; implement big data batch processing solutions; implement big data interactive processing solutions; and implement big data real-time processing solutions.

Learn more about exam 70-775

Practice and Prepare

Online Training
Instructor-led Training
Exam Reference Book

Microsoft Press books and eBooks are available for preorder within 90 days of the book’s publication date.


Engineering Data with Microsoft Cloud Services

Exam 70-776

This certification exam is intended for candidates who design analytics solutions and build operationalized solutions on Azure. Candidates for this exam have relevant work experience in data engineering issues with Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, and Azure Stream Analytics. Candidates are familiar with the features and capabilities of batch data processing, real-time processing, and operationalization technologies. Candidates for this exam can apply the Microsoft cloud ecosystem to designs and can implement big data analytics solutions to meet their project’s needs.

Exam 70-776 includes such topics as: Design and implement complex event processing by using Azure Stream Analytics; design and implement analytics by using Azure Data Lake; design and implement Azure SQL Data Warehouse Solutions; design and implement cloud-based integration by using Azure Data Factory; and manage and maintain Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, and Azure Stream Analytics.

Learn more about exam 70-776


Implementing Microsoft Azure Cosmos DB Solutions

Exam 70-777

Candidates for this exam are developers and architects who leverage Azure Cosmos DB. Candidates should understand fundamental concepts of partitioning, replication, and resource governance for building and configuring scalable applications that are agnostic of a Cosmos DB API. Candidates should also have basic working knowledge of the Cosmos DB SQL API. Candidates for this exam design, build, and troubleshoot Cosmos DB solutions that meet business and technical requirements.

Learn more about exam 70-777

Practice and Prepare

Preparation materials are coming later in 2018 or early in 2019


Analyzing and Visualizing Data with Microsoft Power BI

Exam 70-778

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis. Candidates should be proficient in connecting to data sources and performing data transformations, modeling and visualizing data by using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service. Candidates should also be proficient in implementing direct connectivity to Microsoft SQL Azure and SQL Server Analysis Services (SSAS) and implementing data analysis in Microsoft Excel. Candidates may include BI professionals, data analysts, and other roles responsible for creating reports by using Power BI.

Exam 70-778 includes such topics as: Consume and Transform Data by Using Power BI Desktop, Model and Visualize Data, and Configure Dashboards in the Power BI Service.

Learn more about exam 70-778

Practice and Prepare

Online Training
Instructor-led Training
Self-paced Training

Analyzing and Visualizing Data with Microsoft Excel

Exam 70-779

Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

Exam 70-779 includes such topics as: Consume and Transform Data by Using Microsoft Excel, Model Data, and Visualize Data.

Learn more about exam 70-778

Practice and Prepare

Online Training
Instructor-led Training
Self-paced Training
Exam Reference Book