Exam 70-765: Provisioning SQL Databases
Skills Measured:
This exam measures your ability to accomplish the technical tasks listed below.
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