Exam Preparation Blueprint

Exam 70-473 - Implementing Cloud and Data Platform Solutions

Training Resources to Prepare for this Exam

Exam Audience

This exam is for candidates who are experienced in implementing an infrastructure solution in Microsoft Azure. Candidates have experience implementing and monitoring cloud and hybrid solutions as well as supporting application lifecycle management.

Objective: Design and implement database solutions for Microsoft SQL Server and SQL Database (20-25%)

Design a hybrid SQL Server solution

Design Geo/DR topology, design a data storage architecture, design a security architecture, design a data load strategy

Implement SQL Server on Azure Virtual Machines (VMs)

Provision SQL Server in an Azure VM, configure firewall rules, configure and optimize storage, migrate an on-premises database to Microsoft Azure, configure and optimize VM sizes by workload

Design a SQL Database solution

Design a solution architecture, design Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier

Implement SQL Database

Provision SQL Database, configure firewall rules, configure active geo-replication, migrate an on-premises database to SQL Database, configure for scale and performance

Design and implement data warehousing on Azure

Design a data warehousing solution on Azure, design a data load strategy and topology, configure SQL Data Warehouse, migrate an on-premises database to SQL Data Warehouse

Online Resources

Objective: Manage database management systems (DBMS) security (25-30%)

Design and implement SQL Server Database security

Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure transparent database encryption; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted

Implement Azure SQL Database security

Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted

Online Resources

Objective: Design for high availability, disaster recovery, and scalability (25-30%)

Design and implement high availability solutions

Design a high availability solution topology, implement high availability solutions between on-premises and Azure, design cloud-based backup solutions, implement backup and recovery strategies

Design and implement scalable solutions

Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for SQL Database

Design and implement SQL Database data recovery

Implement self-service restore, copy and export databases

Online Resources

Objective: Monitor and manage database implementations on Azure (25-30%)

Monitor and troubleshoot SQL Server VMs on Azure

Monitor database and instance activity, monitor using dynamic management views (DMVs) and dynamic management functions (DMFs), monitor performance and scalability

Monitor and troubleshoot SQL Database

Monitor and troubleshoot SQL Database, monitor database activity, monitor using DMVs and DMFs, monitor performance and scalability

Automate and manage database implementations on Azure

Manage SQL Server in Azure VMs with PowerShell, manage Azure SQL Database with PowerShell, configure Automation and Runbooks

Online Resources


It is highly recommended to take a practice test prior to the exam.

A practice test (purchased separately) will help show where your knowledge gaps are lightest and to also help prepare you for the types of questions you will see on the exam.

Schedule an Exam

There are two ways you can take a Microsoft exam:

Exam Format and Question Types

Microsoft does not announce which question types will be on each exam, but here are some resources to help you prepare

Day of the Exam

Microsoft does not announce which question types will be on each exam, but here are some resources to help you prepare

  • Arrive 15 minutes early to test center
  • Bring two forms of ID
  • Cancellation or Reschedule Requires 24 hours notice
  • * Policies may differ per country

Register for the exam