Study material for exam 40-473 Designing and Implementing Cloud Data Platform Solutions

By: Daniel Calbimonte | Comments (3) | Related: More > Professional Development Certifications

Problem

I need to prepare for the Microsoft 70-473, Designing and Implementing Cloud Data Platform Solutions exam. Can you provide resources to study and pass this exam?

Solution

The Microsoft 70-473 is one of our favorite certification exams. It is related to Azure SQL, hybrid environments and Azure VMs with SQL Server.

Who should take this exam?

This exam is oriented to DBAs or professionals who want to learn or who want to be certified in Azure SQL and Azure VMs.

Is this exam a requirement for any Certification?

This exam is optional to get the MCSA in Azure (Cloud Platform Microsoft Certified Solutions Associate), it is also an optional exam for the MCSE: Data Management and Analytics.

Is this exam easy?

Yes, compared to the 70-532, 70-533 and 70-534 exams, this one is a piece of cake. However, if you do not have any experience in Microsoft exams and Azure, you should take the Exam 98-369 Cloud Fundamentals first.

Which books would you recommend for this exam?

Pro SQL Azure (Expert's Voice in .NET) is a good book to start with. It has good feedback from customers.
There is a book named 70-473: Designing and Implementing Cloud Data Platform Solutions: Study Guide written by Fernando Pupo. According to the reviews, it is hard to read and the presentation and screenshots are not great either. However, this book still has valuable information.
Another book that may help you is the Pro SQL Server on Microsoft Azure. The customer reviews for this book are not so good either, but in our opinion, the book also contains valuable information.
Microsoft Azure SQL Data Warehouse - Architecture and SQL (Tera-Tom Genius Series) Kindle Edition is the only book I found about Azure SQL Data Warehouse, it includes a lot of T-SQL code that are applicable for SQL Server on premises also.
Microsoft Azure SQL Database Step by Step (Step by Step Developer) is a good book, however it is obsolete now.

Do you recommend some courses for this exam?

Yes, here you have some useful courses:

Do you recommend any practice tests?

Yes, here are some practice tests:

Do you have some links to study, for this exam?

Yes, these links will be useful:

Design and implement database solutions for Microsoft SQL Server and SQL Database

Manage database management systems (DBMS) security

Design for high availability, disaster recovery, and scalability

Design and implement high availability solutions
Design and implement scalable solutions
Design and implement SQL Database data recovery

Monitor and manage database implementations on Azure

Monitor and troubleshoot SQL Server VMs on Azure
Monitor and troubleshoot SQL Database
Automate and manage database implementations on Azure

Next Steps

With the material provided, you can now start studying for the exam. This exam is really interesting to understand the future of databases and the cloud. If you do not have any experience in Cloud technologies and Azure, you will find the topics of this exam fascinating.

For more information about this exam, refer to these links:

About the author

Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Monday, April 29, 2019 - 1:35:34 PM - Monis	Back To Top (79839)
Hello Daniel and everyone else, I am planning to take the 70-473 exam before it expires in June 2019 . Its been 2 years since Daniel posted this article and still this article remains the best source of information regarding this exam. But possibly there may have been some updates regarding this exam and new material to go through. Any further help will be much appreciated. Thanks in advance. :-)

Thursday, November 23, 2017 - 9:50:15 AM - Luke	Back To Top (70133)
Outstanding list! Great, even to much i must admit