VCEdump

1Z0-447 Oracle GoldenGate 12c Implementation Essentials

PDF question preview Back to product

Reading controls

Reader tools

Free demo

13 of 81 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice12

Multiple choice1

Oracle · 1Z0-447

Free 1Z0-447 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

You want to use multiple concurrent Extract process groups.

What is the key factor in determining how many can be running at the same time?

A
the number of concurrent users
B
disk space
C
system memory
D
the number of compound keys on the source tables

Reveal answer details Close answer details

Correct answerC

Explanation

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

Question 2

Single choice

Which command provides statistics about GoldenGate processes and memory resource utilization?

A
SEND...CACHEMGR
B
SEND...LOGSTATS
C
SEND...GETTCPSTATS
D
INFO...SHOWCH

Reveal answer details Close answer details

Correct answerA

Question 3

Single choice

What is the purpose of a VAM parameter?

A
It specifies that a Vendor Access Module is being used to perform data transformation functions.
B
It specifies that a Vendor Access Module is being used to perform data capture functions.
C
It specifies that a Virtual Access Module is being used to perform data capture functions.
D
It specifies that Virtual Application Memory is being used to perform data replication functions.

Reveal answer details Close answer details

Correct answerB

Explanation

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

Question 4

Single choice

You must synchronize the starting point for Replicat with the restore point of the target database.

How should you accomplish this?

A
Use the command option AFTERCSN.
B
Use the command option ATCSN.
C
Use the command option UNTIL CANCEL.
D
Use the command option RESUME.

Reveal answer details Close answer details

Correct answerA

Question 5

Multiple choice

Select four Oracle GoldenGate use cases.

A
real-time discovery
B
real-time data warehousing
C
offload reporting
D
zero downtime upgrades and migrations
E
backup and recovery
F
data center load balancing by using multi-master replication

Reveal answer details Close answer details

Correct answersB, C, D, F

Question 6

Single choice

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 NOPASSTHRU parameter is used

Reveal answer details Close answer details

Correct answerB

Question 7

Single choice

You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with "ajava.lang.Exception: One or more Java Agent properties in Config.properties are not defined properly".

What is the first thing to check?

A
if The Enterprise Manager Agent is running
B
if the JAgent has been enabled in the GoldenGate Manager
C
if the agent type is set to OEM in JAgent properties
D
if the Oracle Wallet has been created for the JAgent

Reveal answer details Close answer details

Correct answerC

Question 8

Single choice

Which option is an invalid GLOBALS parameter?

A
DISCARDFILE
B
GGSCHEMA
C
MGRSERVNAME
D
CHECKPOINTTABLE

Reveal answer details Close answer details

Correct answerA

Explanation

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

Question 9

Single choice

Which option is supported by GoldenGate DDL replication?

A
CREATE ROLE
B
ALTER SYSTEM
C
ALTER DATABASE
D
ALTER TABLE SYS

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/using-ddl-replication.htm#GGHDB-GUID-B7A3B3AF-B5DE-47B3-8B0F-C6D5FCB5388C

Question 10

Single choice

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

A
Oracle Gateway software configured for that particular database platform
B
JDBC drivers into the GoldenGate home directory
C
Microsoft Visual C++ 2010 SP1 Redistributable Package
D
Nothing, configure GoldenGate Jagent for that particular database platform.

Reveal answer details Close answer details

Correct answerC

Explanation

References:
https://docs.oracle.com/goldengate/1212/gg-winux/GIMSS/system_requirements.htm#GIMSS182

Question 11

Single choice

You must return column-level detail for out-of-sync rows.

How can you accomplish this?

A
The Oracle GoldenGate Veridata Agent executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
B
The Oracle GoldenGate Veridata Manager executes auto-memory database-related requests on behalf of the Oracle GoldenGate Veridata Server.
C
The Oracle GoldenGate Veridata Agent source database executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
D
The Oracle GoldenGate Veridata Manager executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.oracle.com/goldengate/v1221/gg-veridata/GVDAD/about_ogg_veridata.htm#GVDAD114

Question 12

Single choice

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

Reveal answer details Close answer details

Correct answerC

Question 13

Single choice

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 CLEANUP REPLICAT command.
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.

Reveal answer details Close answer details

Correct answerC

Free 1Z0-447 Exam Dumps Preview

Oracle GoldenGate 12c Implementation Essentials

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

VOL	TYPE	QUESTIONS
1	Single choice	12
2	Multiple choice	1