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

Nonatomic Bulk Materialization can NOT be used, if ____________ is set for Replication Definition for the primary table.

A. Autocorrection

B. Replicate minimal columns

C. Primary key

D. Searchable columns

A Replication Server CANNOT be quiesced when? (Choose 3)

A. Tere are no materialization queues.

B. Otbound DSI queues have been applied and acknowledged.

C. Rutes have been suspended.

D. Otbound DSI connections have been suspended.

E. Te RSSD dataserver has been shut down.

F. Tere are either no transactions or only open transactions on the inbound queues.

Which command displays the parameters and function string text for functions associated with a Replication Definition?

A. Rs_helpfunc

B. Rs_helpfstring

C. Rs_helpdb

D. Rs_helpclassfstring

What are the two ways to replicate stored procedures? (Choose 2)

A. Breaking down the stored procedure to multiple transactions at the replicate

B. An applied function replicating from a primary to a replicate database

C. A request function replicating from a replicate to a primary database

D. Marking the table with sp_setreplicate will replicate all procedures on the table

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

A. One

B. Two

C. Three

D. Four

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

Given that the emory_limit parameter has been configured to a high value, but the replication outbound queue is pilling up, which of the following gives the best throughput by increasing its parameter?

A. Queue_dump_buffer_size

B. Sqt_max_cache_size

C. Md_source_memory_pool

D. Num_msgqueues

E. Sts_cache_size

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