Exam 70-764: Administering a SQL Database Infrastructure
Languages: English
This examination is intended for database experts that do setup, maintenance, and also setup jobs. Other obligations include setting up database systems, seeing to it those systems run effectively, and also routinely keeping, backing up, as well as protecting information from unauthorized gain access to.
Part of the requirements for: MCSA: Microsoft Dynamics 365 for Operations MCSA: SQL 2016 Database Administration
Exam 70-765: Provisioning SQL Databases
Languages: English
This test is planned for architects, senior designers, framework experts, as well as advancement leads. Candidates have a working knowledge of the various cloud solution designs and also service version architectures, data storage space choices, and information synchronization techniques. Candidates also have a functioning understanding of deployment models, updating as well as moving databases, and applications and also solutions, in addition to incorporating Azure applications with external sources.
Part of the requirements for: MCSA: Microsoft Dynamics 365 for OperationsMCSA: SQL 2016 Database Administration
Zabeel international institute of management technology Offer High Demand in IT Courses and technology management industry. We are one of the Top ranking training institute in Dubai .
Exam 70-764: Administering a SQL Database Infrastructure
Configure data access and auditing (20–25%)
Configure encryption
carry out cell-level file encryption, carry out Constantly Encrypted, apply backup security, configure clear information security, set up encryption for links, repair encryption mistakes
Configure auditing
configure an audit on SQL Server, inquire the SQL Web server audit log, take care of a SQL Server audit, set up an Azure SQL Data source audit, analyze audit logs and also records from Azure SQL Database
Manage backup and restore of databases (20–25%)
Develop a backup strategy
back up very large data sources, set up informing for failed back-ups, back up databases to Azure, handle deal log backups, configure database recuperation versions, set up backup automation
Restore databases
perform bit-by-bit brings back, carry out page recuperation, perform point-in-time recovery, restore file groups, create a plan to automate and also evaluate brings back
Manage database integrity
carry out database uniformity checks, identify database corruption, recover from data source corruption
Manage and monitor SQL Server instances (35–40%)
Monitor database activity
monitor current sessions, recognize sessions that cause blocking activity, recognize sessions that take in tempdb resources, set up the information collection agency
Monitor queries
take care of the Query Shop, configure Extensive Events and trace occasions, determine problematic execution plans, troubleshoot server health using Prolonged Occasions
Manage indexes
determine and also fix index fragmentation, recognize as well as develop missing indexes, identify and also go down underutilized indexes, take care of existing column store indexes
Manage statistics
recognize and correct outdated stats, carry out Car Update Statistics, apply stats for huge tables
Monitor SQL Server instances
create as well as take care of drivers, create as well as manage SQL Representative alerts, define custom-made alert actions, specify failure activities, configure data source mail, configure Policy-Based Administration, determine readily available area on data quantities, determine the root cause of performance deterioration
Manage high availability and disaster recovery (20–25%)
Implement log shipping
set up log delivery, display log delivery
Implement Always On Availability Groups
Configure Windows clustering, develop an accessibility group, set up read-only directing, take care of failover, and develop dispersed schedule teams
Implement failover cluster instances
manage shared disks, set up cluster shared quantities
Select a service rate; create web servers and databases; develop a sysadmin account; set up flexible pools
Plan for SQL Server installation
Prepare for an IaaS or on-premises release; choose the suitable dimension for a digital device; strategy storage pools based upon performance needs; examine best practices for setup; style a storage space layout for a SQL Server online machine
Deploy SQL Server instances
Deploy a SQL Server instance in IaaS as well as on-premises; manually mount SQL Server on an Azure virtual equipment; stipulation an Azure digital machine to host a SQL Server circumstances; automate the release of SQL Web server data sources; deploy SQL Server by using templates
Deploy SQL Server databases to Azure virtual machines
Move an on-premises SQL Server database to an Azure online device; generate benchmark information for efficiency needs; execute efficiency adjusting on Azure IaaS; support accessibility embed in Azure
Manage databases and instances (30-35%)
Configure secure access to Microsoft Azure SQL databases
Set up firewall rules; set up Always Encrypted for Azure SQL Database; set up cell level encryption; set up vibrant information concealing; set up transparent information encryption (TDE).
Configure SQL Server performance settings
Configure database performance settings; configure max server memory; configure the database scope; set up operators and also signals
Manage SQL Server instance
Develop data sources; take care of data and documents teams; handle system data source data; set up tempdb.
Manage Storage (30-35%)
Manage SQL Storage
Take care of SMB data shares; handle stretch databases; configure Azure storage space; modification solution tiers; evaluation delay statistics; take care of storage pools; recover from failed storage
