1z0-447 by Oracle Valid Free Exam Practice Test

Question 1

Which three are types of encryption supported by OGG?

A. Password B. Trial file encryption C. Parameter file encryption D. Message encryption

Correct Answer: A,B,C

Question 2

You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?

A. You can configure integrated Replicat
withASSUMETARGETDEFSandSPECIALRUNparameters. B. You can configure integrated Replicat with two parallel child servers. C. You can configure integrated Replicat with theSPECIALRUNparameter. D. You can configure integrated Replicat with two parallel apply servers.

Correct Answer: D

Question 3

You are running multiple installations of Oracle GoldenGate on the same Windows server.
How can you differentiate the different Manager services?

A. Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name. B. Accept the default service name and manually edit within the Services applet. C. Multiple Manager services are not allowed on the same Windows server. D. Include the parameterSERVICENAMEin each Manager, with a unique name.

Correct Answer: A

Question 4

How should you configure Replicat to control how errors are handled in one-way replication?

A. UseHANDLECOLLISIONin the Replicat parameter file. B. Use Conflict Detection and Resolution in the Replicat parameter file. C. UseMAPEXCEPTIONin the Replicat parameter file. D. UseREPERRORin the Replicat parameter file.

Correct Answer: D

Question 5

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. disk space B. the number of concurrent users C. system memory D. the number of compound keys on the source tables

Correct Answer: C

Question 6

When is a Pump not required to connect to a source database?

A. when aPASSTHRUparameter is used B. when aNOPASSTHRUparameter is used C. when transformations, filtering, and mapping are required D. when look-ups are needed against the source database

Correct Answer: D

Question 7

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

A. ENABLE_STREAMS_REPLICATION=true B. ENABLE_GOLDENGATE_REPLICATION=true C. ENABLE_DATABASE_REPLICATION=true D. Configure theSTREAMS_POOL_SIZEdatabase parameter

Correct Answer: B

Question 8

Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?

A. DEFERAPPLYINTERVAL B. SPECIALRUN C. BATCHSQL D. ASSUMETARGETDEFS

Correct Answer: C

Oracle GoldenGate 12c Implementation Essentials - 1z0-447 Exam Practice Test