nerdexam
Oracle

1Z0-481 · Question #75

To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the…

The correct answer is D. Will the sequence of operations be affected by changing transaction boundaries? In reference guide, page 238: "Limitations of useYou should have a valid business case for using MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to alter the transactional integrity that isimposed by the boundaries that are defined by the…

Data Transformation and Filtering

Question

To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the most important thing Carlos should consider before using MAXTRANSOPS

Options

  • AWill business logic be lost if transaction boundaries are changed?
  • BWill a large number of small commits perform better than a smaller number of large commits?
  • CWill redo buffer size on the target database be adequate for the commit size?
  • DWill the sequence of operations be affected by changing transaction boundaries?

How the community answered

(20 responses)
  • A
    15% (3)
  • B
    5% (1)
  • C
    10% (2)
  • D
    70% (14)

Explanation

In reference guide, page 238: "Limitations of useYou should have a valid business case for using MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to alter the transactional integrity that isimposed by the boundaries that are defined by the source application, even though Replicatapplies the operations in the correct order."

Topics

#MAXTRANSOPS#transaction boundaries#data integrity#Replicat parameter

Community Discussion

No community discussion yet for this question.

Full 1Z0-481 Practice