Published: October 27, 2015
Languages: English
Audiences: IT Professionals
Technology: Microsoft Azure
Credit toward certification: Specialist
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.
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
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
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, 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
Design a backup solution for SQL Database, implement self-service restore, copy and export databases
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
Click here to view complete Q&A of 70-473 exam
Certkingdom Review
Best Microsoft MCTS Certification, Microsoft 70-473 Training at certkingdom.com