Which of the following are TRUE about articles? (Choose 2)

A. Must contain a reference to an existing Replication Definition in the same primary database

B. Must be defined in the replicate database where the associated subscription will be created

C. May contain a WHERE clause that limits the selection of data from a table referenced in the associated Replication Definition

D. Once created, can be utilized in any publication definition that references it

E. Must contain all column names included in the searchable columns of the associated Replication Definition

Which of the following subscription types does not use the same command as the others?

A. Automatic/atomic materialization

B. Automatic/nonatomic materialization

C. Bulk/atomic materialization

D. Bulk/nonatomic materialization

Which of the following is TRUE for a Warm Standby configuration? (Choose 2)

A. Requires Replication Definition for tables

B. Does not utilize the outbound queue

C. Subscription is not used

D. Supports concurrent bi-directional transaction replication

E. Can be configured to support multiple standby

Which of the following commands can be used to indicate that the RepAgent is running in the primary database? (Choose 3)

A. Sp_who

B. Admin who

C. Sp_help_rep_agent

D. Admin who, sqm

E. Sp_helpdb

What information can be obtained by the use of the Replication Server command "admin who, dsi"?

A. The name and current state of processes running on the server.

B. The current values of parameter settings for dsi threads.

C. The current values of all dsi EXEC thread parameters.

D. The name and current state of dsi processes running on the server.