Update 1Z0-447 Training Materials 2021

NEW QUESTION 1
Which GLOBALS parameter is required to initially enable monitoring?

• A. JAGENTMONITORING
• B. ENABLEMONITORING
• C. ENABLEOEMMONITORING
• D. CHECKMONITORING

Answer: B

NEW QUESTION 2
Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

• A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
• B. The Extract will revert to single-row fetch mode for all tables.
• C. The Extract will abend unless LOBMEMORY is increased.
• D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Answer: A

NEW QUESTION 3
Which parameter could you use to start an Extract when Manager starts?

• A. START
• B. BEGIN
• C. AUTOSTART
• D. PROCESS

Answer: C

NEW QUESTION 4
Your Goldengate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version.
How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key?

• A. GoldenGate deployments cannot use a shared wallet.
• B. View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by allReplicat groups.
• C. View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.
• D. View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old ke
• E. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.

Answer: D

NEW QUESTION 5
How can you tell if GoldenGate has been configured for batch processing?

• A. TheSPECIALRUNparameter is in the Replicat parameter file.
• B. Replicat is started with theINITIALLOADtask.
• C. There is a dedicated GoldenGate process calledSPECIALRUN.
• D. TheSPECIALRUNparameter is in theGLOBALSparameter file.

Answer: B

NEW QUESTION 6
How does Replicate know the structure of the source tables when the target has a different layout?

• A. GoldenGate trail file contains the metadata of incoming data
• B. Replicat uses an ODBC connection to connect to the source system tables
• C. Parameter file contains table layouts
• D. Discard file contains table layouts
• E. Source Definitions file contains table layouts

Answer: E

NEW QUESTION 7
What process is the recommended method to purge old GoldenGate trials?

• A. Extract r
• B. Replicat
• C. Manager
• D. Manager and Replica

Answer: C

NEW QUESTION 8
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. Include the parameterSERVICENAMEin each Manager, with a unique name.
• C. Accept the default service name and manually edit within the Services applet.
• D. Multiple Manager services are not allowed on the same Windows server.

Answer: A

NEW QUESTION 9
If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

• A. Manager
• B. Extract
• C. Replicat
• D. Both Extract and Replicat

Answer: A

Explanation:
In reference guide, page 256, and I quote "If multiple groups are reading the same set of trail files, one process could purge a file before another is finished with it. Instead, use theManager version of PURGEOLDEXTRACTS, which is the preferred use of the parameter in all GoldenGate configurationsbecause it allows you to manage trail files in a centralized fashion."

NEW QUESTION 10
Which statement is valid for DDL replication?

• A. GoldenGate User Exits are not supported for DDL.
• B. Source and target objects can be different.
• C. Target objects can be different from source when usingSOURCEDEFSin Replicat.
• D. It can useWILDCARDRESOLVE IMMEDIATE.

Answer: B

NEW QUESTION 11
Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

• A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
• C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Answer: C

NEW QUESTION 12
You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

• A. File to Replicat
• B. GoldenGate Direct Load
• C. File to database utility
• D. Direct bulk load to SQL*Loader

Answer: D

NEW QUESTION 13
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 theOVERWRITEcommand.
• B. Include theUSEDELTAcommand.
• C. Include theADD TRANDATAcommand.
• D. Include theUPDATAROWEXISTScommand.

Answer: C

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

Answer: C

NEW QUESTION 15
You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

• A. It is caused byTHREAD and THREADRANGEbeing used with wildcard MAP statements.
• B. It is caused by the thread with the highest thread ID applying barrier transactions.
• C. It is caused by the use of theMAXTRANSOPSparameter.
• D. It is caused by barrier transactions in a Coordinated Replicat.

Answer: D

NEW QUESTION 16
Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

• A. View the maybe out-of-sync (MOOS) queue.
• B. View the Veridata log file.
• C. View the confirm-out-of-sync (COOS) queue.
• D. View the Veridata Agent repository.

Answer: A

NEW QUESTION 17
You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.
How should you accomplish this?

• A. Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicatparameter file to specify columns that are to be used with before values in the ReplicatWHERE clause.
• B. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.
• C. Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.
• D. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

Answer: B

NEW QUESTION 18
Which statement regarding the GoldenGate Data Pump is incorrect?

• A. Data Pump is a separate process.
• B. Data Pump can be used to pump trail records to multiple locations.
• C. Data Pump has distance limitations.
• D. Data Pump uses TCP/IP to route the trail records.

Answer: A

NEW QUESTION 19
Ideally which process should be configured purge old trial files?

• A. Manager
• B. Extract
• C. Replicat
• D. Pump

Answer: A

NEW QUESTION 20
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 with two parallel apply servers.
• 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 withASSUMETARGETDEFSandSPECIALRUNparameters.

Answer: A

NEW QUESTION 21
What is the default threshold for message compression in OGG?

• A. 1000
• B. 100
• C. O
• D. By default, messages are not compressed.

Answer: A

NEW QUESTION 22
Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?

• A. TARGETDB TargetDSN USERID sampleID PASSWORD samplepword
• B. SOURCEDB SourceDSN
• C. SOURCEDB sampleDB USERID sampleID PASSWORD samplepword
• D. TARGETDB sampleID samplepword

Answer: B

NEW QUESTION 23
......