SKILL BENCHMARK
Microsoft SQL Server 2016 Installation Competency (Intermediate Level)
- 26m
- 26 questions
The Microsoft SQL Server 2016 Installation Competency benchmark measures a learner's skills and exposure of Microsoft SQL database management concepts such as the SQL server platform, versions, architecture, installation best practices, and Azure Virtual Machines. A learner who scores high on this benchmark demonstrates that they have the required skills to install Microsoft SQL Server, upgrade from older versions, and move on-premises SQL Server workloads to the cloud.
Topics covered
- configure automatic patching and updating of an Azure VM running SQL Server
- create an upgrade strategy for SQL Server 2016
- demonstrate how to connect to an Azure SQL Server 2016 database
- demonstrate how to connect to a SQL Server Azure VM
- demonstrate how to create a sysadmin account
- demonstrate how to migrate a database to a SQL Server Azure VM
- demonstrate how to use the Diskspd tool in SQL Server 2016
- demonstrate SQL Server servicing installation
- describe common service tier use cases
- describe hybrid and rolling upgrade options in SQL Server 2016
- describe parallelism in SQL Server 2016
- describe tempdb attributes
- describe the SQL Server distributed replay feature
- determine the requirements for a successful SQL Server deployment
- determine when to deploy SQL to Azure VMs and databases
- explain how and when to use the side-by-side upgrade option
- explain I/O operations in SQL Server 2016
- explain SQL Server 2016 tempdb files
- perform a backup of a database to an Azure storage account
- perform an unattended SQL Server 2016 installation
- perform a restore from an Azure storage account to an Azure VM
- recognize the differences between IaaS and on-premises deployments
- recognize the supported upgrade paths for SQL Server 2016
- recognize unattended installation options
- understand tempdb sizing
- use the data migration assistance in SQL Server 2016
