Limited Time 30% Discount Offer Use Code - off30

70-764 - Bundle Pack

Actualkey Prepration Latest 70-764 : Administering a SQL Database Infrastructure Exam Questions and Answers PDF's, Verified Answers via Experts - Pass Your Exam For Sure and instant Downloads - "Money Back Guarantee".


Vendor Microsoft
Certification Microsoft Certified Professional
Exam Code 70-764
Title Administering a SQL Database Infrastructure Exam
No Of Questions 445
Last Updated July 1,2024
Product Type Q & A with Explanation
Bundel Pack Included PDF + Offline / Andriod Testing Engine and Simulator

Bundle Pack

PRICE: $25

70-764 : BUNDLE PACK LEARNING TOOLS INCLUDED

Actualkey Products

PDF Questions & Answers

Exam Code : 70-764 - Jul 1,2024
Try Demo
Testing Engine

Offline Test Engine

Exam Code : 70-764 - Jul 1,2024
Try Demo
android testing engine

Android Test Engine

Exam Code : 70-764 - Jul 1,2024
Try Demo
online Exam Engine

Online Test Engine

Exam Code : 70-764 - Jul 1,2024

Exam 70-764
Administering a SQL Database Infrastructure


Published: October 18, 2016
Languages: English
Audiences: IT professionals
Technology: SQL Server
Credit toward certification: MCP, MCSA

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.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

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

SATISFIED CUSTOMERS