Inhoud ICT-cursus 70-462 Administering Microsoft SQL Server 2012 Databases

Inhoud van de ICT-cursus 70-462 Administering Microsoft SQL Server 2012 Databases | De Kantooropleider

Tijdens de ICT-cursus 70-462 Administering Microsoft SQL Server 2012 Databases worden de volgende onderdelen behandeld:

Instance Configuration and Database Creation

  • use Configuration Manager to manage SQL Server 2012 services
  • recognize the steps involved in configuring a Windows Firewall for Database Engine Access
  • recognize the functions of the different pages in the Server Properties dialog box
  • describe how to add features and components to a SQL Server 2012 installation
  • configure Reporting Services using Reporting Services Configuration Manager
  • identify how Reporting Services can work with SharePoint
  • enable SQL Server features
  • perform configuration tasks on SQL Server 2012 instances
  • describe the characteristics of databases and their architecture
  • match the database type to its description
  • create a database
  • change database options
  • identify the features of databases
  • use a variety of methods to create databases and alter their preferences

Managing Databases and Automating Tasks

  • recognize how to perform database management tasks using the DBCC CHECKDB command
  • alter the size of a database
  • describe the features of Database Mail
  • use the Database Mail Configuration Wizard to configure Database Mail
  • manage a SQL Server 2012 database
  • configure and manage Database Mail
  • identify the steps to configure SQL Server Agent to automate SQL Server administration
  • create a SQL Server Agent job
  • describe the characteristics of automated server administration in SQL Server 2012
  • set up servers to facilitate administrative job automation
  • recognize how to manage SQL Server Agent Jobs
  • recognize how to manage target servers
  • use SQL Server Agent to automate SQL Server administration
  • manage servers and jobs

Security Management

  • describe the characteristics of resource security in SQL Server 2012
  • recognize how the fn_builtin_permissions function is used to obtain information on granted permissions
  • recognize how to create logins
  • describe the characteristics of credentials and roles
  • describe how to manage database users in SQL Server 2012
  • identify how data encryption is used in SQL Server 2012
  • sequence the steps involved in Transparent Data Encryption
  • manage access in SQL Server 2012
  • use data encryption in SQL Server 2012
  • match the SQL Server 2012 audit components to their descriptions
  • use the auditing features in SQL Server 2012
  • describe the characteristics of policy-based management in SQL Server 2012
  • recognize how to use policy-based management in SQL Server 2012
  • create an audit and an audit specification for a given scenario
  • use policy-based management in SQL Server 2012

Managing Database Data

  • identify the characteristics of FILESTREAM
  • enable and configure FILESTREAM
  • identify the considerations involved in implementing FileTables
  • manage FileTables using Transact-SQL
  • determine the most appropriate method for populating FileTables for a given scenario
  • describe the considerations involved in using data compression
  • enable compression
  • use SQL Server 2012 features to manage the storage of files
  • implement a data compression solution for a given scenario
  • describe the considerations involved in working with bulk data in SQL Server 2012
  • use the bcp utility to move data
  • recognize how to create file formats
  • use the Transact-SQL statements that support bulk importing
  • use SQL Server 2012 data import and export tools

Managing Indexes, Full-Text Search and Partitions

  • match the indexes that can be used in SQL Server 2012 to their descriptions
  • recognize the considerations associated with creating different types of indexes
  • recognize the options available for managing indexes
  • perform index maintenance
  • describe the characteristics of indexes in SQL Server 2012
  • manage and maintain indexes
  • recognize the steps for enabling full-text search
  • implement full-text search in SQL Server 2012
  • describe the features of partitioning in SQL Server 2012
  • recognize how to manage partitioning in SQL Server 2012
  • use full-text search in SQL Server 2012
  • recognize how to employ partitioning in SQL Server 2012

Backing Up and Restoring Databases

  • determine the most appropriate recovery model for a given scenario
  • choose a logical backup device
  • match the different kinds of backups to their descriptions
  • recognize how to create a database backup
  • describe the consideration involved in planning to restore a database
  • recognize how to restore a database for a given scenario
  • determine when to use particular backup types
  • determine which recovery models and backup types should be used in a given scenario
  • create database backups
  • use SQL Server 2012 restore features

Database Monitoring and Performance Tuning

  • describe the importance of database monitoring
  • recognize how SQL Server Profiler is used to monitor a database
  • describe the characteristics of SQL Server 2012’s performance monitoring tools
  • create an Extended Event session using the CREATE EVENT SESSION statement
  • configure the management data warehouse to support data storage on instances of SQL Server that are using the data collector
  • recognize how Resource Governor is used to manage resources
  • monitor databases
  • access data to solve a server issues
  • describe how to manage SQL Server workload using Resource Governor
  • recognize how locking is used to secure data integrity in a SQL Server 2012 database
  • describe how to minimize deadlocks
  • manage deadlocks
  • describe how locking is used in a SQL Server 2012 database
  • use the features of SQL Server 2012 to manage and resolve deadlocks

Configuring High Availability

  • match the high availability solutions to their descriptions
  • describe the considerations involved in installing SQL Server AlwaysOn Failover Clustering
  • match the steps in the failover process with appropriate examples
  • describe the considerations involved in implementing AlwaysOn Availability Groups
  • implement AlwaysOn Availability Groups
  • prepare for database mirroring
  • describe how to set up database mirroring
  • describe how to monitor database mirroring sessions
  • describe the options when setting up replication
  • match the subscription types to their description
  • determine the most appropriate high availability solution for a given scenario
  • recognize the considerations involved in implementing AlwaysOn Availability Groups and SQL Server Failover Clustering
  • implement database mirroring
  • recognize how to distribute data and database objects using replication

TestPrep 70-462 Administering Microsoft SQL Server 2012 Databases

  • TestPrep 70-462 Administering Microsoft SQL Server 2012 Databases
Print pagina