Microsoft Azure

  • Published:
    October 27, 2015
  • Languages:
    English, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil), Spanish, Russian
  • Audiences:
    IT Professionals
  • Technology:
    Microsoft Azure
  • Credit toward certification:

Designing and Implementing Cloud Data Platform Solutions

This exam retires on June 30, 2019. A replacement exam may be available. To learn more, visit our blog: https://www.microsoft.com/en-us/learning/community.aspx and review our Exam Retirement posts. Note: Exams retire at 11:59 PM Central Standard Time

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

Effective May 1, 2017, the existing cancellation policy will be replaced in its entirety with the following policy: Cancelling or rescheduling your exam within 5 business days of your registered exam time is subject to a fee. Failing to show up for your exam appointment or not rescheduling or cancelling your appointment at least 24 hours prior to your scheduled appointment forfeits your entire exam fee.

Watch an Exam Prep session from Microsoft Ignite 2017

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

As of June 2017, this exam was updated. To learn more about these changes and how they affect the skills measured, please download and review the exam 70-473 change document.

Design and implement database solutions for Microsoft SQL Server and Microsoft Azure SQL Database (20–25%)
  • Design a hybrid SQL Server solution
    • Design a Disaster Recovery topology for a hybrid deployment, design a data storage architecture, design a security architecture, design a data load strategy, design a data synchronization strategy
  • Implement SQL Server on Azure Virtual Machines (VMs)
    • Provision SQL Server on 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 database solution on Azure SQL database and SQL Server in Azure
    • Design a solution architecture, design a Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier, determine the appropriate deployment scenario, determine IaaS vs PaaS, determine application access in Azure
  • Implement Azure SQL Database
    • Provision Azure 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 MySQL and PostgreSQL database solutions in Azure
    • Design security, design a data load strategy, determine the appropriate service tier, provision databases and servers, configure firewall rules, migrate to Azure, configure for scale and performance
Design and Implement 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 (TDE); configure row-level security; configure data encryption; configure data masking; configure Always Encrypted
  • Design and 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, configure Automatic Threat Detection
Design for high availability, disaster recovery, and scalability (25–30%)
  • Design and implement high availability solutions
    • Design a high-availability solution topology, design a high-availability solution for SQL on Azure VMs, implement high-availability solutions
  • Design and implement scalable solutions
    • Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for Azure SQL Database
  • Design and implement Azure SQL Database data recovery
    • Implement self-service restore, copy and export databases, implement long-term retention backups
Monitor and manage database implementations in Azure (25–30%)
  • Monitor and troubleshoot SQL Server VMs on Azure
    • Monitor database and instance activity, monitor by using DMVs and DMFs, monitor performance and scalability
  • Monitor and troubleshoot SQL Database
    • Monitor and troubleshoot SQL Database, monitor database activity, monitor by using DMVs and DMFs, monitor performance and scalability
  • Automate and manage database implementations on Azure
    • Automate and manage SQL Server on Azure VMs, automate and manage Azure SQL Database, configure automation and runbooks

Preparation options

Online training
Instructor-led training
Exam prep video

Preparing for exam 70-473? Watch the online prep session here.

Practice test

Take a Microsoft Official Practice Test for Exam 473

Beginning in April 2017, over time, practice tests will become available in multiple languages, including Spanish, Chinese (Simplified), Chinese (Traditional), French, German, Japanese, Portuguese (Brazil), and Russian. To see when a specific language is offered for this practice test, please check back.

From the community

Who should take this exam?

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.

More information about exams

Preparing for an exam

We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.


This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all topics listed in the "Skills measured" section.

Additional resources

Exam Replay

See two great offers to help boost your odds of success.