Microsoft SQL Database Administration Competency (Intermediate Level)

  • 20m
  • 20 questions
Microsoft SQL Database Administration Competency (Intermediate Level) benchmark calibrates your ability to implement database security, backup and restore databases, manage database integrity, and implement high availability. You will be evaluated on your skills in administering a Microsoft SQL Server environment, database security, and implementing database fault tolerance. Learners who score high on this benchmark demonstrate that they have the skills to describe and administer Microsoft SQL Server.

Topics covered

  • Auditing SQL databases
  • Backing-up SQL databases
  • Create and configure and Azure SQL database
  • Create database users and manage access
  • describe the encryption features supported in SQL Server 2016
  • Implementing database checks and identifying corruption
  • Implementing database consistency controls
  • Implementing file restores
  • Implementing high availability for SQL Server
  • Implementing page restores
  • Implementing SQL Server policies
  • Implement row-level security
  • Manage database roles
  • Monitoring databases with the SQL Server Agent
  • Monitoring instances in SQL Server
  • Monitoring resource usage
  • Optimizing SQL queries
  • Optimizing SQL Server indexes
  • Restoring SQL databases
  • Using the SQL activity monitor