Category: Certification

Certificationdatabase

70-762 Developing SQL Databases Certification Exam

Microsoft has been expanding out the certification offerings around Microsoft Azure. The Provisioning SQL Databases (70-765) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers Azure SQL Databases and hosting SQL Server within Virtual Machines (VMs).

Certification Target Audience

The focus on the Developing SQL Databases (70-762) certification exam is centered around SQL Server and Azure SQL Database. The exam is designed to target candidates who build and implement databases across organizations and who ensure high levels of data availability. The ideal candidates 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.

Skills Measured

Here is a high level list of the skills and objectives measured on the Developing SQL Databases (70-762) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Design and implement database objects (25-30%)
    • Design and implement a relational database schema
    • Design and implement indexes
    • Design and implement views
    • Implement columnstore indexes
  • Implement programmability objects (20-25%)
    • Ensure data integrity with constraints
    • Create stored procedures
    • Create triggers and user-defined functions
  • Manage database concurrency (25-30%)
    • Implement transactions
    • Manage isolation levels
    • Optimize concurrency and locking behavior
    • Implement memory-optimized tables and native stored procedures
  • Optimize database objects and SQL infrastructure (20-25%)
    • Optimize statistics and indexes
    • Analyze and troubleshoot query plans
    • Manage performance for database instances
    • Monitor and trace SQL Server baseline performance metrics

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

At the time of writing this summary of the 70-762 Developing SQL Databases exam, there is a limited amount of Exam preparation material available. You’ll need to focus mostly on the Microsoft documentation surrounding the technologies and skills measured on this exam for now. However, there an Exam Reference book from Microsoft Press being published soon!

Below is a summary of the exam reference book:

Exam Ref 70-762 Developing SQL Databases

Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

Focus on the expertise measured by these objectives:

  • Design and implement database objects
  • Implement programmability objects
  • Manage database concurrency
  • Optimize database objects and SQL infrastructure

This Microsoft Exam Ref:

  • Organizes its coverage by exam objectives
  • Features strategic, what-if scenarios to challenge you
  • Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases

Happy Studying!

Certificationdatabase

70-768 Developing SQL Data Models Certification Exam

Microsoft has been expanding out the certification offerings around Microsoft Azure. The Developing SQL Data Models (70-768) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers topics that apply to both SQL Server and Azure SQL Database.

Certification Target Audience

The focus on the Developing SQL Data Models (70-768) certification exam is centered around SQL Server and Azure SQL Database topics like SSAS, BI, MDX and DAX. The exam is designed to target candidates who are Business Intelligence (BI) developers who are focused on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Skills Measured

Here is a high level list of the skills and objectives measured on the Provisioning SQL Databases (70-765) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Design a multidimensional business intelligence (BI) semantic model (25-30%)
    • Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
    • Design and implement dimensions in a cube
    • Implement measures and measure groups in a cube
  • Design a tabular BI semantic model (20-25%)
    • Design and publish a tabular data model
    • Configure, manage, and secure a tabular model
    • Develop a tabular model to access data in near real time
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
    • Create basic MDX queries
    • Implement custom MDX solutions
    • Create formulas by using the DAX language
  • Configure and maintain SQL Server Analysis Services (SSAS) (30-35%)
    • Plan and deploy SSAS
    • Monitor and optimize performance
    • Configure and manage processing
    • Create Key Performance Indicators (KPIs) and translations

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

At the time of writing this summary of the Developing SQL Data Models (70-768) exam, there is a limited amount of Exam preparation material available. You’ll need to focus mostly on the Microsoft documentation surrounding the technologies and skills measured on this exam for now. However, there an Exam Reference book from Microsoft Press being published soon!

Below is a summary of the exam reference book:

Exam Ref 70-768 Developing SQL Data Models

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-768 Developing SQL Data Models certification exam, the second of two exams required for MCSA: SQL 2016 Business Intelligence Development certification.

Authored by Microsoft Data Platform MVP Stacia Varga, Exam Ref 70-768 Developing SQL Data Models offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database and business intelligence professionals need to succeed with SQL Server 2016 Analysis Services. Coverage includes:

  • Designing multidimensional BI semantic models
  • Designing tabular BI semantic models
  • Developing queries using MDX and DAX
  • Configuring and maintaining SQL Server Analysis Services

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not “one-size-fits-all” content
  • Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through a set of “what if?” scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro’s job role

Happy Studying!

Certificationdatabase

70-765 Provisioning SQL Databases Certification Exam

Microsoft has been expanding out the certification offerings around Microsoft Azure. The Provisioning SQL Databases (70-765) exam fits right along with this as it measures expertise around SQL Server and Azure SQL Databases. With the ever increasing adoption of the Cloud, the lines between traditional on-premises style systems / applications and cloud applications is being blurred. This exam fits right along with that as it covers Azure SQL Databases and hosting SQL Server within Virtual Machines (VMs).

Certification Target Audience

The focus on the Provisioning SQL Databases (70-765) certification exam is centered round SQL Server and Azure SQL Database. The exam is designed to target candidates who are Architects, Senior Developers, Infrastructure Specialists, and Development Leads. These candidates should have experience and knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. It will also be good to have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

Skills Measured

Here is a high level list of the skills and objectives measured on the Provisioning SQL Databases (70-765) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Implement SQL in Azure (30-35%)
    • Deploy a Microsoft Azure SQL Database
    • Plan for SQL Server installation
    • Deploy SQL Server instances
  • Manage databases and instances (35-40%)
    • Configure secure access to Microsoft Azure SQL Databases
    • Configure SQL Server performance settings
    • Manage SQL Server instances
  • Deploy and migrate applications (30-35%)
    • Deploy applications to Microsoft Azure SQL Database
    • Deploy applications to SQL Server on Azure Virtual Machines
    • Migrate client applications

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

At the time of writing this summary of the 70-765 Provisioning SQL Databases exam, there is a limited amount of Exam specific training material available. You’ll need to rely fairly heavily on the Microsoft documentation when studying for this exam. No exam guide or prep books are available, however there is a Practice Test available.

Happy studying!

Big DataCertification

70-773 Analyzing Big Data with Microsoft R Certification Exam

In the effort of expanding out the breadth of certification offerings, Microsoft has added the Analyzing Big Data with Microsoft R (70-773) exam. This exam focuses on using Microsoft R Server and SQL R Services for analyzing Big Data.

Certification Target Audience

The focus on the Analyzing Big Data with Microsoft R (70-773) exam is centered around Microsoft R Server and SQL R Services. The exam is designed to target candidates who are Data Scientists or Analysts who are processing and analyzing large data sets using R. This exam will test your familiarity with data structures, as well as basic programming concepts (such as control flow and scope), and your ability to write and debug R code functions.

Skills Measured

Here is a high level list of the skills and objectives measured on this exam:

  • Read and Explore Big Data
    • Read data with R Server
    • Summarize data
    • Visualize data
  • Process Big Data
    • Process data with rxDataStep
    • Perform complex transforms that use transform functions
    • Manage data sets
    • Process text using RML packages
  • Build Predictive Models with ScaleR
    • Estimate linear models
    • Build and use partitioning models
    • Generate predictions and residuals
    • Evaluate models and tuning parameters
    • Create additional models using RML packages
  • Use R Server in different environments
    • Use different compute contexts to run R Server effectively
    • Optimize tasks by using local compute contexts
    • Perform in-database analytics by using SQL Server
    • Implement analysis workflows in the Hadoop ecosystem and Spark
    • Deploy predictive models to SQL Server and Azure Machine Learning

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives. You’ll need to be sure to study every one of them that will be measured on the exam.

Training Materials

At the time of writing this summary of the 70-773 Analyzing Big Data with Microsoft R, the exam is still in Beta as it was just recently published. This means there aren’t any exam guide books, or practice exams available yet. To study for this exam, you’ll need to rely mostly on the Microsoft documentation for the different technologies covered on this exam.

Happy studying!

CertificationInfrastructure

70-744 Securing Windows Server 2016 Certification Exam

Server and Virtual Machine (VM) security is an increasingly important topic in IT. With the adoption of both Public and Private Cloud environments the landscape of server security has been changing as systems become increasingly connected; especially across networks and even the Internet. The Securing Windows Server 2016 (70-744) certification exam will test and measure your expertise in securing and hardening server and VMs running Windows Server 2016; whether their on-premises, or in Public or Private Cloud environments.

Certification Target Audience

The focus on the Securing Windows Server 2016 (70-744) certification exam is centered around Windows Server 2016 Security; such as hardening server environments, securing Virtual Machine infrastructure using Shielded and encryption-supported VMs and Guarded Fabric. The exam is designed to target candidates who are IT Pros and infrastructure professionals that are tasked with configuring and securing Windows Server 2016 environments On-Premises and in Virtual Machine (VM) environments including both the Public and Private Cloud.

Skills Measured

Here is a high level list of the skills and objectives measured on this exam. The percentages next to each of the high level objectives represents the percentage of exam questions that will be targeted towards that specific objective area.

  • Implement disk and file encryption (25-30%)
    • Configure disk and file encryption
    • Implement server patching and updating solutions
    • Implement malware protection
    • Protect credentials
    • Create security baselines
  • Secure a virtualization infrastructure (5-10%)
    • Implement a Guarded Fabric solutions
    • Implement Shielded and encryption-supported VMs
  • Secure a network infrastructure (10-15%)
    • Configure Windows Firewall
    • Implement a software-defined Distributed Firewall
    • Secure network traffic
  • Manage privileged identities (25-30%)
    • Implement an Enhanced Security Administrative Environment (ESAE) administrative forest design approach
    • Implement Just-in-Time (JIT) Administration
    • Implement Just-Enough-Administration (JEA)
    • Implement Privileged Access Workstations (PAWs) and User Rights Assignments
    • Implement Local Administrator Password Solution (LAPS)
  • Implement threat detection solutions (15-20%)
    • Configure advanced audit policies
    • Install and configure Microsoft Advanced Threat Analytics (ATA)
    • Determine threat detection solutions using Operations Management Suite (OMS)
  • Implement workload-specific security (5-10%)
    • Secure application development and server workload infrastructure
    • Implement a secure file services infrastructure and Dynamic Access Control (DAC)

When studying for this exam, you’ll definitely want to look at the official exam page from Microsoft for the full list of exam objectives. You’ll need to be sure to study every one of them that will be measured on the exam.

Training Materials

The Securing Windows Server 2016 (70-744) exam covers a lot of smaller objective areas in comparison to many other certification exams. There are a lot of topic areas to study around Security Windows Server 2016! Fortunately there is an Exam Reference book available from Microsoft Press targeted towards studying for this specific exam.

Here’s a short description of the Exam Reference book:

Exam Ref 70-744 Securing Windows Server 2016

Prepare for Microsoft Exam 70-744–and help demonstrate your real-world mastery of securing Windows Server 2016 environments. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. 

Focus on the expertise measured by these objectives: 

  • Implement server hardening solutions
  • Secure a virtualization infrastructure
  • Secure a network infrastructure
  • Manage privileged identities
  • Implement threat detection solutions
  • Implement workload-specific security 

This Microsoft Exam Ref: 

  • Organizes its coverage by exam objectives
  • Features strategic, what-if scenarios to challenge you
  • Assumes you have experience as a Windows Server administrator and an understanding of basic networking and Hyper-V virtualization fundamentals, Active Directory Domain Services principles, and Windows Server security principles

Happy Studying!

Certificationdatabase

MCSE: Data Management and Analytics Certification

mcse_datamanagementandanalyticsMicrosoft continues to expand out their certification program to better fit the newly emerging “cloud-based” world of IT. As a result, the existing Microsoft Azure exams as well as new exams being published are being integrated into the broad spectrum of Microsoft certifications; such as the MCSE. The MCSE: Data Management and Analytics certification has recently been introduced as part of a new redesign and restructuring of the MCSE certifications. This article explains some of the details around how you can go about earning the new MCSE: Data Management and Analytics certification.

On the path to earning the MCSE: Data Management and Analytics an MCSA certification will first be earned.

The MCSA Foundation

On the path to earning the MCSE: Data Management and Analytics certification an MCSA certification will first be earned. It’s really good to have a milestone along the way, instead of having to take a tone of exams before claiming any single certification title / credential. Additionally, instead of just a single MCSA choice to earn, there are actually multiple tracks to choose from based on your unique combination of expertise and interests.

Here’s the list of the MCSA certification tracks, along with the exams you’ll need to pass to achieve each of them:

As you can see the MCSA foundations mostly require 2 exams to be passed; these are the newer MCSA’s. The older MCSA for SQL Server 2012/2014 requires 3 exams to be passed to earn. All these MCSA’s fill provide a solid foundation of SQL Server in the specific track that you choose.

MCSE: Data Management and Analytics

Once a qualifying MCSA certification (as listed above) has been earned, the next path to the MCSE: Data Management and Analytics certification is to pass only 1 more exam. Also, best of all, you get to choose which exam you would like to take from a list of elective exams.

Here’s the list of elective exams to choose from to build on top of the MCSA foundation when achieving the MCSE: Data Management and Analytics certification:

Even if you choose to focus on SQL Server 2012/2014 or SQL Server 2016 with the MCSA you earned, it’s up to you if you want to mix some Azure / Cloud expertise into  your certification for the MCSE, Or, you can still with SQL Server for your choice elective exam as well.

Once a qualifying MCSA certification (as listed above) is earned, the next path is to pass 1 more exam to earn the full MCSE: Data Management and Analytics certification!

Happy studying!

Updated May 27, 2017: Microsoft announced a renaming of a few of the MCSA certifications and the addition of more elective exams for the MCSE: Data Management and Analytics certification.

Updated Apr 13, 2017: Added info about MCSA Data Science certification.

Big DataCertification

70-775 Perform Data Engineering on Microsoft Azure HDInsight Certification Exam

On of the hottest topics and technology areas in the industry is Big Data. Azure HDInsight is one of the services within the Microsoft Azure platform that services the ability to build scalable, Big Data solutions in the cloud. In an effort to expand out the breadth of certifications and exams offered around Microsoft Azure, the cloud, and Big Data, Microsoft has added the Perform Data Engineering on Microsoft Azure HDInsight (70-775) exam.

Certification Target Audience

The focus on the Perform Data Engineering on Microsoft Azure HDInsight (70-775) exam is around Microsoft Azure HDInsight. The exam is designed to target candidates who are Data Engineers, Data Architects, Data Scientists, and Data Developers who implement Big Data engineering workflows on HDInsight. This exam tests your experience and familiarity with the features and capabilities of Batch data processing, Real-time processing, and Interactive processing.

Skills Measured

Here is a high level list of the skills and objectives measured on this exam:

  • Administer and Provision HDInsight Clusters
    • Deploy HDInsight clusters
    • Deploy and secure multi-user HDInsight clusters
    • Ingest data for batch and interactive processing
    • Configure HDInsight clusters
    • Manage and debug HDInsight jobs
  • Implement Big Data Batch Processing Solutions
    • Implement batch solutions with Hive and Apache Pig
    • Design batch ETL solutions for big data with Spark
    • Operationalize Hadoop and Spark
  • Implement Big Data Interactive Processing Solutions
    • Implement interactive queries for big data with Spark SQL
    • Perform exploratory data analysis by using Spark SQL
    • Implement interactive queries for big data with Interactive Hive
    • Perform exploratory data analysis by using Hive
    • Perform interactive processing by using Apache Phoenix on HBase
  • Implement Big Data Real-Time Processing Solutions
    • Create Spark streaming applications using DStream API
    • Create Spark structured streaming applications
    • Develop big data real-time processing solutions with Apache Storm
    • Build solutions that use Kafka
    • Build solutions that use HBase

When studying for this exam, you’ll definitely want to look at the official exam page from Microsoft for the full list of exam objectives. You’ll need to be sure to study every one of them that will be measured on the exam.

Training Materials

At the time of writing this summary of the 70-775 Perform data Engineering on Microsoft Azure HDInsight exam, it is still in Beta as it was just recently published. This means there aren’t any exam guide books, or practice exams available yet. To study for this exam, you’ll need to rely mostly on the Azure HDInsight documentation, as well as the documentation for any other services and technologies listed in the exam objectives.

Not specific to just this exam, there are some additional resources available from various sources that do cover the technologies and skills measured on this exam. Here’s a short list of a few of these additional resources that may help in studying for this exam:

Happy studying!

CertificationInfrastructure

70-247 Configuring and Deploying a Private Cloud Certification Exam

Many of the newer certification exams from Microsoft target Azure and Public Cloud technologies. The Configuring and Deploying a Private Cloud (70-247) certification exam is a little different since it will test expertise in monitoring and operating Private Cloud environments using Windows Server and Microsoft System Center 2012.

Retired Exam: This exam is being retired December 31, 2017.

Certification Target Audience

The focus on the Configuring and Deploying a Private Cloud (70-247) certification exam is centered around Microsoft System Center. The exam is designed to target candidates who have experience setting up security, high-availability, fault tolerance, and networking of enterprise environments using Windows Server, and System Center 2012. Candidates should also have basic SQL Server and PowerShell knowledge, and application configuration experience.

Skills Measured

Here is a high level list of the skills and objectives measured on the Configuring and Deploying a Private Cloud (70-247) The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Design and deploy System Center (15-20%)
    • Design a scalable System Center architecture
    • Install the System Center infrastructure
    • Upgrade System Center components
  • Configure System Center infrastructure (20-25%)
    • Configure System Center components
    • Configure portals and dashboards
  • Configure the fabric (25-30%)
    • Configure the storage fabric
    • Configure the network fabric
    • Configure and manage the deployment and update servers
    • Configure clouds and virtualization hosts
  • Configure System Center integration (15-20%)
    • Configure private cloud integration
    • Configure integration of private and public clouds
  • Configure and deploy virtual machines and services (15-20%)
    • Configure profiles
    • Create and configure server App-V packages
    • Configure and deploy a service
    • Update a service

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

There are a few training resources (paid and free) for preparing for the Configuring and Deploying a Private Cloud (70-247) certification exam. Below is a list of a few of these resources:

Free Videos

Practice Test / Exam

Book

Exam Ref 70-247: Configuring and Deploying a Private Cloud

Prepare for Microsoft Exam 70-247—and help demonstrate your real-world mastery configuring and deploying a private cloud using Microsoft System Center 2012 R2. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level.

CertificationInfrastructure

70-246 Monitoring and Operating a Private Cloud Certification Exam

Many of the newer certification exams from Microsoft target Azure and Public Cloud technologies. The Monitoring and Operating a Private Cloud (70-246) certification exam is a little different since it will test expertise in monitoring and operating Private Cloud environments using Windows Server and Microsoft System Center 2012.

Retired Exam: This exam is being retired December 31, 2017.

Certification Target Audience

The focus on the Monitoring and Operating a Private Cloud (70-246) certification exam is centered around Microsoft System Center. The exam is designed to target candidates who have experience setting up security, high-availability, fault tolerance, and networking of enterprise environments using Windows Server, and System Center 2012.

Skills Measured

Here is a high level list of the skills and objectives measured on the Monitoring and Operating a Private Cloud (70-246) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.

  • Configure data center process automation (15-20%)
    • Implement workflows
    • Implement service offerings
  • Deploy resource monitoring (20-25%)
    • Deploy end-to-end monitoring
    • Configure end-to-end monitoring
    • Create monitoring reports and dashboards
  • Monitor resources (20-25%)
    • Monitor network devices
    • Monitor servers
    • Monitor the virtualization layer
    • Monitor application health
  • Configure and maintain service management (15-20%)
    • Implement service level agreements
    • Manage problems and incidents
    • Manage cloud resources
  • Manage configuration and protection (20-25%)
    • Manage compliance and configuration
    • Manage updates
    • Implement backup and recovery

When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.

Training Materials

There are a few training resources (paid and free) for preparing for the Monitoring and Operating a Private Cloud (70-246) certification exam. Below is a list of a few of these resources:

Free Videos

Practice Test / Exam

Book

Exam Ref 70-246: Monitoring and Operating a Private Cloud

Prepare for Microsoft Exam 70-246–and help demonstrate your real-world mastery of monitoring and operating a private cloud based on Microsoft System Center 2012 R2. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level.

Big DataCertificationmachine learning

70-774 Perform Cloud Data Science with Azure Machine Learning Certification Exam

Machine Learning is one of the hottest topics and technologies in the industry right now. Machine Learning is being used to combine with Big Data to automate the processes of gaining insights and predicting future behavior of systems, devices, and people. In an effort to expand out the breadth of certifications and exams offered around Microsoft Azure and the cloud, Microsoft has added the Perform Cloud Data Science with Azure Machine Learning (70-774) exam.

Certification Target Audience

The focus on the Perform Cloud Data Science with Azure Machine Learning (70-774) exam is centered around Azure Machine Learning, Bot Framework, and Cognitive Services. The exam is designed to target candidates who are Data Scientists or Analysts using the Microsoft Azure cloud services to build and deploy intelligent solutions. This exam will test your understanding and familiarity with common data science processes such as filtering and transforming data sets, model estimation, and model evaluation.

Skills Measured

Here is a high level list of the skills and objectives measured on this exam:

  • Prepare Data and Analytics in Azure Machine Learning and Export from Azure Machine Learning
    • Import and export data to and from Azure Machine Learning
    • Explore and summarize data
    • Cleanse data for Azure Machine Learning
    • Perform feature engineering
  • Develop Machine Learning Models
    • Select an appropriate algorithm or method
    • Initialize and train appropriate models
    • Validate models
  • Operationalize and Manage Azure Machine Learning services
    • Deploy models using Azure Machine Learning
    • Manage Azure Machine Learning projects and workspaces
    • Consume Azure Machine Learning models
    • Consume exemplar Cognitive Services APIs
  • Use Other Services for Machine Learning
    • Build and use neural networks with the Microsoft Cognitive Toolkit
    • Streamline development by using existing resources
    • Perform data sciences at scale by using HDInsights
    • Perform database analytics by using SQL Server R Services on Azure

When studying for this exam, you’ll definitely want to look at the official exam page from Microsoft for the full list of exam objectives. You’ll need to be sure to study every one of them that will be measured on the exam.

Training Materials

At the time of writing this summary of the 70-774 Perform Cloud Data Science with Azure Machine Learning, the exam is still in Beta as it was just recently published. This means there aren’t any exam guide books, or practice exams available yet. To study for this exam, you’ll need to rely mostly on the Azure Machine Learning documentation, as well as the documentation for the other Azure services and technologies listed in the exam objectives.

Not specific to just this exam, there are some additional resources available from various sources that do cover the technologies and skills measured on this exam. Here’s a short list of a few of these additional resources that may help in studying for this exam:

Happy studying!