1Z0-447 Online Practice Questions and Answers

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.

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

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.

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.

Identify two correct statements regarding GoldenGate supported features.

A. GoldenGate supports network encryption and compression.

B. GoldenGate supports DML and DDL replication for all supported databases.

C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

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.propertiesare 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

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

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT SHOWCH.How should you proceed?

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

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

A. Implement trail file encryption.

B. Ensure that passwords are encrypted.

C. Ensure that network communications are encrypted.

D. Ensure that table-level Transparent Data Encryption is implemented.

You want to eliminate the reporting output from processing a Macro. How should you proceed?

A. Use the optional parameter NOLIST.

B. Use the optional parameter UNLIST.

C. Use the optional parameter NOREPORT.

D. Use the optional parameter NOMACROOUTPUT.