1z0-447 Practice Dumps - Verified By TestkingPDF Updated 72 Questions [Q33-Q57]

1z0-447 Practice Dumps - Verified By TestkingPDF Updated 72 Questions

Updated 1z0-447 Exam Dumps - PDF Questions and Testing Engine

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

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

Answer: E

Explanation:
Reference:
http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-8-filtering-and-mapping- data/

 

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

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

Answer: B

Explanation:
Reference:https://docs.oracle.com/goldengate/1212/gg-
winux/GIORA/setup.htm#GIORA983

 

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

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

Answer: B

Explanation:
Explanation/Reference:
Reference: http://www.dba-oracle.com/t_goldengate_parameter_files.htm

 

NEW QUESTION 36
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. View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.
• B. View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.
• C. View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by all Replicat groups.
• D. GoldenGate deployments cannot use a shared wallet.

Answer: A

Explanation:
Explanation/Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ ggsci_commands042.htm#GWURF945 (see note)

 

NEW QUESTION 37
You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?

• A. A license key must be applied first.
• B. GoldenGate Manager was not started first.
• C. The incorrect version of GoldenGate was installed for your CPU architecture.
• D. The LD_LIBRARY_PATHvariable to $ORACLE_HOME was not set.

Answer: C

 

NEW QUESTION 38
Which method in GoldenGate should you use to undo DML changes previously made to a target database?

• A. Use Extract and Replicat with the GoldenGate Logdump utility.
• B. Use Extract and Replicat with the GoldenGate Reverse utility.
• C. Run the Reverse Utility on the target database transaction logs.
• D. Run Extract and Replicat from the command line.

Answer: B

Explanation:
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_backout.htm#GWUAD721

 

NEW QUESTION 39
You must locate the next good record header in a Logdump file. How should you do this?

• A. Logdump > GHDR ON
• B. Logdump > SCANFORENDTRANS
• C. Logdump >SCANFORGHDR
• D. Logdump > SCANFORHEADER

Answer: D

Explanation:
Explanation/Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GLOGD/using-logdump-utility.htm#GLOGD108

 

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

• A. Oracle Database 11.2.0.4 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 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater
• D. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater

Answer: A

 

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

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

Answer: A

Explanation:
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/
gg_parameters123.htm#GWURF1025

 

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

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

Answer: A

Explanation:
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters123.htm#GWURF1025

 

NEW QUESTION 43
Which three types of information are stored in the GoldenGate trial header?

• A. Relative byte address of the commit record
• B. Data type (e.g. integer, alphanumeric)
• C. Before or after image indicator
• D. Time of the transaction

Answer: A,B,C

Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

 

NEW QUESTION 44
You must locate the next good record header in a Logdump file. How should you do this?

• A. Logdump >SCANFORGHDR
  Logdump > GHDR ON
• B.
• C. Logdump > SCANFORENDTRANS
• D. Logdump > SCANFORHEADER

Answer: B

Explanation:
Explanation/Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GLOGD/using-logdump-utility.htm#GLOGD108

 

NEW QUESTION 45
What file must be configured in order to use custom encryption keys?

• A. ENCRYPT
• B. GLOBALS
• C. ENCKEYS
• D. CUSTKEYS

Answer: C

 

NEW QUESTION 46
You want to eliminate the reporting output from processing a Macro. How should you proceed?

• A. Use the optional parameter NOLIST.
• B. Use the optional parameter NOREPORT.
• C. Use the optional parameter NOMACROOUTPUT.
• D. Use the optional parameter UNLIST.

Answer: A

Explanation:
Explanation/Reference:
Reference: http://www.ateam-oracle.com/oracle-goldengate-using-macros/

 

NEW QUESTION 47
What Oracle GoldenGate feature provides recoverability without loss of
transactions?

• A. Sub-second latency
• B. Two-phase commits
• C. Checkpointing
• D. Transactional integrity

Answer: C

 

NEW QUESTION 48
What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

• A. KEYGEN file in the GoldenGate data location
• B. COBGEN file in the GoldenGate installation location
• C. GGSKEY file in the GoldenGate installation location
• D. ENCKEYS file in the GoldenGate installation location
• E. GGSKEY file in the GoldenGate data location

Answer: D

 

NEW QUESTION 49
You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

• A. Oracle Goldengate Application Adapters
• B. Oracle Goldengate Veridata
• C. Oracle Goldengate for Big Data
• D. Oracle Data Integrator Adapters

Answer: A

Explanation:
Explanation/Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/ GGS_Sect_Config_from_WinUX_ORA_to_AMQ_JMS.pdf

 

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

Answer: B

Explanation:
Explanation/Reference:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/
wu_performance.htm#GWUAD1131

 

NEW QUESTION 51
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. View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.
• 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. GoldenGate deployments cannot use a shared wallet.

Answer: A

 

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

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

Answer: D

 

NEW QUESTION 53
Which three are the responsibility of the MGR process? (Select three.)

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

Answer: B,C,D

 

NEW QUESTION 54
What software is required prior to running Oracle GoldenGate in a Windows Server environment?

• A. Microsoft Visual C++ 2010 SP1 Redistributable Package
• B. Oracle Gateway software configured for that particular database platform
• C. Nothing, configure GoldenGate Jagent for that particular database platform.
• D. JDBC drivers into the GoldenGate home directory

Answer: A

Explanation:
Reference:https://docs.oracle.com/goldengate/1212/gg-
winux/GIMSS/system_requirements.htm#GIMSS182

 

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

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

Answer: A

Explanation:
Reference:
http://forums.oracle.com/forums/thread.jspa?messageID=9297810

 

NEW QUESTION 56
Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?
DEFERAPPLYINTERVAL

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

Answer: D

Explanation:
Explanation/Reference: https://docs.oracle.com/en/cloud/paas/goldengate-cloud/gwuad/tuning-replicat-transactions.html

 

NEW QUESTION 57
......

New (2022) Oracle 1z0-447 Exam Dumps: https://examtorrent.testkingpdf.com/1z0-447-testking-pdf-torrent.html