Free Oracle 1Z0-947 Exam Dumps Questions & Answers

Which statement is not true for a Data Path in the Oracle GoldenGate Microservices architecture environment?

• A.The Replicat process applies all committed changes to the target database.
• B.The Extract process stores the captured data in trail files.
• C.The Replicat process reads the trail files that are made available by the Distribution Server.
• D.The Distribution Server accesses the trail files for a defined Path.

User ______ are a set of variables.

• A.Tokens
• B.Procedures
• C.Macros
• D.Exits

You made changes to the GLOBALS parameter file using an editor on the OS. After saving your changes, you noticed the changes did not take effect. What would be the reason for this?

• A.You did not stop all replication processes running in so the changes can take effect.
• B.You did not MGR so the changes can take effect.
• C.You did not make changes on the OS logged in as the GoldenGate Administrator user.
• D.You did not restart GGSCI.

What is a "trail" in GoldenGate?

• A.A series of files that store captured data
• B.A transport layer protocol
• C.A type of error log
• D.A link between Replicat and Extract

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 insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• B.Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• C.Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
• D.Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000