SKILL BENCHMARK

Microsoft SQL Server 2016 Installation Competency

  • 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

recently added courses