510-033 Online Practice Questions and Answers

Which of the following are NOT used within a Warm Standby pair? (Choose 2)

A. Replication Definition

B. Subscription

C. IBQ

D. OBQ

Which of the following can change the maximum total memory of Replication Server? (Choose 2)

A. Edit the Replication Server configuration file

B. Run rs_configure in the Replication Server

C. Run rs_configure in the RSSD

D. Run 'configure Replication Server' in the Replication Server

E. Run 'configure Replication Server' in the RSSD

Function strings can be used to? Choose 3)

A. Mdify updates flowing to a RDB.

B. Gnerate syntax for data flowing to a non-Sybase database.

C. Udate publications.

D. Secify a WHERE clause in an article.

E. Call stored procedures when applying changes to a RDB.

For which materialization method does the Replication Server initiate a holdlock on the primary table and maintain it during the entire data movement?

A. Manual atomic

B. Automatic nonatomic

C. Automatic atomic

D. Manual nonatomic

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

Which of the following are TRUE about the DSI Scheduler and DSI Executor threads when Parallel DSI is configured for a single replicate database? (Choose 2)

A. There are multiple DSI Scheduler threads, one for each DSI connection.

B. There is a single DSI Scheduler thread for all DSI connections.

C. There are multiple DSI Executor threads, one for each DSI connection.

D. There is a single DSI Executor thread for all DSI connections.

Which of the following statements is TRUE about Warm Standby?

A. Both DML and DDL may be replicated

B. Stored procedure replication is not supported

C. Warm Standby cannot replicate slow bcp

D. Warm Standby requires subscriptions for each table replicated

Which system table keeps track of transactions that commit at the primary and replicate databases in the order they have been committed?

A. Rs_locater

B. Rs_threads

C. Rs_lastcommit

D. Rs_queues