Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 41:

  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

  Correct Answer: D

• Question 42:

  You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with “ajava.lang.Exception: One or more Java Agent properties in Config.propertiesare not defined properly”.

  What is the first thing to check?

  A. if The Enterprise Manager Agent is running

  B. if the JAgent has been enabled in the GoldenGate Manager

  C. if the agent type is set to OEM in JAgent properties

  D. if the Oracle Wallet has been created for the JAgent

  Correct Answer: C

• Question 43:

  Which three are valid Extract or Replicat statements using the @RANGEfunction for an Acct table with a Primary Key on the AccountID column? (Select three.)

  A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

  B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

  C. TABLE fin.Sales, FILTER (@RANGE (1, 2));

  D. FILTER (@RANGE (2, 2, AccountID));

  E. FILTER (@RANGE 2, 2, ID);

  Correct Answer: ABC

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ column_conversion_functions022.htm#GWURF809

• Question 44:

  Which parameter for GoldenGate 12c enables DDL replication for a Replicat?

  A. TARGETDDL

  B. GETDDL

  C. DDL for Replicat is enabled by default.

  D. USEDDL

  Correct Answer: C

  Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/using-ddl

  replication.htm#GGHDB-GUID-C80382D7-A0D6-4C89-BAC8-B03023F9A313

• Question 45:

  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 the COMPCOLSwith the GETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHEREclause.

  B. Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

  C. Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

  D. Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.

  Correct Answer: B

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/ conflict_resolution.htm#GWUAD317

• Question 46:

  You need to look up table definitions in a file. Which Replicat parameter should you use?

  A. ASSUMETARGETDEFS

  B. COLMATCH

  C. SOURCEDEFS

  D. MAP

  Correct Answer: C

• Question 47:

  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 the SPECIALRUN parameter.

  D. You can configure integrated Replicat with ASSUMETARGETDEFSand SPECIALRUNparameters.

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/process_mode.htm#GIORA219

• Question 48:

  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.

  Correct Answer: A

• Question 49:

  Identify two correct statements regarding GoldenGate supported features.

  A. GoldenGate supports network encryption and compression.

  B. GoldenGate supports DML and DDL replication for all supported databases.

  C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

  D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

  Correct Answer: AC

• Question 50:

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

  A. Use REPERROR in the Replicat parameter file.

  B. Use HANDLECOLLISION in the Replicat parameter file.

  C. Use Conflict Detection and Resolution in the Replicat parameter file.

  D. Use MAPEXCEPTION in the Replicat parameter file.

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/ wu_errorhandling.htm#GWUAD502