1Z0-447 Real Exam Questions and Verified Answers

Question 1 Multiple choice

Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.)

A
MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));
B
MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
C
TABLE fin.Sales, FILTER (@RANGE (1, 2));
D
FILTER (@RANGE (2, 2, AccountID));
E
FILTER (@RANGE 2, 2, ID);

Show answer and explanation

Correct answers: A, B, C

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/column_conversion_functions022.htm#GWURF809

Question 2 Single choice

You need to manually patch Oracle GoldenGate source and targets.

How should you proceed?

A
Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. If the patches changed table definitions, run DEFGEN for the source tables to generate updated source definitions, and then replace the old definitions with the new ones in the existing source definitions file on the target system. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
B
Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
C
Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
D
Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

Show answer and explanation

Correct answer: A

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_adminops.htm#GWUAD701

Question 3 Single choice

What is the key purpose of GoldenGate trail files?

A
They are a persistent storage area for captured transactions.
B
They are configuration files for the GoldenGate processes.
C
They are checkpoint files for the GoldenGate processes.
D
They are database auditing logs where GoldenGate captures changes.

Show answer and explanation

Correct answer: C

Question 4 Single choice

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

A
\\
B
//
C
- -
D
\*

Show answer and explanation

Correct answer: C

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters027.htm#GWURF426

Question 5 Single choice

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

A
Jagent
B
Extract
C
Replicat
D
Manager

Show answer and explanation

Correct answer: B

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters015.htm#GWURF410

Question 6 Single choice

Which GLOBALS parameter is required to initially enable monitoring?

A
JAGENTMONITORING
B
ENABLEMONITORING
C
ENABLEOEMMONITORING
D
CHECKMONITORING

Show answer and explanation

Correct answer: B

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters053.htm#GWURF474

Question 7 Multiple choice

Which three are the responsibility of the MGR process? (Select three.)

A
Process management
B
Trail File management
C
Data movement
D
Receive or route requests from the UI
E
Trigger execution

Show answer and explanation

Correct answers: A, B, C

Question 8 Single choice

Which statement is valid for DDL replication?

A
GoldenGate User Exits are not supported for DDL.
B
Source and target objects can be different.
C
Target objects can be different from source when using SOURCEDEFS in Replicat.
D
It can use WILDCARDRESOLVE IMMEDIATE.

Show answer and explanation

Correct answer: B

Question 9 Single choice

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

A
statements with rows between 8k and 24k in length
B
when BATCHSQL and GROUPTRANSOPS coexist
C
statements which cause errors
D
when server memory < 8GB

Show answer and explanation

Correct answer: B

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters011.htm#GWURF404

Question 10 Single choice

You are experiencing an issue with the downstream database server for the Integrated Capture Downstream Model.

Which step should you take to resolve the issue?

A
Ensure that the Oracle database version on the downstream database server is the same version as the source Oracle version.
B
Ensure that the platform type of the downstream database server is the same platform as the source database server.
C
Ensure that the GoldenGate version used on the downstream database server is the same version used on the source database server.
D
Ensure that the GoldenGate version used on the downstream database server is the same version used on the target database server.

Show answer and explanation

Correct answer: B

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/ic_deploy.htm#GIORA472