Collection: Data Exams

Prepare and practice for a data certification exam


Designing and Implementing an Azure AI Solution

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 the requirements for AI solutions, recommend appropriate tools and technologies, and implements solutions that meet scalability and performance requirements. Candidates translate the vision from solution architects and work with data scientists, data engineers, IoT specialists, and AI developers to build complete end-to-end solutions. Candidates design and implement AI apps and agents that use Microsoft Azure Cognitive Services and Azure Bot Service. Candidates can recommend solutions that use open source technologies. Candidates understand the components that make up the Azure AI portfolio and the available data storage options. Candidates implement AI solutions that use Cognitive Services, Azure bots, Azure Search, and data storage in Azure. Candidates understand when a custom API should be developed to meet specific requirements.


Designing and Implementing a Data Science Solution on Azure

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

This is one of the exams for the Data Engineer role and the Microsoft Certified: Azure Data Engineer Associatecertification. Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to implement data solutions that use Azure data services. Azure data engineers are responsible for data-related tasks that include provisioning data storage services, ingesting streaming and batch data, transforming data, implementing security requirements, implementing data retention policies, identifying performance bottlenecks, and accessing external data sources. Candidates for this exam must be able to implement data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.


Designing an Azure Data Solution

Exam DP-201

This is one of the exams for the Data Engineer role and the Microsoft Certified: Azure Data Engineer Associatecertification. Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to design data solutions that use Azure data services. Azure data engineers are responsible for data-related tasks that include designing Azure data storage solutions that use relational and non-relational data stores, batch and real-time data processing solutions, and data security and compliance solutions. Candidates for this exam must design data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.


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


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.


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.


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.


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.


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).


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.


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.


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.

13 products
  • 70-779 Analyzing and Visualizing Data with Microsoft Excel
    70-779 Analyzing and Visualizing Data with Microsoft Excel
    Regular price
    $30.00
    Sale price
    $19.00
    Unit price
    per 
  • AI-100 Designing and Implementing an Azure AI Solution
    AI-100 Designing and Implementing an Azure AI Solution
    Regular price
    $30.00
    Sale price
    $19.00
    Unit price
    per 
  • DP-100 Designing and Implementing a Data Science Solution on Azure (beta)
    DP-100 Designing and Implementing a Data Science Solution on Azure (beta)
    Regular price
    $30.00
    Sale price
    $19.00
    Unit price
    per 
  • DP-200 Implementing an Azure Data Solution
    DP-200 Implementing an Azure Data Solution
    Regular price
    $30.00
    Sale price
    $19.00
    Unit price
    per 
  • DP-201 Designing an Azure Data Solution
    DP-201 Designing an Azure Data Solution exam
    Regular price
    $30.00
    Sale price
    $19.00
    Unit price
    per