1Z0-447 | High quality Oracle 1Z0-447 practice test

New Questions 4

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 usingSOURCEDEFSin Replicat.

D. It can useWILDCARDRESOLVE IMMEDIATE.

Answer: B

New Questions 5

Which parameter for GoldenGate 12c enables DDL replication for a Replicat?

A. TARGETDDL

B. GETDDL

C. DDL for Replicat is enabled by default.

D. USEDDL

Answer: C

New Questions 6

What is the default format for a GoldenGate trail?

A. ASCII:ASCII format

B. INPUT ASCII: from 1to 127 representing ASCII characters

C. SQL: SQL statements

D. CDF: Canonical Data format

E. XML: XML statement

Answer: A

New Questions 7

Which GLOBALS parameter is required to initially enable monitoring?

A. JAGENTMONITORING

B. ENABLEMONITORING

C. ENABLEOEMMONITORING

D. CHECKMONITORING

Answer: B

New Questions 8

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

A. Oracle Goldengate for Big Data

B. Oracle Goldengate Application Adapters

C. Oracle Goldengate Veridata

D. Oracle Data Integrator Adapters

Answer: B

New Questions 9

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

Answer: C

New Questions 10

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

Answer: B C D F

New Questions 11

Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

A. View the maybe out-of-sync (MOOS) queue.

B. View the Veridata log file.

C. View the confirm-out-of-sync (COOS) queue.

D. View the Veridata Agent repository.

Answer: A

New Questions 12

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

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

Answer: C

New Questions 13

Which three types of information are stored in the GoldenGate trial header?

A. Before or after image indicator

B. Data type (e.g. integer, alphanumeric)

C. Relative byte address of the commit record

D. Time of the transaction

Answer: A B C