Exam - 70-764 - Administering a SQL Database Infrastructure

Code: 70-764

Exam - 70-764 - Administering a SQL Database Infrastructure

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Prerequisties:

Microsoft Training 20764 - Administering a SQL Database Infrastructure

 

Configure data access and auditing (20–25%)

Configure encryption

  • Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors

Configure data access and permissions

  • Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking

Configure auditing

  • Configure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database

Manage backup and restore of databases (20–25%)

Develop a backup strategy

  • Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation

Restore databases

  • Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores

Manage database integrity

  • Implement database consistency checks, identify database corruption, recover from database corruption

Manage and monitor SQL Server instances (35–40%)

Monitor database activity

  • Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector, create a utility control point (UCP)

Monitor queries

  • Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events

Manage indexes

  • Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes

Manage statistics

  • Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables

Monitor SQL Server instances

  • Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify performance degradation

Manage high availability and disaster recovery (20–25%)

Implement log shipping

  • Configure log shipping, monitor log shipping

Implement AlwaysOn Availability Groups

  • Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups

Implement failover cluster instances

  • Manage shared disks, configure cluster shared volumes

 

Guaranteed to Run

2018-03-07 09:00 to 2018-03-09 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2017-12-11 09:00 to 2017-12-15 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-11-27 09:00 to 2017-12-01 17:00
Attend Online
2017-11-27 08:00 to 2017-12-01 17:15
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review