Administering a SQL Database Infrastructure (70-764) Practice Exam

The 70-764 exam from Microsoft is to validate the skills and knowledge of a SQL Server database professionals who administers SQL Server databases and their infrastructures. The exam includes installation, configuration, security, maintenance, and monitoring. Candidates are tested on ensuring the integrity of data, its availability and security, while also efficiently managing performance and disaster recovery of the databases.

Key areas of focus for the exam include:

• Configuring data access and auditing
• Managing database backups and restores
• Monitoring and managing SQL Server instances
• Ensuring high availability and disaster recovery

Why is Administering a SQL Database Infrastructure (70-764) important?

• Validates expertise in SQL Server database administration and management.
• Increases the career prospects in the areas of database administration and other IT infrastructure roles.
• Shows the capability of individual to support security and compliance activities for SQL Server databases.
• Enables more responsibilities related higher roles on data availability and performance.
• Provides industry-recognized verification of competency from Microsoft, a world-class IT organization.
• Assures companies that their teams can manage SQL Server environments effectively.

Who should take the Administering a SQL Database Infrastructure (70-764) Exam?

• Database Administrators (DBAs)
• SQL Server Administrators
• Database Engineers
• Systems Administrators
• IT Managers
• Data Analysts
• Infrastructure Specialists
• Cloud Database Administrators

Skills Evaluated

Candidates taking the certification exam on the Administering a SQL Database Infrastructure (70-764) is evaluated for the following skills:

• Installing and Configuring SQL Server Instances and Databases.
• Implement database security measures and access controls on the user.
• Monitoring and optimization of DB performance and availability
• Management of strategies for backup and restore to protect data
• Implementing disaster recovery and high availability options
• Automating routine DB maintenance tasks
• Manage SQL Server Agent jobs as well as alerts
• Configuring and managing SQL Server replication and data distribution.

Administering a SQL Database Infrastructure (70-764) Certification Course Outline
The Administering a SQL Database Infrastructure (70-764) exam certification covers the following topics -

Configure data access and auditing (20–25%)

• Configure encryption
• Configure data access and permissions
• Configure auditing

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

• Develop a backup strategy
• Restore databases
• Manage database integrity
  

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

• Monitor database activity
• Monitor queries
• Manage indexes
• Manage statistics
• Monitor SQL Server instances
  

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

• Implement log shipping
• Implement AlwaysOn Availability Groups
• Implement failover cluster instances