1Z0-447 Online Practice Questions and Answers

You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates. How should you accomplish this?

A. Implement GoldenGate Monitor.

B. Have the customer continuously update the application data.

C. Monitor the GoldenGate lag and last checkpoint time statistics.

D. Implement heartbeat tables for replication.

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 all Replicat 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 key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT SHOWCH.How should you proceed?

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

Which GLOBALS parameter is required to initially enable monitoring?

A. JAGENTMONITORING

B. ENABLEMONITORING

C. ENABLEOEMMONITORING

D. CHECKMONITORING

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

In which process should you configure the warning for long-running transactions?

A. Jagent

B. Extract

C. Replicat

D. Manager

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 the OVERWRITE command.

B. Include the USEDELTA command.

C. Include the ADDTRANDATA command.

D. Include the UPDATAROWEXISTScommand.

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

With BATCHSQLenabled, what causes a Replicat to use normal mode operation?

A. statements with rows between 8k and 24k in length

B. when BATCHSQLand GROUPTRANSOPScoexist

C. statements which cause errors

D. when server memory < 8GB

Which other character, besides the COMMENT parameter, can you use to enter remarks in a parameter file?

A. \\

B. //

C. -

D. \*