1z0-447 by Oracle Actual Free Exam Q&As

Question 1

When would you use the PASSTHRU parameter?

A. For a SPECIALRUN one-time processing task that is doing an initial load. B. When Extract is processing database transaction logs where you have a remote database connection. C. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat. D. When using a data pump to distribute all of the trail data "as is" to a remote system.

Discussion 0

Correct Answer: D Vote an answer

Question 2

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 3

Identify the correct statement regarding Trails.

A. Extracts cannot perform filtering, mapping, and transformations. B. RMTTRAILis for remote trails andEXTTRAILis for local trails. C. Extract is typically used to produce local trail files over a TCP/IP connection. D. Extract and Pump are different OS level executable binary files.

Discussion 0

Correct Answer: A Vote an answer

Question 4

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to-database utility. How should you configure GoldenGate in order to accomplish this?

A. Configure Replicat with theFORMATXML OPTION. B. Configure Replicat with theFORMATASCII SQLLOADER OPTION. C. Configure Extract with theFORMATASCII SQLLOADER OPTION. D. Configure Extract with theFORMATSQL SQLLOADER OPTION.

Discussion 0

Correct Answer: C Vote an answer

Question 5

What process is the recommended method to purge old GoldenGate trials?

A. Manager B. Replicat C. Manager and Replica D. Extract r

Discussion 0

Correct Answer: A Vote an answer

Question 6

How should you configure Replicat to control how errors are handled in one-way replication?

A. Use Conflict Detection and Resolution in the Replicat parameter file. B. UseMAPEXCEPTIONin the Replicat parameter file. C. UseHANDLECOLLISIONin the Replicat parameter file. D. UseREPERRORin the Replicat parameter file.

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which Logdump command is used to check how many change records are in the trail file?

A. REPORT B. COUNT C. STATS D. REPORTCOUNT

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. DDL for Replicat is enabled by default. B. GETDDL C. USEDDL D. TARGETDDL

Discussion 0

Correct Answer: A Vote an answer

Oracle GoldenGate 12c Implementation Essentials - 1z0-447 Exam Practice Test