Online Access Free 1Z1-947 Exam Questions

Key names and values can be stored in:

• A.ENCKEYS
• B.GLOBALS
• C.DefsFile
• D.SourceDefs

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging. How should you proceed?

• A.Include the USEDELTA command.
• B.Include the UPDATAROWEXISTS command.
• C.Include the OVERWRITE command.
• D.Include the ADD TRANDATA command.

You find that an Extract's recovery time increases. What caused it?

• A.The difference between the start of the oldest open (uncommitted) transaction and current read position in the transaction log stored in the checkpoint file is large.
• B.The current read position (RBA) is less than the oldest open (uncommitted) transaction position.
• C.There is no oldest open (uncommitted) transaction.
• D.The oldest open (uncommitted) transaction is small.

The filter clause provides the ability to include or exclude data to process. What is true with this filter clause: Filter (ON UPDATE, ON DELETE, @Compute(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000)

• A.Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• B.Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• C.Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• D.Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000

Using the built-in lightweight filtering facility, the Distribution Server allows you to operate simple transformations while dispatching trail files to the Receiver Server.

• A.FALSE
• B.TRUE