The following is a list of Terms you should know when studying for the Microsoft 70-431 exam...
- ADO (ActiveX Data Objects)
- analysis server
- analysis services
- binding
- blocked process
- cascading actions
- CLR (Common Language Runtime) function
- CLR (Common Language Runtime) stored procedure
- CLR (Common Language Runtime) trigger
- CLR (Common Language Runtime) user-defined type
- data warehouse
- database lock
- deadlock
- denormalization
- deterministic
- extended stored procedure
- filter
- foreign key
- fragmentation
- job
- join
- key
- latency
- lock
- merge replication
- metadata
- normalization
- ODBC
- OLAP
- OLE DB
- OLTP
- page lock
- primary key
- RAID
- RDBMS
- rebuilding indexes
- relational database
- replication
- roll back
- roll forward
- schema
- scope
- snapshot replication
- SNMP
- SQL
- stored procedure
- T-SQL
- table lock
- TCP/IP
- transcational replication
- trigger
- variable
- view
The following is a list of Techniques you should know when studying for the Microsoft 70-431 exam...
- You need to know how to to validate hardware and software
- You must be able to perform an installation, perform the initial configuration of the server and its associated elements.
- You need to know how to provide uninterrupted service to applications.
- You need to know how to plan for and recover from failures in a controlled manner.
- You need to know how to get data into and out of the system in a variety of formats to support an array of client end functionality.
- You must know how to conduct general maintenance activities, including backup and restoration of data, automation of maintenance procedures, and other related topics.
- You need to know how to utilize the tools provided to monitor, troubleshoot, and repair the server based on standard working scenarios.
- A typical server controls dozens of different object types, and you must be familiar with the creation, alteration, and removal of each one.