Published: August 26, 2016
Audiences: IT professionals
Technology: SQL Server
Credit toward certification: MCP, MCSA
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. 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.
Implement SQL in Azure (30–35%)
Deploy a Microsoft Azure SQL Database
Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools
Plan for SQL Server installation
Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine
Deploy SQL Server instances
Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates
Manage databases and instances (35–40%)
Configure secure access to Microsoft Azure SQL Databases
Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)
Configure SQL Server performance settings
Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts
Manage SQL Server instances
Create databases, manage files and file groups, manage system database files, configure tempdb
Deploy and migrate applications (30–35%)
Deploy applications to Microsoft Azure SQL Database
Manage deployments that support multiple tenants, migrate on-premises SQL Server to Azure SQL Database, migrate data to Azure SQL Database
Deploy applications to SQL Server on Azure Virtual Machines
Migrate an on-premises SQL Server database to an Azure Virtual Machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure
Migrate client applications
Configure application connection strings, manage traffic between on-premises applications and Azure services, develop application retry connection logic, identify application patterns that must be migrated with SQL Server data, evaluate network performance between applications and databases