510-033 Online Practice Questions and Answers

Which of the following queues is used by Warm Standby to replicate data?

A. Inbound queue

B. Outbound queue

C. Dematerialization queue

D. Materialization queue

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

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.

How many total Inbound and Outbound queues exist in a Replication Server with two Primary Databases, one outgoing route, and one incoming route?

A. 4

B. 5

C. 6

D. 7

E. 8

How many stored procedures are needed to implement round trip function replication?

A. One

B. Two

C. Three

D. Four

Which command is used to add a subscription to the system tables at the primary and replicate Replication Server when employing bulk nonatomic materialization?

A. Create subscription

B. Activate subscription

C. Define subscription

D. Validate subscription

For a Replication Server to be the source of a route, what is necessary?

A. At least one DSI connection to a user database

B. Replication Server RSSD requires a RepAgent

C. RSSD must be hosted in an Adaptive Server Enterprise

D. Replication Server requires SA access to a second Replication Server

Which Replication Server component is responsible for preventing transactions from being truncated until they are safely stored in the Replication Server stable device?

A. DIST

B. SQM

C. SQL

D. RepAgent

Which thread performs function string mapping?

A. SQM

B. DSI

C. DSI EXEC

D. RSI

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