1z0-447 practice test

1. Question 1 · 1

   You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?

   Choose one answer.

   • The incorrect version of GoldenGate was installed for your CPU architecture.
   • A license key must be applied first.
   • GoldenGate Manager was not started first.
   • The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set.

2. Question 2 · 1

   Identify the correct statement regarding Trails.

   Choose one answer.

   • Extract and Pump are different OS level executable binary files.
   • Extracts cannot perform filtering, mapping, and transformations.
   • RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
   • Extract is typically used to produce local trail files over a TCP/IP connection.

3. Question 3 · 1

   You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?

   Choose one answer.

   • Tables set with nologging
   • Tables with Large Object (LOB) data types
   • Tables that have conflicts
   • Triggers and sequences

4. Question 4 · 1

   You need to look up table definitions in a file. Which Replicat parameter should you use?

   Choose one answer.

   • ASSUMETARGETDEFS
   • COLMATCH
   • SOURCEDEFS
   • MAP

5. Question 5 · 1

   Which statement regarding the GoldenGate Data Pump is incorrect?

   Choose one answer.

   • Data Pump is a separate process.
   • Data Pump can be used to pump trail records to multiple locations.
   • Data Pump has distance limitations.
   • Data Pump uses TCP/IP to route the trail records.

6. Question 6 · 1

   You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

   Choose one answer.

   • File to Replicat
   • GoldenGate Direct Load
   • File to database utility
   • Direct bulk load to SQL*Loader

7. Question 7 · 1

   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?

   Choose one answer.

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

8. Question 8 · 1

   For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?

   Choose one answer.

   • Teradata
   • Informix
   • Sybase
   • DB2

9. Question 9 · 1

   Select four Oracle GoldenGate use cases.

   Choose all answers that apply.

   • real-time discovery
   • real-time data warehousing
   • offload reporting
   • zero downtime upgrades and migrations
   • backup and recovery
   • data center load balancing by using multi-master replication

10. Question 10 · 1

    GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?

    Choose one answer.

    • in the checkpoint file area
    • in the trail files area
    • in the server temporary file system
    • in the bounded recovery area

11. Question 11 · 1

    When is a Pump not required to connect to a source database?

    Choose one answer.

    • when transformations, filtering, and mapping are required
    • when look-ups are needed against the source database
    • when a PASSTHRU parameter is used
    • when a NOPASSTHRU parameter is used

12. Question 12 · 1

    Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

    Choose one answer.

    • Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
    • any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
    • Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
    • Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

13. Question 13 · 1

    How can you tell if GoldenGate has been configured for batch processing?

    Choose one answer.

    • The SPECIALRUN parameter is in the Replicat parameter file.
    • Replicat is started with the INITIALLOAD task.
    • There is a dedicated GoldenGate process called SPECIALRUN.
    • The SPECIALRUN parameter is in the GLOBALS parameter file.

14. Question 14 · 1

    Which replication topology requires conflict resolution?

    Choose one answer.

    • Broadcast
    • Consolidation
    • Master-to-Master
    • Cascading

15. Question 15 · 1

    An integrated Replicat is running with PARALLELISM set to four, yet you discover that for a series of large operations, only one apply server is processing the operations. What is the reason for this issue?

    Choose one answer.

    • Operations are grouped into one apply server automatically based on GROUPTRANSOPS.
    • Parallelism for an Integrated Replicat cannot exceed one.
    • The operations for a particular table are pinned to a specific apply server.
    • The operations are all part of one transaction.

Paid access to all 18 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.