510-033 Online Practice Questions and Answers

A Request Function requires which of the following?

A. Function Replication Definition

B. Replication Definition

C. Subscription

D. Publication

What is the relationship of the name of a function Replication Definition to the name of a stored procedure?

A. They have no relationship.

B. They must be the same.

C. They must be different.

D. They can be different.

Which of the following configuration options determines which transactions are placed with a given DSI-EXEC thread?

A. Dsi_num_large_xact_threads

B. Dsi_num_threads

C. Dsi_partitioning_rule

D. Dsi_serialization_method

Which statement is CORRECT about dump marker?

A. It dumps all transactions into a Stable Device.

B. It instructs ASE to write a dump marker to the log when dump begins.

C. It dumps all transactions for primary database and truncates the log.

D. It instructs Replication Server to write a dump marker in the Stable Device.

Function string classes are associated with? Function string classes are associated with

A. The primary database connection.

B. Each Replication Definition.

C. Each subscription.

D. The replicate database connection.

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

What must be TRUE for an ERSSD to be the source of a route? (Choose 2)

A. A RepAgent must be added to the interfaces file.

B. The default RepAgent name will be RSSDname_ra.

C. A direct route must exist to the ERSSD before it can be the source of the route.

D. The RepAgent must be configured for a route.

What is the default value for the configuration parameter dsi_partitioning_rule?

A. None

B. Time

C. Origin

D. Origin_sessid

Which of the following are TRUE about Automatic Warm Standby? (Choose 2)

A. Object and device names should match between Active and Standby databases.

B. Data Definition Languages cannot be replicated.

C. System tables are replicated between Active and Standby databases.

D. All tables in the database are marked for replication at once.

Which of the following will NOT improve the performance of Warm Standby?

A. Increasing the sqt_max_cache_size parameter

B. Implementing Parallel DSI

C. Creating a database Replication Definition

D. Increasing the RepAgent scan batch size