1Z0-447 Online Practice Questions and Answers

You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works?

A. The Replicat with the FORMAT RELEASEparameter.

B. The Extract with the FORMAT RELEASE parameter.

C. The Extract to write directly to the remote trail.

D. The collector with the FORMAT RELEASEparameter.

Which syntax would you use in an OBEY script to stop a process without waiting for user input?

A. stop * noinput

B. stop immediate *

C. stop * !

D. stop force *

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.

When is a Pump not required to connect to a source database?

A. when transformations, filtering, and mapping are required

B. when look-ups are needed against the source database

C. when a PASSTHRU parameter is used

D. when a NOPASSTHRUparameter is used

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.

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.

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

What sequence of steps should you follow to add a data pump that reads from a local trail?

A. In GGSCI, on the source system, issue the command: ADDEXTRACTgroup name, TRAILSOURCE trail name.

B. In GGSCI, on the source system, issue the command: ADDPUMP group name, TRAILSOURCEtrail name.

C. In GGSCI, on the source system, issue the command: ADDPUMP group name, EXTTRAILSOURCEtrail

name.

D. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, EXTTRAILSOURCE trail name.

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

A. \\

B. //

C. -

D. \*

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