
Certificazione MCSA SQL Server Administration
PANORAMICA

Esame 70-764 Administering a SQL Database Infrastructure;
Esame 70-765 Provisioning SQL Databases;
Le certificazioni Microsoft in ambito DBA si contendono assieme a quelle Oracle i primi posti tra le più richieste dal mondo IT. In particolare la Certificazione MCSA Microsoft Sql Server è uno tra i massimi livelli di certificazione DB Administrator. L’ottenimento di una certificazione MCSA: SQL Database Administration permette di convalidare le competenze relative ad attività fondamentali quali provisioning, configurazione, manutenzione e installazione dei database e attesta la preparazione per la posizione di amministratore di database e specialista di infrastruttura.
Per conseguire la Certificazione MCSA SQL Database Administration è necessario sostenere con successo i seguenti esami:
Esame 70-764 Administering a SQL Database Infrastructure;
Esame 70-765 Provisioning SQL Databases;

Corso di Preparazione
Corso Amministratore SQL Server
Contattaci ora per ricevere tutti i dettagli e per richiedere, senza alcun impegno, di parlare direttamente con uno dei nostri Docenti CLICCA QUI.
Oppure chiamaci subito al nostro numero verde 800-177596.
SVOLGIMENTO E DURATA
Esame 70-764 Durata 120 minuti 40-60 quesiti;
Esame 70-765 Durata 120 minuti 40-60 quesiti;
Negli esami sono presenti quesiti formulati in lingua inglese in forme differenti: Risposta Multipla; completamento di testo, collegamenti concettuali Drag and Drop; vere e proprie simulazioni laboratoriali.
PREREQUISITI
Frequentare il Corso SQL Server Administrator.
ARGOMENTI D’ESAME
Esame 70-764 Administering a SQL Database Infrastructure;
- 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
- 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
- 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
- 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
Esame 70-765 Provisioning SQL Databases;
- Deploy a Microsoft Azure SQL Database
- Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools
- Plan for SQL Server installation
- Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine
- Deploy SQL Server instances
- Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates
- Deploy SQL Server databases to Azure virtual machines
- Migrate an on-premises SQL Server database to an Azure virtual machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure
- Configure secure access to Microsoft Azure SQL Databases
- Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)
- Configure SQL Server performance settings
- Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts
- Manage SQL Server instances
- Create databases, manage files and file groups, manage system database files, configure tempdb
- Manage SQL Storage
- Manage SMB file shares, manage stretch databases, configure Azure storage, change service tiers, review wait statistics, manage storage pools, recover from failed storage
- Perform database maintenance
- Monitor DMVs, maintain indexes, automate maintenance tasks, update statistics, verify database integrity, recover from database corruption