Online Access Free 1Z0-947 Practice Test

Which three are the responsibilities of the MGR process?

• A.Trigger execution
• B.Trail file management
• C.Data movement
• D.Process management
• E.Receive or route requests from the UI

You can create a macro library that contains one or more macros. By using a macro library, you can define a macro once and use it again and again. What is true about macro libraries?

• A.If a macro is defined in a macro library, you may only call that macro once in a parameter file.
• B.You can invoke the macros in a library only one time in COLMAP in the Replicat parameter file.
• C.You can either have the Extract or the Replicat in the same GoldenGate Home invoke the macros in the library but not from with both Extract and Replicat.
• D.You can share the macros across parameter files.

Which file is required if you're doing column mapping on the source system only?

• A.Replicat parameter file
• B.Source-definitions file
• C.Target-definitions file
• D.Extract parameter file

You have a table that has a primary key as well as an additional unique key. Failing to consistently identify a row will result in an error during conflict resolution. Which option solves this?

• A.Add unique indexes to the table to resolve the conflict.
• B.Use the SQLEXEC feature to handle errors and resolve the conflict.
• C.Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.
• D.Use the HANDLECOLLISIONS feature to handle errors and resolve the conflict.

You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?

• A.System memory
• B.The number of compound keys on the source tables
• C.The number of concurrent users
• D.Disk space