nerdexam
Oracle

1Z0-539 · Question #14

You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (....), the best solution is______.

The correct answer is C. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping. See the full explanation below for the reasoning.

Question

You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (....), the best solution is______.

Options

  • AInclude the tranlogoptions (exclude user) parameter in each Extract parameter file
  • BUse the add FILTERTABLE command at the GGSCI prompt
  • CUse DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping
  • DThis feature is not supported in GoldenGate 10.

How the community answered

(17 responses)
  • A
    18% (3)
  • B
    6% (1)
  • C
    71% (12)
  • D
    6% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-539 Practice