70-764 Administering a SQL Database Infrastructure
Quizzes The exam quizzes helps you to test the knowledge you have acquired through the E-Learning. Complete the quizzes to get an overview of what areas you still need to work to pass the exam.
Tips & Tricks The Cert Kit is an excellent choice for students who benefit from self-study. A handy portal of notes, tips, articles, links to communities, etc.
24/7 help support Online mentors here at CertKit can answer all your specific technical questions regarding your study subject 24/7. Your efforts will not be wasted because our online mentors are highly trained in their field, 100% guaranteed.
Practice Tests The practice exam looks and feels like the actual exam, so it is a good way to familiarize yourself with the test-taking experience.
E-learning E-Learning is the cornerstone of CertKit, it provides a thorough learning experience by including features designed to improve your productivity and productivity.
Configure data access and auditing (20–25%)
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 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
Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores
Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector
Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events
Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes
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