Configure data access and Auditing (20–25%)Configure encryption
Configure data access and permissions
Configure auditing
|
Manage backup and restore of databases (20-25%)Develop a backup strategy
Restore databases
Manage database integrity
|
Manage and monitor SQL Server instances (35-40%)Monitor database activity
Monitor queries
Manage indexes
Manage statistics
Monitor SQL Server instances
|
Manage high availability and disaster recovery (20-25%)Implement log shipping
Implement AlwaysOn Availability Groups
Implement failover cluster instances
|
Implement SQL in Azure (40–45%)Deploy a Microsoft Azure SQL Database
Plan for SQL Server installation
Deploy SQL Server instances
Deploy SQL Server databases to Azure virtual machines
|
Manange databases and instances (30-35%)Configure secure access to Microsoft Azure SQL Databases
Configure SQL Server performance settings
Manage SQL Server instances
|
Manage Storage (30-35%)Manage SQL Storage
Perform database maintenance
|