70-764: Administering a SQL Database Infrastructure


SKU: LPL-159 Category:

The 70-764 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016.
By completing the lab tasks, you will improve your practical skills in configuring access to data and auditing, managing backups and restoring a database, managing and monitoring SQL Server instances, managing high availability and disaster recovery.
These same tasks will help you understand the objectives and competencies required by the Microsoft 70-764 Administering a SQL Database Infrastructure exam.

About Practice Labs

In today’s world of complex computer systems and technologies it’s essential that both those new to IT and seasoned professionals alike gain hands on experience. Our state-of-the-art platform brings training theory to life giving the user greater depth of technology ensuring their ability to demonstrate how to use and understand vendor products and software.

Get the hands on learning you need without spending significant amounts of money on your own equipment. We deliver real equipment with the ease and convenience of your web browser, allowing you to develop real world IT skills.


  • Risk free platform to develop practical IT skills in all the latest technologies
  • Real world and exam related practical tasks
  • Real equipment NOT simulations
  • Simply accessed from a web browser, anytime, anywhere – 24/7

Learning Objectives

Data Encryption
Backup and Connection Encryption
Manage Database Object Permissions
Configuring Security Options
Configuring Audits for SQL Server
Backing Up Databases
Piecemeal Restore of Database and File Groups
Working with Restore Options
Maintaining Database Integrity
Monitoring the Database Activity
Configuring Data Collection and UCP
Managing a Query Store
Using Trace and Extended Events
Managing Indexes
Managing Statistics
Managing Operators
Monitoring SQL Server
Configuring Log Shipping