Testprep Training Ltd.

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

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


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

Microsoft's SQL Server platform is one of the top three relational database products in the world's enterprise marketplace, which means that those with SQL Server skills are in high demand everywhere. This course is designed for those who want to become a SQL Server administrator.

Administering a SQL Database Infrastructure (70-764) Practice Exam prepares you to take Microsoft exam 70-764, the first of two tests you must pass in order to earn the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration certification. Passing the 70-764 exam indicates to the world that you have what it takes to administer the SQL database infrastructure.


Who should take this exam?

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.


What you will Learn?

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data


Exam Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.


Exam Details

  • Languages: English
  • Audiences: IT professionals
  • Technology: SQL Server 2016/2017/2019
  • Credit toward certification: MCSA
  • Price: $165.00 USD*


Course Structure

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
  • 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 the cause of 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


What do we offer?

  • 5 full-length mock test with unique questions in each test set
  • Practice objective questions with section-wise scores
  • In-depth and exhaustive explanation for every question
  • Reliable exam reports to evaluate strengths and weaknesses
  • Latest Questions with an updated version
  • Tips & Tricks to crack the test
  • Unlimited access


What are our Practice Exams?

  • Practice exams have been designed by professionals and domain experts that simulate real time exam scenario.
  • Practice exam questions have been created on the basis of content outlined in the official documentation.
  • Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
  • Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
  • You can also create your own practice exam based on your choice and preference 


100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee! 
If you are not able to clear the exam, you can ask for a 100% refund.

Tags: Microsoft 70-764 Exam Dumps, Administering a SQL Database Infrastructure (70-764) Practice Exam, Microsoft 70-764 Exam Questions