Microsoft SQL Server 2016 Deployment Proficiency (Advanced Level)

  • 25m
  • 25 questions
The Microsoft SQL Server 2016 Deployment Proficiency benchmark measures a learner's skills and knowledge of Microsoft SQL Server instances and storage, securing Azure SQL databases, deployment strategies, migrations, data masking, encryption, and performance settings. A learner who scores high on this benchmark demonstrates that they have the required skills to plan deployment strategies and migrate to Azure SQL databases, as well as knowledge of security, encryption, and performance settings.

Topics covered

  • configure each application tier into separate availability sets for redundancy
  • demonstrate how to configure dynamic data masking using the Azure portal
  • demonstrate how to configure SQL Server 2016 firewall rules
  • demonstrate how to create a dynamic data mask
  • demonstrate how to create an Azure SQL Server 2016 database
  • demonstrate how to deploy SQL Server using templates
  • demonstrate how to enable and disable TDE using PowerShell
  • demonstrate how to enable TDE using the Azure portal
  • demonstrate how to improve performance by changing service tiers
  • demonstrate how to query masked columns in SQL Server 2016
  • demonstrate how to use transparent data encryption
  • describe considerations involving the implementation of contained database users
  • describe how to implement SQL database auditing
  • describe how to provision an Azure SQL Server 2016 database
  • describe storage layout considerations when using virtual machines
  • describe the benefits of enabling a SQL Server firewall
  • describe the different types of platform events that can affect the availability of VMs
  • describe the security permissions required for cell-level encryption
  • describe the three approaches you can use to manage memory when running multiple instances of the database engine
  • explain how and when to use Azure resource manager
  • explain how to implement dynamic data masking policies and permissions
  • explain SQL Server 2016 database transaction units
  • explain the different types of RAID configurations
  • explain the limitations and restrictions of dynamic data masking
  • explain the restrictions involving managing logins and users