Always Learning

Advanced Search

Exam Ref 70-764 Administering a SQL Database Infrastructure with Practice Test

Exam Ref 70-764 Administering a SQL Database Infrastructure with Practice Test

Victor Isakov

Sep 2018, Paperback, 352 pages
ISBN13: 9781509305759
ISBN10: 1509305750
This title is ordered on demand which may result in extended delivery times.
Special online offer - Save 30%
Was 29.49, Now 20.64Save: 8.85
  • Print pagePrint page
  • Email this pageEmail page
  • Share

About the Book

Prepare for Microsoft Exam 70-764 and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Focus on the expertise measured by these objectives:

  • Configure data access and auditing
  • Manage backup and restore of databases
  • Manage and monitor SQL Server instances
  • Manage high availability and disaster recovery

This Microsoft Exam Ref:

  • Organizes its coverage by exam objectives
  • Features strategic, what-if scenarios to challenge you
  • Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access.

About the Practice Test

This Microsoft Official Practice Test is powered by MeasureUp

This test contains 150 questions and covers the following objectives:

  • Configure data access and auditing - 30 questions
  • Manage backup and restore of databases - 28 questions
  • Manage and monitor SQL Server instances - 61 questions
  • Manage high availability and disaster recovery - 31 questions

Why Choose the Microsoft Official Practice Test powered by MeasureUp?

Their quality content and innovative technology have earned the prestigious credential of Microsoft Certified Practice Test Provider.

•Online performance-based simulations give hands on work environment experience

•Questions are similar to exam questions so you test your knowledge of exam objectives

•Detailed explanations for both correct and distractor answers reinforce the material

•Study Mode covers all objectives ensuring topics are covered

•Certification Mode (timed) prepares students for exam taking conditions

•Instant, drill-down score reports tell you exactly the areas to focus on.

How to obtain the Practice Test

The Official Microsoft Practice Test offered with this book is fulfilled by MeasureUp.com. With your order, you will receive a product key on your Account Page. Registering the product key at MeasureUp.com will give you access to a downloadable practice test which does not expire as well as 30-day access to the online version.


Before accessing your practice test, you will be required to create an account at MeasureUp.com if you don’t already have one.


The downloadable practice test is licensed by MeasureUp for a single user and can be downloaded on up to three different devices. Downloading practice tests to virtual machines is prohibited.

Contents

Chapter 1 Configure data access and auditing

Skill 1.1: Configure encryption

Skill 1.2 Configure data access and permissions

Skill 1.3: Configure auditing


Chapter 2 Manage backup and restore of databases

Skill 2.1: Develop a backup strategy

Skill 2.2 Restore databases

Skill 2.3 Manage database integrity


Chapter 3 Manage and monitor SQL Server instances

Skill 3.1: Monitor database activity

Skill 3.2 Monitor queries

Skill 3.3 Manage indexes

Skill 3.4 Manage statistics

Skill 3.5 Monitor SQL Server instances

Chapter 4 Manage high availability and disaster recovery

Skill 4.1: Design a high availability solution

Skill 4.2: Design a disaster recovery solution

Skill 4.3: Implement log shipping

Skill 4.4: Implement Availability Groups

Skill 4.5: Implement failover clustering

Victor Isakov is a Microsoft Certified Master, Microsoft Certified Architect, and Microsoft Certified Trainer. He’s worked with SQL Server since 1994 and is a Microsoft SQL Server MVP. Victor is the author of MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design (Exam 70-441) Study Guide (Sybex, 2006) and co-author of MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide (Sybex, 2007). He also co-authored the Microsoft SQL Server 2005 Administrator’s Companion (Microsoft Press, 2006) and helped to create the High Availability course for Microsoft’s official curriculum. Currently Victor is based in Sydney, Australia, and provides consulting and training services to organizations worldwide.