510-033 Online Practice Questions and Answers

What is the default serialization method in the command dsi_serialization_method?

A. No_wait

B. Wait_for_start

C. Wait_for_commit

D. None

Which command can be used to monitor the switching process before it is completed?

A. Dmin logical_status,

B. Admin who, dsi

C. Admin who_is_down

D. Switch active for

Which of the following is TRUE regarding the operation of an automatic Warm Standby system? (Choose 2)

A. An active database can have one or more standby databases and any database can contain both active and standby data.

B. All DML and DDL changes to the active system are replicated to the standby system.

C. The minimally logged command 'truncate table' is a DML command that is replicated in a Warm Standby system.

D. The 'SELECT INTO' command is replicated because all tables in the active system are marked for replication to the standby.

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 are prevented by having Replication Definitions specifying replicate minimal columns? (Choose 2)

A. Warm Standby

B. Default function string

C. Custom function sting

D. Autocorrection

E. Publication

Which of the following statements is TRUE about stored procedure replication?

A. Multiple Replication Definitions can be created for a stored procedure.

B. To create a subscription to a stored procedure Replication Definition, only the "create subscription" command can be used.

C. The name of the replicate stored procedure can be different from the name of the primary stored procedure.

D. In a stored procedure Replication Definition, the "searchable parameters" clause can be specified but does not fulfill any function.

Which of the following statements describe the behavior of Publications? (Choose 2)

A. Improve replication performance

B. Degrade replication performance

C. May centralize administrative effort

D. May reduce total administrative effort

Which queue does the command "sysadmin dump_queue 103,0,-1,1,-2" display?

A. Inbound queue

B. Materialization queue

C. Outbound queue

D. Transaction queue

E. Message queue

What is the serialization method with the highest degree of parallelism called?

A. Wait_for_start.

B. Isolation level 3.

C. No_wait.

D. None.

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