Microsoft Administering a SQL Database Infrastructure (MCSA Dynamics 365 for Operations) Exam Syllabus

Administering a SQL Database Infrastructure PDF, 70-764 Dumps, 70-764 PDF, Administering a SQL Database Infrastructure VCE, 70-764 Questions PDF, Microsoft 70-764 VCE, Microsoft MCSA Dynamics 365 for Operations Dumps, Microsoft MCSA Dynamics 365 for Operations PDFUse this quick start guide to collect all the information about Microsoft Administering a SQL Database Infrastructure (70-764) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the 70-764 Administering a Microsoft SQL Database Infrastructure exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual Microsoft MCSA Dynamics 365 for Operations certification exam.

The Microsoft Administering a SQL Database Infrastructure certification is mainly targeted to those candidates who want to build their career in Microsoft SQL Server 2016/2017/2019 domain. The Microsoft Certified Solutions Associate (MCSA) - Dynamics 365 for Operations exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of Microsoft MCSA Dynamics 365 for Operations.

Microsoft Administering a SQL Database Infrastructure Exam Summary:

Exam Name Microsoft Certified Solutions Associate (MCSA) - Dynamics 365 for Operations
Exam Code 70-764
Exam Price $165 (USD)
Duration 120 mins
Number of Questions 40-60
Passing Score 700 / 1000
Books / Training 20764: Administering a SQL Database Infrastructure (five days)
Schedule Exam Pearson VUE
Sample Questions Microsoft Administering a SQL Database Infrastructure Sample Questions
Practice Exam Microsoft 70-764 Certification Practice Exam

Microsoft 70-764 Exam Syllabus Topics:

Topic Details Weights
Configure data access and auditing

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

 20-25%
Manage backup and restore of databases

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

 20-25%
Manage and monitor SQL Server instances

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

 35-40%
Manage high availability and disaster recovery

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

 20-25%

To ensure success in Microsoft MCSA Dynamics 365 for Operations certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for Administering a Microsoft SQL Database Infrastructure (70-764) exam.

Rating: 5 / 5 (35 votes)