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

A column forms part of a WHERE clause in a create/define subscription. Where should the column be listed in the associated Replication Definition?

A. Primary key clause

B. Searchable columns clause

C. Replicate minimal columns clause

D. Replicate_if_changed clause

E. Always_replicate clause

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

What is the maximum number of routes that can exist between a given pair f Replication Servers?

A. One direct route

B. Two direct routes

C. One direct and one indirect

D. Two direct and one indirect

E. One direct and one indirect in each direction

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