Microsoft 70-473 Exam

I’m currently revising for the 70-473 exam on designing and implementing cloud data platform solutions, as there doesn’t yet seem to be any books available for it I’ve decided to collect some links to content here. There’s also a Microsoft video that provides a quick overview of the topics covered in the exam.

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 optimise storage, migrate an on-premises database to Microsoft Azure, configure and optimise 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

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

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 on 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

Update

So, I somehow managed to pass with 733 points. Probably the main areas to pay attention to are:

  • DMVs and when to use them.
  • Which tools to measure performance of both virtual machines and hosted SQL servers.
  • The steps need for setting up Always On clusters.
  • The SQL needed for creating keys/certificates involved in Always Encrypted.

Using the MeasureUp practice exam was also pretty useful though I’m not a fan of only getting access for either 30 or 60 days, especially given how much it costs.


3 Comments

Konrad · 28th March 2018 at 4:03 pm

HI. This is a very good material. I have heard this exam is not that hard, but looks like someone was wrong. Did you rely only on this materials ? I am curious why there is no official book.

    Shinigami · 28th March 2018 at 4:55 pm

    Hi Konrad, this is my reading list based on my not having previously covered many of the areas included in the exam before, so if you’re more familiar with the content than I was at the time it will hopefully be easier for you.

    I also used the measureup practice exam for this (http://www.measureup.com/Designing-and-Implementing-Cloud-Data-Platform-Solutions-English-P5908.aspx) which wasn’t that great but at least helped to hammer some of the details home.

    An official book would certainly have been handy for this and would have saved me a lot of Googling, I think there probably isn’t one because Azure is changing so quickly that it would be partially out-of-date as soon as it was published

      Konrad · 29th March 2018 at 9:44 am

      But there are books for the other certificates as well. Sometimes Microsoft just do not care about specific areas. Anyway, you passed. I got a lot of SQL experience. I was going to do pretty much the same thing as you did. Considering it was one year ago, i need to browse it one more time 🙂 I found somethin i didn’t have to Thank you Shinigami.

Leave a Reply

Your email address will not be published. Required fields are marked *