I spent around 2-3 weeks studying for the Microsoft Exam 70-473 (Designing and Implementing Cloud Data Platform Solutions) and I decided to write this post to help anyone in the same journey.
This exam will test your knowledge on Microsoft Azure SQL DB, Azure SQL Data Warehouse and SQL Server in IaaS. You also need to know some DMVs and Azure Power Shell functions.
I bought my test through http://www.mindhub.com which included:
- Exam Voucher (70-473)
- One (1) exam retake, if necessary
- One (1) Microsoft Official Practice Test, powered by MeasureUp
Before start studying for the exam, I took the Microsoft Official Practice Test, which helped me to understand areas that I should be focusing on my studies. This way is only recommended if you already have experience with Microsoft Cloud Data Platform.
If you don’t have experience with MS Cloud Data Platform I suggested you start from reading about Azure SQL Database, Azure SQL DW and SQL Server on IaaS (Azure VM). It is also important some hands-on development and setup of Azure SQL DB, SQL Data Warehouse and SQL Server on IaaS. Try to setup using Power Shell and Portal as this will help you to remember the commands during the exam.
I started my journey watching the Ignite video from James Herring and also taking the Microsoft Official Practice Test.
After that, I read a couple of documents about Azure SQL Database, Azure SQL Data Warehouse and SQL Server in Azure IaaS.
I suggest you to setup a trial Azure account on https://azure.microsoft.com/en-us/free/ and you will be able to use it for 30 days.
There is an Azure Database training available on Microsoft Learning website. I haven’t done this training, but Microsoft training is always a good start.
Azure SQL Database
In Azure SQL Database, you need to study the following: (It looks a lot to read, but some of these links are very short)
- Database Overview
- Business Continuity
- Load & Move data
- Monitor and Tune
- Scale out app
- How-to guides
- Elastic Pool PowerShell
- Elastic Pool T-SQL
- Always Encrypted cert store
- Always Encrypted key vault
- Data Masking
- Configure Vault Backups
- Geo-Replicate – Portal
- Geo-Replicate – TSQL
- Geo-Replicate – Failover – TSQL
- Restore a single table
- Load Data with BCP
- Sync Data
- Monitor & Improve Performance
- User Query Performance Insight
- Use DMVs to monitor perf
- Create alerts
- Extended Events – Event File
- Diagnostic Logging
- Create Horizontal Data
Azure SQL Data Warehouse
This section was very light in the exam and I believe it is important to understand what is Azure SQL DW and also the following areas:
Hope this gives you some guidance on what you need to study for the exam.