Question 1.
If a subcription is created using the parameter without holdlock, the materialization method is:

A. Automatic atomic incremental
B. Automatic nonatomic
C. Bulk Atomic
D. Bulk Nonatomic

Answer: B

Question 2.
A route is required from Replication Server A to Replication Server B if data will: ( Choose 2)

A. Be Replicated from A to B
B. Be Replicated from B to A.
C. Not be replicated between the two Replication Servers.
D. Be Replicated in both directions - A to B and B to A.

Answer: A, D

Question 3.
Which of the following are TRUE about subscriptions? (Choose 2)

A. Columns with a defined lenght greater thatn 255 bytes cannot be named in where clauses.
B. Values with more than 255 bytes cannot be used in where clauses.
C. Columns with a defined length greater that 255 bytes can be named in where clauses.
D. Values with more that 255 bytes can be used in where clauses.

Answer: B, C

Question 4.
Which of the following are TRUE about request functions?

A. They replicate the execution of stored procedures in a primary database to a replicate 
    database.
B. Deliver the execution of stored procedure from a replicate database to a primary database.
C. They Require a subcription at the replicate datgabase.
D. They Replicate operations that are difficult the express though subscriptions to tables.

Answer: B

Question 5.
Which of the following should be done first if the DSI Suspends?

A. Resume connection server.database skip transaction
B. rs_subcmp
C. Read the error logs
D. admin quiesce_check
E. rs_helpexception

Answer: C

Question 6.
Where does Replication Server get the address of other servers?

A. The ID Server
B. The interfaces file
C. The primary database
D. The replicate database
E. The rs_site table.

Answer: B

Question 7.
A database can be added to a Replication Server system using: (Choose 3)

A. create connection
B. create database
C. rs_int
D. rs_subcmp
E. Sybase Central

Answer: A, C, E

Question 8.
Which of the following is TRUE in a Warm Standby environment?

A. replication definitions are required.
B. subscriptions are required.
C. replication definitions are optional
D. subscriptions are optional.

Answer: C

Question 9.
Which of the following are TRUE about automatic Warm Standby? (Choose Three)

A. Stored procedure execution is automatically marked for replication.
B. Changes to master database are not replicated.
C. User and Group Information are Replicated.
D. Only the Resuls of triggers are replicated.

Answer: B, C, D

Question 10.
If changes take place on a primary table during bulk materialization, Which of the following would help prevent duplicates?

A. Nothing- You would need to run rs_subcmp afterwards.
B. Shutdown the RepAgent in the source database.
C. Turn on autocorrection for the replication definition underlying the subscription.
D. Truncate the inbound queue.

Answer: C

	Web www.certsbraindumps.com