1z0-447 sample questions

Question 1

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?

Accepted Answer

The Replicat with the FORMAT RELEASE parameter.

Answer

The Extract with the FORMAT RELEASE parameter.

Answer

The Extract to write directly to the remote trail.

Answer

The collector with the FORMAT RELEASE parameter.

Question 2

Which statement is valid for DDL replication?

Accepted Answer

Source and target objects can be different.

Answer

GoldenGate User Exits are not supported for DDL.

Answer

Target objects can be different from source when using SOURCEDEFS in Replicat.

Answer

It can use WILDCARDRESOLVE IMMEDIATE.

Question 3

Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?

Accepted Answer

SOURCEDB SourceDSN

Answer

TARGETDB TargetDSN USERID samplelD PASSWORD samplepword

Answer

SOURCEDB sampleDB USERID samplelD PASSWORD samplepword

Answer

TARGETDB samplelD samplepword

Question 4

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

Accepted Answer

ENABLE_GOLDENGATE_REPLICATION=true

Answer

ENABLE_STREAMS_REPLICATION=true

Answer

Configure the STREAMS_POOL_SIZE database parameter

Answer

ENABLE_DATABASE_REPLICATION=true

Question 5

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

Accepted Answer

stop * !

Answer

stop* noinput

Answer

stop immediate *

Answer

stop force*

Question 6

You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this?

Accepted Answer

Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci < input_file from the command line of the operating system, where the input_file is an OBAY text file.

Answer

Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI./ input_file, where the file name is the script file.

Answer

Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI < input_file, where the file name is an OBEY file.

Answer

Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci./ input_file from the command line of the operating system, where the file namei s the script file.

Question 7

You have a source table with a PRODUCTJD 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?

Accepted Answer

SQLEXEC ()

Answer

DBLOOKUP ()

Answer

DBLOGIN ()

Answer

SQLLOOKUP ()

Question 8

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

Accepted Answer

Run the chkpt_db_create.sql scrip

Accepted Answer

Use the ADD CHECKPOINTTABLE command

Answer

Run the chkpt_db_extracttrail.sql scrip

Answer

Use the ADD Extract Trail command

Answer

Use the INFO REPLICAT command with the SHOWCH option.

Question 9

Identify two correct statements regarding GoldenGate supported features.

Accepted Answer

A GoldenGate supports network encryption and compressio

Accepted Answer

GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source

Answer

GoldenGate supports DML and DDL replication for all supported database

Answer

GoldenGate for SQLServer supports only SQLServer Standard Edition as a source

Question 10

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

Accepted Answer

Manager

Answer

Replicat

Answer

Extract

Answer

Extract and Replicat

1z0-447 Sample Questions & Answers

Ready for the real thing?

1z0-447 Sample Questions & Answers

Related practice tests

Ready for the real thing?