1z0-447 sample questions

Question 1

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?

Accepted Answer

Create a GLOBALS file for each installation and use the MGRSERVNAME parameter, with a unique name.

Answer

Include the parameter SERVICENAME in each Manager, with a unique name.

Answer

Accept the default service name and manually edit within the Services applet.

Answer

Multiple Manager services are not allowed on the same Windows server.

Question 2

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

Accepted Answer

Oracle Goldengate Application Adapters

Answer

Oracle Goldengate for Big Data

Answer

Oracle Goldengate Veridata

Answer

Oracle Data Integrator Adapters

Question 3

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

Accepted Answer

Microsoft Visual C++2010 SP1 Redistributable Package

Answer

Oracle Gateway software configured for that particular database platform

Answer

JDBC drivers into the GoldenGate home directory

Answer

Nothing, configure GoldenGate Jagent for that particular database platform.

Question 4

Which statement regarding the GoldenGate Data Pump is incorrect?

Accepted Answer

Data Pump is a separate process.

Answer

Data Pump can be used to pump trail records to multiple locations.

Answer

Data Pump has distance limitations.

Answer

Data Pump uses TCP/IP to route the trail records.

Question 5

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

Accepted Answer

Ensure that table-level Transparent Data Encryption is implemented.

Answer

Implement trail file encryption.

Answer

Ensure that passwords are encrypted.

Answer

Ensure that network communications are encrypted.

Question 6

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 7

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 8

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 9

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 10

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*

Top vendors

Top exams

Free 1z0-447 sample questions