510-033 Online Practice Questions and Answers

The admin who, sqm command is executed at the Replication Server and displays the following output.

Info First Seg.Block Last Seg.Block Next Read

133:0 ReplicateDS.RDB 4.3 4.3 4.4

Which of the following are correct? (Choose 2)

A. The queue is empty and is ready for new transactions.

B. The queue is behind and contains lots of transactions that need to be processed.

C. The queue is full and the stable device should be enlarged.

D. The queue is an inbound queue.

E. The queue is an outbound queue.

Which of the following thread types is responsible for serializing transactions?

A. DIST

B. DSI

C. RSI

D. SQM

E. SQT

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.

Which of the following items must be associated with a connection?

A. Function

B. Function instance

C. Function string

D. Function string class

E. Parent class

Which materialization method should be chosen for a table that cannot be locked and has over 100,000 rows?

A. Automatic atomic

B. Bulk atomic

C. Bulk nonatomic

D. Bulk incremental atomic

E. Automatic nonatomic

What is the maximum size of a stable device partition?

A. 1024 MB

B. 2040 MB

C. 1 GB

D. 1 TB

Which statement is TRUE about the secondary truncation point?

A. Moved by ASE whenever the oldest active transaction commits

B. Only exists in an RSSD database

C. It logical page address can be found by using the syslogshold table.

D. Always on the same page of the transaction log as the RepAgent

Which of the following is TRUE when creating a distinct function-string class that does not inherit from a system-provided class?

A. You can only create rs_insert, rs_update, and rs_delete function strings.

B. You can create all of the function strings, but you must define them yourself.

C. You cannot create function strings for columns with text or image data.

D. You can only create rs_select and rs_select_with_lock function strings for tables being replicated.

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.

What are the tables that make up the exception log? (Choose 3)

A. Rs_locator

B. Rs_exceptshdr

C. Rs_exceptscmd

D. Rs_exceptslast

E. Rs_systext