microsoft exams

70-461

Querying Microsoft SQL Server 2012/2014

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.

70-462

Administering Microsoft SQL Server 2012/2014 Databases

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.

70-463

Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

This exam is primarily intended for ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation.

70-466

Implementing Data Models and Reports with Microsoft SQL Server

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.

70-467

Designing Business Intelligence Solutions with Microsoft SQL Server

This exam is intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

70-473

Designing and Implementing Cloud Data Platform Solutions

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. Candidates should know the features and capabilities of the Microsoft data platform to be able to identify tradeoffs and to make decisions for designing public and hybrid cloud solutions. Candidates who take this exam are expected to be able to define the appropriate infrastructure and platform solutions to meet the required functional, operational, and deployment requirements through the solution lifecycle.

70-475

Designing and Implementing Big Data Analytics Solutions

This certification 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 will have relevant work experience in big data analytics solutions.

70-761

Querying Data with Transact-SQL

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.

70-762

Developing SQL Databases

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.

70-764

Administering a SQL Database Infrastructure

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.

70-765

Provisioning SQL Databases

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.

70-767

Implementing a Data Warehouse using SQL

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.

70-768

Developing SQL Data Models

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.

70-773

Analyzing Big Data with Microsoft R

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.

70-774

Perform Cloud Data Science with Azure Machine Learning

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.

70-775

Perform Data Engineering on Microsoft Azure HDInsight

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.

70-776

Perform Big Data Engineering on Microsoft Cloud Services

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.

70-777

Implementing Microsoft Azure Cosmos DB Solutions

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.

70-778

Analyzing and Visualizing Data with Microsoft Power BI

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.

70-779

Analyzing and Visualizing Data with Microsoft Excel

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.