70-432

Front 1

Agent profile

Back 1

A set of confi guration options that are
applied to a replication agent.

Front 2

Alert

Back 2

An object that can be created to respond to a
change in the system state.

Front 3

Article

Back 3

The most granular unit of a publication. Articles
can be defi ned for tables, views, stored procedures, and
functions.

Front 4

Asymmetric key

Back 4

A key that conforms to the X.509
standard which can be used to encrypt data within a
column.

Front 5

Backup job

Back 5

A scheduled job in SQL Server Agent that
creates the transaction log backups for a log shipping
session.

Front 6

Balanced tree (B-tree)

Back 6

A symmetric, linear structure
used to construct an index. A B-tree provides a compact
structure that enables searching very large volumes of
data with a small number of read operations.

Front 7

Bulk Copy Program (BCP)

Back 7

A command-line utility that
is used to import data from a fi le into a table, as well as
export data to a fi le.

Front 8

BULK INSERT

Back 8

A T-SQL command that allows you to
import data from a fi le into a table or view.

Front 9

Certificate

Back 9

A key that conforms to the X.509 standard
used to encrypt data in a column as well as a database
encryption key for transparent data encryption.
Certifi cates can be backed up and restored, making
them more portable than an asymmetric key.

Front 10

Check constraint

Back 10

Limits the range of possible values
that are allowed in a column.