1Z0-447 Online Practice Questions and Answers

You edit the GLOBALS file, save the changes, and restart GGSCI to have the change take effect. However, when you try to start the Manager, it fails. Which action should solve the problem?

A. Use the CLEANUPREPLICATcommand.

B. Use a text editor to check the GLOBALS file for syntax errors and correct them.

C. Verify that Oracle environment variables are set correctly.

D. Add the Oracle GoldenGate Installation directory to the system PATH.

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.

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. Replicat

C. Extract

D. Extract and Replicat

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.

GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?

A. in the checkpoint file area

B. in the trail files area

C. in the server temporary file system

D. in the bounded recovery area

You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?

A. Implement trail file encryption.

B. Ensure that passwords are encrypted.

C. Ensure that network communications are encrypted.

D. Ensure that table-level Transparent Data Encryption is implemented.

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

A. The GGSCI session was configured incorrectly.

B. The Manager parameter file contains SYSLOG ALL.

C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

D. The user session running Manager is set to log all messages.

You must prepare the source database to send redo to the mining database. What sequence of steps should you follow to accomplish this?

A. Ensure that the source database is running with the required compatibility. Use the TRANSLOGOPTIONS parameter, set up redo transport at the source database, and enable the downstream destination.

B. Ensure that the source database is running with the required compatibility. Set DB_CONFIG at the source database. Set up redo transport at the source database.

C. Set DG_CONFIG at the source database and enable the downstream destination.

D. Ensure that the source database is running with the required compatibility. Set DG_CONFIG at the source database. Set up redo transport at the source database and enable the downstream destination.

You have a source table with a PRODUCT_ID column and a target table with PRODUCT_DESCRIPTION

column. On the target database, there is a lookup table containing product codes and corresponding

descriptions.

What should you use to look up the PRODUCT_DESCRIPTION for each transaction?

A. SQLEXEC ( )

B. DBLOOKUP ( )

C. DBLOGIN ( )

D. SQLLOOKUP ( )

Which three are requirements to correctly configure an OGG trail file? (Choose three.)

A. a trail file identifier

B. designation as local or remote

C. a maximum file size

D. an Extract process

E. a Replicat process